by XTIVIA | Apr 13, 2016 | Blog, Data Management, Databases
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine...
by XTIVIA | Apr 7, 2016 | Blog, Databases
It may be something that’s not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a schema and all of the objects in that schema used to be tedious and time-consuming. We used to have to look for a...
by XTIVIA | Mar 31, 2016 | Applications, Blog, Portals
There are times when you want to handle multiple Liferay API calls as a single, atomic transaction. For example, let’s say you have a business process that has the following 3 steps: Create an Organization. Add a Role to the User. Update the User’s...
by XTIVIA | Mar 31, 2016 | Blog, Databases
When taking a backup of a DB2 LUW database, there are a lot of options to choose from. I like to specify as many as possible to make it clear exactly what I want, even if I am specifying the defaults. Though I very rarely specify the number or size of backup buffers,...
by XTIVIA | Mar 22, 2016 | News
XTIVIA Makes Denver Business Journal’s List – Top 20 Software Development Firms CENTENNIAL, Colo. – March 22, 2016 – PRLog — XTIVIA Inc. is sixth on the Denver Business Journal’s list of Top Software Development companies as ranked...
by XTIVIA | Mar 22, 2016 | News
CENTENNIAL, Colo. – March 22, 2016 – PRLog — XTIVIA Inc. is sixth on the Denver Business Journal’s list of Top Software Development companies as ranked by ‘local area’ revenue. XTIVIA’s Denver office makes up about a fifth of company revenue with other offices across...
by XTIVIA | Mar 17, 2016 | Blog, Databases
I can’t remember the last time a ulimit bit me, but the time has come again. Everyone is used to removing all the limits for the instance ID at this point, I hope, but have you ever considered the ulimits for your fenced user id? The Problem In the DB2...
by XTIVIA | Mar 3, 2016 | Blog, Databases
Error Message SQL0964C The transaction log for the database is full. SQLSTATE=57011 or DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction log for...
by Michael Hahn | Feb 21, 2016 | Blog, Portals
If you have custom code for rendering Liferay web content, you may not know it but you may not be leveraging Liferay caching for the rendered web content, and this may be at the root of some performance problems in your Liferay environment. Recently, one of our...
by XTIVIA | Feb 18, 2016 | Blog, Databases
Error Message SQL0968C The file system is full. This is frequently an error that is returned to an application and reported simply as -968 When You Might Encounter This Error Message This error typically is encountered when updating or inserting data, though in some...
by XTIVIA | Feb 17, 2016 | Blog, Databases
Securing your data is very important and database encryption is just part of that landscape. Taking advantage SQL Server database encryption can be a daunting task but once it is configured it is also important to monitor it. This query is intended to...
by XTIVIA | Feb 17, 2016 | Blog, Databases
SSMS Shortcut is what we are going to be learning about in this blog post. When writing T-SQL it can be quite distracting to go look up a table definition or information on a database object. Enter the SQL Server Management Studio (SSMS) shortcut key ALT + F1....
