Fixes are available
APAR status
Closed as program error.
Error description
During database activation in PureScale environment, db2instance -list might temporarily report the ERROR for secondary CF: ID TYPE STATE -- ---- ----- 0 MEMBER STARTED 1 MEMBER STARTED 128 CF PRIMARY 129 CF ERROR This is not an indication of a problem with the CF, just a transient condition related to CF memory structures changing whilst being accessed by db2instane -list command. State for CF eventually should stabilize as PEER or CATCHUP. db2diag.log will show error similar to this one: 2015-08-24-16.29.19.238933+120 E162513E3044 LEVEL: Severe PID : 6463 TID : 140651792959264 PROC : db2instance INSTANCE: db2v1055 NODE : 000 HOSTNAME: db2lx2 FUNCTION: DB2 UDB, Shared Data Structure Abstraction Layer for CF, SAL_MANAGEMENT_PORT_HANDLE::SAL_ManagementStructUdfOpInternal, probe:8353 MESSAGE : ZRC=0x820001B6=-2113928778=SQLZ_RC_CA_STRUCT_UDF_OPERATION_FAILE D "An operation against a CF structure user data field failed." DATA #1 : String, 24 bytes db2.db2v1055.TESTDB1.gcl DATA #2 : unsigned integer, 1 bytes 1 DATA #3 : SAL Structure Type, PD_TYPE_SAL_STRUCT_TYPE, 1 bytes Structure type 76326202 : sca : unknown struct type bit 9 : unk DATA #4 : CF RC, PD_TYPE_SD_CF_RC, 4 bytes 2147876929 DATA #5 : CF Response Structure, PD_TYPE_SD_CFRESPONSE, 424 bytes API Response Code = 2147876929 Model Code = 6 Response Code = 65 Exception Code = 0 SID = 0 API ID = 183 Line Number = 0 Description = API Function: 183 (PsReadWriteStructStatus), Structure ID (SID): 0 (db2.db2v1055.TESTDB1.gcl), Model Code: 6 (Management), Command Code: 32 (0x20) (***Undefined***) Return Code: Severity = 0x8 (Error), Component = 6 (svr_mgmnt [Management]), Error = 65 (0x41) Error Name = CA_MGMNT_STRUCT_NAME_NOT_FOUND API Return Code: 0x80060041, CA Response Code: 65 (***Undefined***) Status Conditions: 13: ***Undefined*** 14: ***Undefined*** 16: Maximum time delay exceeded DATA #6 : management port state for connection to a single physical CF, PD_TYPE_SAL_MANAGEMENT_PORT_HANDLE, 88 bytes m_mgmntPortToken = 0x633740 m_mgmntPortNumber = 56000 m_caNodeNum = 129 m_szHostname = db2lx1 m_ErrorFromOpenIfFailed = 0x0 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FEC041CC491 _ZN26SAL_MANAGEMENT_PORT_HANDLE33SAL_ManagementStructUdfOpIntern alEhPKchP20SAL_STRUCTURE_STATUSm + 0x4A1 [1] 0x00007FEC041CBF5B _ZN26SAL_MANAGEMENT_PORT_HANDLE31SAL_ManagementIsStructInRestore EPKc20SAL_STRUCTURE_STATUSmPb + 0x59B [2] 0x00007FEC041CAF5C _ZN26SAL_MANAGEMENT_PORT_HANDLE29SAL_ManagementIsFullyDuplexedEP bPKcm + 0x89C [3] 0x00007FEC05A6548D rocmIsCAInPeerState + 0x8D [4] 0x00007FEC05A66304 _Z24sqlhaGetSecondaryCFStateiPjPb + 0x84 [5] 0x00007FEC05A66EBB _Z25sqlhaMapCFStateOnPhysicalP11sqlhaCFData15_sqlhaObjStatesS1_m + 0x3EB [6] 0x00007FEC05A6A5D2 _Z37sqlhaDB2InstanceGetCFStatesOnPhysicalP11sqlhaCFData + 0x2C2 [7] 0x00007FEC05A6ABC5 _Z28sqlhaDB2InstanceGetCFsStatesP11sqlhaCFData + 0x75 [8] 0x00007FEC05A6AD8D _Z25sqlhaDB2InstanceGetCFDataP11sqlhaCFDataP20sqlerDB2InstanceDa tam + 0x8D [9] 0x00007FEC05A724B9 _Z18sqlhaDB2InstanceSDP22db2InstanceInputParamsbbPcPP20sqlerDB2I nstanceDataPjP19SQLHA_CONTROL_BLOCK + 0x4E9 [10] 0x00007FEC05A7492C _Z23sqlhaSysProcDB2InstancePiPcS0_S0_S_S0_PP20sqlerDB2InstanceDa taPjP5sqlcaP19SQLHA_CONTROL_BLOCK + 0x31C [11] 0x0000000000403818 main + 0x9A8 [12] 0x00007FEBFF43DC36 __libc_start_main + 0xE6 [13] 0x0000000000402DD9 __gxx_personality_v0 + 0x1A1
Local fix
Issue: $ db2instance -list again to verify state of CF
Problem summary
**************************************************************** * USERS AFFECTED: * * PureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See "Local Fix" * ****************************************************************
Problem conclusion
Upgrade
Temporary fix
Comments
APAR Information
APAR number
IV76501
Reported component name
DB2 PURESCALE F
Reported component ID
5724Y6900
Reported release
A50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-08-28
Closed date
2022-06-30
Last modified date
2022-06-30
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
[{"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:
15 August 2022