home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC72891 Status: Closed

IN DB2 V9.7, DB2DART MAY NOT REPORT CERTAIN ERRORS AT THE END OF THE REPORT

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In certain circumstances, some db2dart errors may not be 
reported at the end of the db2dart report.  For instance, in 
dumping a specific page index page of the database, a SQLB_CSUM 
error is detected and reported, but the error is not included in 
the summary information at the bottom of the report. 
 
 
db2dart SAMPLE /di /tsi 74 /oi 30 /np 1 /ps 102825 /v  y: 
 
FYI: An active connection to the database has been detected. 
     False errors may be reported. 
     Deactivate all connections and re-run to verify. 
 
Warning: The database state is not consistent. 
 
Warning: Errors reported about reorg rows may be due to the 
inconsistent state of the database. 
Connecting to Buffer Pool Services... 
 
   Index object report phase start. 
   Dump format is verbose. 
 
   Error: CSUM read error for pool page 102825, from object ID 
30, pool 74, 
 
 
______________________________________ 
 
      Index Object page: 102825 
      BPS pool page    : 102825 
      BPS object page  : 102825 
 
 
<snip> 
 
 
______________________________________ 
   Index object report phase end. 
 
                     ______________________________________ 
 
         The requested DB2DART processing has completed 
successfully! 
                     All operation completed without error; 
                   no problems were detected in the database. 
                     ______________________________________
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Same as above                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to a fix pack or release containing the fix.         * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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

Solution
Problem was first fixed in Version 9.7 Fix Pack (pending).
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC72909 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.11.2010
28.04.2011
28.04.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP(
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.4 FixList