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:

1. Log on to the DB2 LUW instance with a suitable logon account.
2. 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
3. Once you have moved to the DIAGPATH location , you’ll be able to execute the db2diag command. In this db2diag command example , you’ll need to know the specific timeframe and write the command with certain time format

--search all db2diag between the 24th January 2017 19:00   to 24th January 2017 23:59:59

db2diag  -time 2017-01-24-19.00:2017-01-24-23.59.59

--search all db2diag between the 24th January 2017 19:00   to 24th January 2017 23:59:59 
--restricting the search just for my database DB1

db2diag -g db=DB1 -time 2017-01-24-19.00:2017-01-24-23.59.59

The amount of detail in the db2diag will be dependant on the DIAGLEVEL setting. A useful skill to develop is Analyzing a DB2 trap file

 Read More

db2diag.log file delete on Linux and DB2

DB2 – Managing Diagnostic Logs

How to display DB2 db2diag.log appended records using follow ...