IBM Support

IJ00150: ERROR UPDATING LOCK SIZE (CF_LOCK_SZ) INCORRECTLY SETS THE RESIZE STATE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Error updating Lock size (Cf_lock_sz)  incorrectly sets the
    resize state.
    
    2017-08-30-13.22.33.590436+720 I121747778E708        LEVEL:
    Error
    PID     : 27263                TID : 140171026622208 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-20245              APPID: *N0.DB2.170830063615
    AUTHID  : DB2INSTT             HOSTNAME: localhost
    EDUID   : 1101                 EDUNAME: db2cfmt Active (RAWT) 0
    FUNCTION: DB2 UDB, Self tuning memory manager,
    stmmCFMTUpdateDBConfig, probe:1870
    MESSAGE : ZRC=0x82AE00A7=-2102525785=STMM_CONFIG_UPDATE_FAILED
              "An attempted configuration update failed"
    DATA #1 : String, 89 bytes
    Error updating Lock size (Cf_lock_sz), Attempted update value is
    218880, sqlcode is -204
    
    This can cause to spam the diag.log with
     this errors every one second apart :
    
    2017-08-30-15.35.31.865105+720 E148645416E969        LEVEL:
    Severe
    PID     : 4580                 TID : 139998921746176 PROC :
    db2sysc 1
    INSTANCE: db2inst1             NODE : 001            DB   :
    Sample
    APPHDL  : 1-36571              APPID: *N1.DB2.170830111151
    AUTHID  : DB2INST1             HOSTNAME: Localhost
    EDUID   : 4881                 EDUNAME: db2periodicc (ODSD) 1
    FUNCTION: DB2 UDB, Shared Data Structure Abstraction Layer for
    CF, SAL_CA_STRUCT_HANDLE::sqlfResizeStructureInCA, probe:6818
    MESSAGE :
    ZRC=0x822701CA=-2111372854=SQLE_SAL_ALLOCATE_INVALID_TARGET_STRU
    CTURE_SIZE
              "Invalid target structure size."
    CALLED  : DB2 UDB, Shared Data Structure Abstraction Layer for
    CF, SAL_CA_STRUCT_HANDLE::SAL_CADoStructureResizeCommand
    RETCODE :
    ZRC=0x822701CA=-2111372854=SQLE_SAL_ALLOCATE_INVALID_TARGET_STRU
    CTURE_SIZE
              "Invalid target structure size."
    DATA #1 : unsigned integer, 4 bytes
    0
    DATA #2 : unsigned integer, 4 bytes
    0
    
    2017-08-30-15.15.03.0095182789+720 E123456789A370   LEVEL    :
    Error
    PID      : 10340  TID    :  402646784
    HOSTNAME : Localhost
    FUNCTION : CA trace, log_error
    MESSAGE  : CA server has encountered an error.
    DATA #1  :
    diff = 18944, structure size = 237824, tss = 218880, lost_frames
    = 74 lost_units = 566322,
     u per frame = 7653, alloc count = 562670
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ00150

  • Reported component name

    DB2 PURESCALE F

  • Reported component ID

    5724Y6900

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-20

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-19

  • 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 PURESCALE F

  • Fixed component ID

    5724Y6900

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 August 2020