IC91087: SQL217N MAY BE RECORDED IN DB2DIAG.LOG ON HADR STANDBY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL2171N may be recorded incorrectly in db2diag.log on HADR
    standby.
    
    Some kind of operations on HADR Primary may record  SQL2171N in
    the db2diag.log on HADR Standby incorrectly.
    
    An example of operations causing SQL2171N is dropping a table
    after LOAD utility and its db2diag.log is as;
    
    
    2013-03-06-17.37.27.620453+540 I262756A466        LEVEL: Warning
    PID     : 25297400             TID  : 8973        PROC : db2sysc
    0
    INSTANCE: e97q7d               NODE : 000         DB   : T37525E
    APPHDL  : 0-306                APPID: *LOCAL.DB2.130306083527
    EDUID   : 8973                 EDUNAME: db2agent (T37525E) 0
    FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:553
    DATA #1 : String, 59 bytes
    Starting to restore a load copy.
    COMMON  .T4.20130306173656
    
    2013-03-06-17.37.37.672306+540 I263223A432        LEVEL: Warning
    PID     : 25297400             TID  : 8973        PROC : db2sysc
    0
    INSTANCE: e97q7d               NODE : 000         DB   : T37525E
    APPHDL  : 0-306                APPID: *LOCAL.DB2.130306083527
    EDUID   : 8973                 EDUNAME: db2agent (T37525E) 0
    FUNCTION: DB2 UDB, database utilities, sqludcpy, probe:1136
    MESSAGE : Load copy restore completed successfully.
    
    2013-03-06-17.38.55.764963+540 I263656A528        LEVEL: Warning
    PID     : 25297400             TID  : 8320        PROC : db2sysc
    0
    INSTANCE: e97q7d               NODE : 000         DB   : T37525E
    APPHDL  : 0-306                APPID: *LOCAL.DB2.130306083527
    EDUID   : 8320                 EDUNAME: db2redom (T37525E) 0
    FUNCTION: DB2 UDB, database utilities, sqluhUpdateSingle,
    probe:657
    MESSAGE : SQL2171N  The update of the recovery history file
    failed because the
              specified object part does not exist in the file.
    
    2013-03-06-17.38.55.765231+540 E264185A570        LEVEL: Warning
    PID     : 25297400             TID  : 8320        PROC : db2sysc
    0
    INSTANCE: e97q7d               NODE : 000         DB   : T37525E
    APPHDL  : 0-306                APPID: *LOCAL.DB2.130306083527
    EDUID   : 8320                 EDUNAME: db2redom (T37525E) 0
    FUNCTION: DB2 UDB, recovery manager,
    sqlpProcessDroppedTablePendingRec, probe:3
    DATA #1 : <preformatted>
    Dropped table history record missing.  Tables dropped at or
    after History File Index
    4 are no longer recoverable through dropped table recovery.
    

Local fix

  • SQL217N can be ignored safely on HADR Standby.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Server in HADR configuration.                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 9.7 Fix Pack 9.                                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 9.
    

Temporary fix

  • Not available.
    

Comments

APAR Information

  • APAR number

    IC91087

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-25

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC91087

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation