How to check DB2 LUW load status

Question: How can I check load status in DB2 LUW? Answer: Checking the DB2 LUW load status is achieved by using the load query command. The best way to explain is by demonstrating with a simple example. The DB2 LUW command is used to load data into a DB2 LUW table. The data can be stored in many different forms – including named pipe and tape Starting the load process connect to mydb; create table table2 like table1; load from somedata.del of del insert into table2; While the load process is in flight , create another connection and view the... Read more →

Cannot drop database SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

I cannot drop the database and getting the error message SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019 What is the safest way to work around this problem? Answer: The DB2 error message appears because the current database is not a valid state for the DROP DATABASE command you’re attempting to commit. From the IBM DB2 LUW documentation “The database must not be in use; all users must be disconnected from the database before the database can be dropped”. Before you deactivate the database , speak with the application owner and... Read more →

Restore a DB2 LUW database without a DB2 backup copy from filesystem backup

Question: A developer corrupted some data and requested a restore to a previous recovery point. A standard request. When checking the backup system , there were no backup copies available. The backups had been failing for the last couple of nights and the monitoring alerts were not working. I checked around the backup history file , in case any ad-hoc backups had completed, and there none available. As a last resort I checked if there had been a flat file backup , and amazingly there was a flat file backup of all the files on the server. This is unusual... Read more →

HOW TO clear inactive DB2 LUW transaction log files

How to clear inactive DB2 LUW transaction log files is a solution to a common problem. Before we discuss how to prune the inactive transaction logs we’ll need to establish which log files are inactive. It is important to identify which logs to delete. If you delete an active transaction log file, you will cause an outage on the database Note: Log files located in the transaction log path cannot be removed with 'db2 prune history xxxxxxx and delet' if database configuration 'LOGARCHMETH1' is set to 'LOGRETAIN'. Before you start any activity , speak to the owners and users of... Read more →

How to set up Avamar and DB2 backup object retention

I was configuring a DB2 LUW database to work with Avamar as the backup system. An issue arose about managing the DB2 database backup retention period. Does DB2 LUW or Avamar control the retention period for a DB2 LUW database? For some comparison , I’ll outline briefly how TSM is configured with DB2 LUW. If I set the NUM_DB_BACKUPS, REC_HIS_RETENTN, AUTO_DEL_REC configurations and values in a DB2 database and use TSM , then these values have a direct impact on the TSM retention. In a typical TSM configuration , the usage AUTO_DEL_REC_OBJ will delete the objects from TSM once the... Read more →