IZ25342: DB2DART COMMANDS IN DB2DIAG.LOG HAVE INCORRECT INFORMATION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When DB2 encounters problems on index or data pages, suggested
    DB2DART commands are written to the db2diag.log, intended to be
    used to collect further information.  The instruction that is
    written to collect data pages has incorrect information - the
    tablespace id and object id are reversed.  For example:
    2008-05-03-05.45.28.273326-240 I35955437E663      LEVEL: Severe
    PID     : 14886                TID  : 183041513728PROC :
    db2agntp (MYDB) 5
    INSTANCE: dummy                NODE : 005         DB   : MYDB
    APPHDL  : 11-1670              APPID: GAA31AAB.K998.080503094449
    AUTHID  : dummy
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_string, probe:0
    DATA #1 : String, 157 bytes
    Running the following command before and after restart database
    may provide useful problem determination information.
    Replace DBNAME with the real DB name.
    DATA #2 : String, 97 bytes
    db2dart DBNAME /dd /tsi 175 /oi 9 /ps 1631583p /np 1 /v y /scr n
    /rptn dTsi175oi9pg1631583p+0.rpt
    .
    The pool and object ids are backwards - it should be /tsi 9 /oi
    175.
    

Local fix

  • When issuing the db2dart /dd command, swap the /tsi and /oi
    parameters.
    

Problem summary

  • Users affected: All
    Problem description: Diagnostic messages instructing use of
    db2dart command that are written to the db2diag.log during
    error detection are incorrect.
    Problem summary: The db2dart commands have the wrong information
    in the /tsi and /oi fields; the values have been inadvertantly
    swapped.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5 fix pack
    3
    

Temporary fix

  • Swap the values of /tsi and /oi before running
    the db2dart commands (per the APAR problem text above).
    

Comments

APAR Information

  • APAR number

    IZ25342

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-06-23

  • Closed date

    2009-03-09

  • Last modified date

    2009-03-09

  • APAR is sysrouted FROM one or more of the following:

    IZ25337

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • ENGN_SQX
    

Fix information

  • Fixed component name

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R950 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

950

Reference #:

IZ25342

Modified date:

2009-03-09

Translate my page

Machine Translation

Content navigation