The Backup failed

Database Backups onto disk\tape off site remains the cornerstone of a Database Server Disaster Recovery. Any DBA knows that having a backup strategy based on the Recovery Point Objective (RPO) is a necessary task. Not having a properly executed and regularly verified strategy is a cardinal sin. Most aspects of database server management are excusable, but non-existent databases restores is a definite DBA error. Take the DBA Ignorance , complacency and arrogance experiment Daily checks on backup success\failure is one of the the first job a DBA should complete. If a failure has occurred – then investigate the root cause.... Read more →

How to monitor a DB2 REORG

Question: How do I monitor a DB2 REORG , such as the following statement? reorg table SYSIBM.SYSCOLGROUPS inplace allow write access start Answer: Use the db2pd REORGS option. An example is : db2pd -d MYDB –reorgs The resultset returns eleven columns. The “status” column – is useful. It is possible to pause, stop, resume the REORG. Be careful with STOP , as you cannot resume the REORG and will have to restart. Some example commands are : db2 reorg table SYSIBM.SYSCOLGROUPS inplace pause db2 reorg table SYSIBM.SYSCOLGROUPS inplace resume db2 reorg table SYSIBM.SYSCOLGROUPS inplace stop Read More on reorg, table... Read more →

DB2 LUW TRUNCATE TABLE

I was reviewing some DB2 DBA scripts and noticed the usage of the old-school TRUNCATE method. ALTER TABLE schema.table_name activate not logged initially with empty table Since DB2 9.7 – there is now the TRUNCATE TABLE command. TRUNCATE TABLE WHLOGS IGNORE DELETE TRIGGERS DROP STORAGE IMMEDIATE Read more →

How to fix DIA8052C the Event Monitor has reached its file capacity

Question: This DB2 error message appears in the DB2Diag.LOG file ZRC=0x800D002B=-2146631637=SQLM_RC_EVFULL "monitor full of data" DIA8052C The Event Monitor "" has reached its file capacity. Delete the files in the target directory "" or move them to another directory. How can I fix it? Answer: There’s probably a limit on the event monitor size. To check the current size – connect to the database and issue the statement: SELECT * FROM SYSCAT.EVENTMONITORS Find the event monitor name under the EVMONNAME column. The main two options are to 1) Delete or move the event files in the target directory 2) Recreate... Read more →

DB2 Tuning Toolkit – db2exfmt

db2exfmt - Explain Table Format Command - gives information needed to tune the query .One of the DBA objectives is to decrease the query cost. Decreased query cost equals quicker user response. Decreasing the query cost – improves overall performance. Read the post - DB2 Tuning Toolkit – db2expln - to analyse the accesspath for a specific query. Read the post - DB2 Tuning Toolkit – DB2 Design advisor - Ddb2advis - for index recommnedations A syntax and process example: Step 1 – Create the source file Put a query in a input file called index.sql. This is just a... Read more →