How to use db2diag command line option for time

Question: A vendor has requested a snippet from db2diag log. The file needs to include all the db2diag log entries between 00:00:00 and 01:10 from 1 week ago. I checked the file and the timeframe is available – but there are thousands of entries around that time , and so it is time consuming to extract the details. Is there a way with db2diag command line option to extract between a start and finis time? Answer: db2diag command line options offers a wider range of methods to interrogate and extract details. There is a command line option –time , which... Read more →

The case of the rapidly expanding TEMPSPACE1 tablespace

An application install was forcing the TEMPSPACE1 to fill very quickly and constantly getting to the system disk is full error. The query was crashing as disk full limits were stopping the query to finish successfully.The db2diag log entries were referencing ADM6017E The following table space is full. Table space name TEMPSPACE1. Disk is full A sql trace captured the query running during this activity. Within the query there was a scalar function.I used the query on How to list UDF in DB2 and returned the routine body. An examination of the routine revealed some useful details. The routine accepted... Read more →

Difference db2diag log and nfy administration notification log

Question: What’s the difference between the db2diag log and the DB2 instance nfy administration log file? Answer: In summary: The Administration notification log (nfy ) file reports on a significant event for a DB2 instance. The db2diag log presents diagnostic details about errors. When troubleshooting a db2 error the db2diag log files has detailed information, The level of detail is reliant on the DIAGLEVEL applied to the instance The level of information in the nfy file usually is accompanied by the DB2 error code. Typical activity recorded is storage issue, indexing activities and DB2 table errors. For a full list... Read more →

How to search db2diag tool for a specific timeframe

The backup administrator was troubleshooting a DB2 backup failure with the vendor and requested the db2diag output for a specific timeframe . The steps I took to extract the information from the db2diag tool were: Log on to the DB2 LUW instance with a suitable logon account. Go to the path of the db2diag log. Normally the db2diag log location is sqllib/db2dump but you can also check the db2 dbm cfg command. Look for the DIAGPATH parameter value. If you’re on Linux you can use the grep command - db2 get dbm cfg | grep DIAGPATH Once you have moved... Read more →

Methods to find TSAMP error details and return codes

Question: How can I find details about TSAMP (Tivoli System Automation for Multiplatforms) failover details? I discovered that a failover occurred and need, what sources will give me details? I have a TSA single storage solution in place Answer: There are multiple methods to extract details about a failover details. If you troubleshooting , it may be necessary to correlate details from different sources. These sources of information are a good starting point for diagnostics. /var/ct/IBM.RecoveryRM.log Linux error logs on /var/logs/messages tail -f /var/log/messages Db2diag log files Instance_name.nfy file Read More on TSAMP TSAMP Cheat Sheet for DBA managing DB2... Read more →