Frequently Asked Questions

I've compiled a list of the questions that I get asked most frequently. If you have a question that I haven't answered or you need a more detailed answer, you can comment on www.dba-db2.com or contact me. Please read through to see if I've answered it already. FAQs were lasted updated on 9th July 2012 What is your current job situation? I am a Senior DBA in a large financial institution. I've been in this role full time for 3 years. What are your responsibilities in this role? I manage over 200 database servers and a team of DBAs onshore... Read more →

db2start at start up on Linux

To manage db2start on all DB2 instances on a server , there is a workaround to use. This is not standard way of managing db2start , but I have found the method useful. If you are using Clustering software such as Tivoli Storage Automation (TSA) , then the TSA scripts manage the db2start process. 1) Create a shell script and place this code in the script. I call it “db2.sh” , any name is OK. #! /bin/sh for i in `/opt/ibm/db2/V9.5/bin/db2ilist`; do su - $i -c "db2start" done 2) Place the script in the “/etc/init.d” directory and apply relevant execution... Read more →

DB2 PRUNE HISTORY

Use PRUNE HISTORY Command to delete history file entries 1) Consider using if : The history file becomes excessively large 2) Consider using if: Retention period is high 3) Do not Delete “db2rhist.asc” or “db2rhist.bak” 4) Do a proper analysis of restore requirements prior to PRUNE HISTORY Example : Prior to the PUNE HISTORY I execute the command : PRUNE HISTORY 20110701 This removed all entries for restores, loads, tables space backups and full database backups Read more How to use Db2adutl delete logs - DBA DB2 Manage DB2 backups retention policy - DBA DB2 TSM losing connection with DB2... Read more →

ADM6044E - DMS Container Space Full

On Database Managed tablespaces you may receive a message : ADM6044E DMS Container Space Full From the application side you may get something like: [ERROR]Unable to allocate new pages in table space This usually means free pages = 0 . Check the db2diag.log file , and the related message is ADM6044E The DMS table space "MYDATA" (ID "3") is full. If this is an autoresize or automatic storage DMS tablespace, the maximum table space size may have been reached or the existing containers or storage paths cannot grow any more. Additional space can be added to the table space by... Read more →

List table constraints in DB2

To list table constraints in DB2 1.Connect to your database 2. SELECT * FROM SYSCAT.TABCONST Author: Jack Vamvas(http://www.dba-db2.com) Read more →