Fixes are available
APAR status
Closed as program error.
Error description
In pureScale when database configuration parameter LOCKTIMEOUT is not the default value -1, an extent movement started by an ALTER TABLESPACE LOWER HIGH WATER MARK or an ALTER TABLESPACE REDUCE MAX could return a lock time out error which in return will bring the system down. Key entries in db2diag.log : 2019-11-28-06.33.02.188901-300 I1072258134A1106 LEVEL: Severe PID : 7209176 TID : 66395 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE EDUID : 66395 EDUNAME: db2ExtMovHelper (SAMPLE) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbEMHelperEDU::sqlbExtentMovementHelperEntryPoint, probe:12217 MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT "LockTimeOut - tran rollback Reason code 68" DATA #1 : String, 14 bytes Error Occurred 2019-11-28-06.33.02.189754-300 I1072259241A966 LEVEL: Info PID : 7209176 TID : 66395 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE HOSTNAME: host1 EDUID : 66395 EDUNAME: db2ExtMovHelper (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::ForceDBShutdown, probe:16937 DATA #1 : Pointer, 8 bytes 0x0000000000000000 DATA #2 : Boolean, 1 bytes false CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000001ECF8044 ForceDBShutdown__16sqeLocalDatabaseFi + 0x364 [1] 0x09000000212B315C sqlbExtentMovementHelperEntryPoint__15sqlbEMHelperEDUFv + 0x49C [2] 0x09000000212B2AB8 RunEDU__15sqlbEMHelperEDUFv + 0x38 [3] 0x090000001E1A4C40 EDUDriver__9sqzEDUObjFv + 0x300 [4] 0x090000001E086280 sqloEDUEntry + 0x360 [5] 0x0900000000570E10 _pthread_body + 0xF0 [6] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
Local fix
Set database configuration parameter LOCKTIMEOUT to -1 after db2 restart db.
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V11.1.4.6 * ****************************************************************
Problem conclusion
Upgrade to V11.1.4.6
Temporary fix
Comments
APAR Information
APAR number
IT31308
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-12-17
Closed date
2021-03-19
Last modified date
2021-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 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":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022