by XTIVIA | May 5, 2016 | Blog, Databases
Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said “What’s wrong with DB2? my query is running long! Are there lock timeouts happening?”...
by XTIVIA | Apr 21, 2016 | Blog, Databases
What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When there is not enough room in the lock list to store additional locks that an application needs to continue processing,...
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 | 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 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 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 4, 2016 | Blog, Databases
Error Message SQL1024N A database connection does not exist. SQLSTATE=08003 or sometimes: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database...
by XTIVIA | Jan 27, 2016 | Blog, Data Management, Databases
Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total...
by XTIVIA | Jan 21, 2016 | Blog, Databases
DB2 LUW Error Messages are some of the more descriptive ones I have seen in the computing world, but maybe everyone thinks that about their chosen specialty. Truly understanding error messages can take a bit of practice and knowledge, so I thought I would share a few...
