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...
SQL2032N When Backing Up a DB2 Database

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,...
Allocation of Primary Logs in DB2

Allocation of Primary Logs in DB2

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...
How to Connect to a DB2 Database

How to Connect to a DB2 Database

To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is...

Informix DRDA Connections

One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol.   They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the...