Database Blogs

Analyzing Lock Escalation

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,...

read more

Timing Your SQL Server Maintenance Jobs

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 is going to be times when you are going to need to run maintenance on your server. The tricky part is trying to...

read more

Stopping Your SQL Server Jobs

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...

read more

Dropping a DB2 Schema and Objects it Contains

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 large...

read more

SQL2032N When Backing Up a DB2 Database

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,...

read more

ENOMEM by db2fmp in db2diag.log

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 diagnostic log,...

read more

DB2 LUW Error Message: SQL0964C

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...

read more

DB2 LUW Error Message: SQL0968C

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...

read more

Need more information? Let's Talk Today!


XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.