DB2 FOR LUW / DB2FORLUW / 970 - DB2

To improve the db2cklog tool to provide further diagnostic 
information, ie: it will display the last log file that was 
written to - this is important for servicability.  It's also an 
important piece of info that customers would like to see, but 
currently they need to start the database and get this info via 
db2pd. 
 
Change directory to location of Database Control files and then 
look to run: 
 
$ db2cklog check -m 
 
 
________________________________________________________________ 
____ 
 
                      _____     D B 2 C K L O G     _____ 
 
                            DB2 Check Log File tool 
                                 I    B    M 
 
 
          The db2cklog tool is a utility can be used to test the 
integrity 
        of an archive log file and to determine whether or not 
the log file 
                  can be used in the rollforward database 
command. 
 
 
________________________________________________________________ 
____ 
 
 
________________________________________________________________ 
________________ 
 
Last Write Extent Number = 2 
 
 
"db2cklog": Finished processing log file "S0000000.LOG". Return 
code: "0". 
========================================================

**************************************************************** 
* USERS AFFECTED:                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 FIxpack 6 or Higher                          * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in v9.7 Fixpack 6

not known / see Local fix

n/A

forerunner  : APAR is sysrouted TO one or more of the following: IC84290 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

03.11.2011
11.07.2012
11.07.2012

9.7.FP6