IBM Support

IC81706: TIMING CONDITIONS LEAD TO SQL0901N ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION DETACH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • There are timing conditions which could lead to SQL0901N
    ENCOUNTERED BY APD CLEANUP PROCESSING DURING RANGE PARTITION
    DETACH. This symptom is similar to APAR IC71664. But it is
    caused by timing conditions not yet addressed by that APAR fix.
    
    Both db2pd and db2 list utilities show ASYNCHRONOUS PARTITION
    DETACH is performing "Finalize detach for partition ...". In the
    db2diag.log, the -901 reported for the asynchronous detach
    process may appear similar to the entry below.
    
    2012-02-13-09.17.05.210933-480 I4180806A876       LEVEL: Severe
    PID     : 4456546              TID  : 14281       PROC : db2sysc
    0
    INSTANCE: dwd01                NODE : 000         DB   : DWD01
    APPHDL  : 0-22322              APPID: *N0.DB2.120311163320
    AUTHID  : DWD01
    EDUID   : 14281                EDUNAME: db2taskp (DWD01) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
    probe:300
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 60
     sqlerrmc: A hard invalidation is already taking place for this
    object!
     sqlerrp : SQLRA0B5
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFFEC      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 6                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81706

  • 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

    2012-02-28

  • Closed date

    2013-06-13

  • Last modified date

    2013-06-13

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

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

    IC84549

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 June 2013