IBM Support

IT22728: ERROR PROBLEMS DOWNGRADING SYSTABLES LOCK WHILE LOAD IS SUCCESSFUL

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • While LOAD command is successful, we got Error Problems
    downgrading systables lock
    
    2017-09-28-10.50.23.213387+000 I2963546A626
    LEVEL:Warning
    PID     : 56754586             TID : 61426          PROC
    :db2sysc 998
    INSTANCE: db2inst1	       NODE : 998           DB   : DBCDW
    APPHDL  : 998-8762             APPID:
    *N998.db2inst1.170928105017
    AUTHID  : db2inst1             HOSTNAME: system01
    EDUID   : 61426                EDUNAME: db2agent (DBCDW) 998
    FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in,
    probe:924
    DATA #1 : LOADID, PD_TYPE_LOADID, 52 bytes
    LOADID: 61426.2017-09-28-10.50.23.213360.998 (-1;-1)
    DATA #2 : String, 56 bytes
    Starting LOAD operation (S) (1) (I) [DBAAUD  .SECMAINT].
    
    2017-09-28-10.50.23.230425+000 I2964173A534         LEVEL:
    Warning
    PID     : 61931930             TID : 27502          PROC :
    db2sysc 1
    INSTANCE: db2inst1              NODE : 001           DB   :
    DBCDW
    APPHDL  : 998-8762             APPID:
    *N998.db2inst1.170928105017
    AUTHID  : db2inst1              HOSTNAME: system01
    EDUID   : 27502                EDUNAME: db2lmctk 1
    FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
    DATA #1 : String, 82 bytes
    LOADID: 61426.2017-09-28-10.50.23.213360.998 (1832;7)
    MicroTaskSA is running. 2, 0
    
    2017-09-28-10.50.23.231532+000 I2964708A618         LEVEL: Error
    PID     : 56754586             TID : 61426          PROC :
    db2sysc 998
    INSTANCE: db2inst1              NODE : 998           DB   :
    DBCDW
    APPHDL  : 998-8762             APPID:
    *N998.db2inst1.170928105017
    AUTHID  : db2inst1              HOSTNAME: system01
    EDUID   : 61426                EDUNAME: db2agent (DBCDW) 998
    FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag,
    probe:0
    DATA #1 : String, 145 bytes
    LOADID: 61426.2017-09-28-10.50.23.213360.998 (1832;7)
    Problems downgrading systables lock. , 0, 0, Detected in
    file:sqluCCatalogInfo.C, Line:1742
    

Local fix

  • The error messages in db2diag.log are incorrect and can be
    ignored.  The LOAD is successful and there are no locking issues
    with the LOAD.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22728

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-10

  • Closed date

    2020-01-28

  • Last modified date

    2020-01-28

  • 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

[{"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":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 January 2020