IBM Support

IC91219: CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Concurrent CREATE TABLE statements, containing GENERATED ALWAYS
    AS IDENTITY column:
    
    CREATE TABLE T1 (
        C1 INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH
    1,INCREMENT BY 1,CACHE 500),
        C2 INTEGER,
        ...
    )
    
    might end up with an infinite loop, causing an EDU to perform
    endlessly during processing of the insert statement into
    SYSIBM.SYSSEQUENCES table.
    
    Similar symptoms might be seen during execution of concurrent
    ALTER TABLE statements.
    Further, concurrent execution of CREATE SEQUENCE statements,
    might end up with the same problem.
    
    Once the issue occurs, you will notice in the traces:
    
    258            0.000356343   sqlrlCatalogScan::insert entry
    [eduid 55437 eduname db2agent]
    271            0.000382562   | sqlrinsr entry [eduid 55437
    eduname db2agent]
    272            0.000383853   | | sqldRowInsert entry [eduid
    55437 eduname db2agent]
    280            0.000391375   | | | sqldFullFormatFixedVar entry
    [eduid 55437 eduname db2agent]
    281            0.000394125   | | | | sqldFormatLobLongCol entry
    [eduid 55437 eduname db2agent]
    283            0.000395888   | | | | | sqldmadx entry [eduid
    55437 eduname db2agent]
    284            0.000397056   | | | | | | sqldxLobCreate entry
    [eduid 55437 eduname db2agent]
    288            0.000399843   | | | | | | | sqldxCreateLob entry
    [eduid 55437 eduname db2agent]
    291            0.000403281   | | | | | | | | sqldx_ld_extend
    entry [eduid 55437 eduname db2agent]
    292            0.000404570   | | | | | | | | |
    sqldx_ld_alloc_bsegs entry [eduid 55437 eduname db2agent]
    294            0.000407693   | | | | | | | | | | sqldxGetBseg
    entry [eduid 55437 eduname db2agent]
    303            0.000416812   | | | | | | | | | | |
    sqldxOuterRbsHunt entry [eduid 55437 eduname db2agent]
    312            0.000426392   | | | | | | | | | | | |
    sqldxRbsHunt entry [eduid 55437 eduname db2agent]
    313            0.000427312   | | | | | | | | | | | | |
    sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent]
    314            0.000428062   | | | | | | | | | | | | | |
    sqlpInitBFI entry [eduid 55437 eduname db2agent]
    315            0.000428507   | | | | | | | | | | | | | |
    sqlpInitBFI exit
    316            0.000429312   | | | | | | | | | | | | | |
    sqldxFreePendDel entry [eduid 55437 eduname db2agent]
    317            0.000429853   | | | | | | | | | | | | | |
    sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    318            0.000431101   | | | | | | | | | | | | |
    sqldxRBSFreePendDel exit
    319            0.000431423   | | | | | | | | | | | |
    sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    320            0.000432343   | | | | | | | | | | | |
    sqldxRbsHunt entry [eduid 55437 eduname db2agent]
    321            0.000432625   | | | | | | | | | | | |
    sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    322            0.000433304   | | | | | | | | | | | |
    sqldxRbsHunt entry [eduid 55437 eduname db2agent]
    ...
    504            0.000529125   | | | | | | | | | | | |
    sqldxRbsHunt entry [eduid 55437 eduname db2agent]
    505            0.000529347   | | | | | | | | | | | |
    sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    
    
    From this point, you will notice following sqldxRbsHunt blocks:
    
    506            0.000529955   | | | | | | | | | | | |
    sqldxRbsHunt entry [eduid 55437 eduname db2agent]
    507            0.000530222   | | | | | | | | | | | | |
    sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent]
    508            0.000530775   | | | | | | | | | | | | | |
    sqlpInitBFI entry [eduid 55437 eduname db2agent]
    509            0.000530968   | | | | | | | | | | | | | |
    sqlpInitBFI exit
    510            0.000531531   | | | | | | | | | | | | | |
    sqldxFreePendDel entry [eduid 55437 eduname db2agent]
    511            0.000531748   | | | | | | | | | | | | | |
    sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    512            0.000532308   | | | | | | | | | | | | |
    sqldxRBSFreePendDel exit
    513            0.000532533   | | | | | | | | | | | |
    sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 =
    SQLDXE_NFOUND]
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 fixpack 9                         *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.7 fixpack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91219

  • 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-04-02

  • Closed date

    2013-10-02

  • Last modified date

    2013-10-02

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

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

    IC91824 IC93384

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC91219

Modified date: 02 October 2013