IBM Support

IT22728: ERROR PROBLEMS DOWNGRADING SYSTABLES LOCK WHILE LOAD IS SUCCESSFUL

Subscribe

You can track all active APARs for this component.

 

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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022