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

Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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 (SAMPLE)
  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 (SAMPLE) 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 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