Fixes are available
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 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
2022-03-29
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":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
04 May 2022