Database Migrations to Azure

Database Migrations to Azure

As businesses increasingly move to the cloud, many are looking to migrate their on-premises databases to Azure. There are a number of reasons for this, including: Cost savings: Azure offers a pay-as-you-go pricing model, which can save businesses money on their...
Analyzing Lock Escalation

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,...
Dropping a DB2 Schema and Objects it Contains

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