DB2 - Problem description
Problem IT17997 | Status: Closed |
CONCURRENT INGEST MIGHT FAIL INTERMITTENTLY WITH SQL0901N "INVALID PARAMETER" | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
When running multiple INGEST commands concurrently, some might fail intermittently with SQL0901N The SQL statement or command failed because of a database system error. (Reason "Invalid parameter".) SQLSTATE=58004 and db2diag.log entries point to issue in SqludiJobRegister::sqludiCreateOrAttachSemaphore() function. (Note that another APAR IT14698 ( https://www.ibm.com/support/entdocview.wss?uid=swg1IT14698 ) has similar external symptom, but with db2diag.log entries pointing to different functions, SqludiJobRegister::sqludiLock() and SqludiJobRegister::sqludiCreateOrAttachMemory(). This APAR fixes the issue with SqludiJobRegister::sqludiCreateOrAttachSemaphore() function, and APAR IT14698 fixes the issue with SqludiJobRegister::sqludiLock() and SqludiJobRegister::sqludiCreateOrAttachMemory().) From db2diag.log: ----- 2016-11-08-15.24.09.415603+540 I59389A2095 LEVEL: Error PID : 14811222 TID : 258 PROC : db2bp INSTANCE: db2inst1 NODE : 000 DB : XXXXXX APPID : XX.X.XXX.XXX.XXXXX.XXXXXXXXXXXX HOSTNAME: XXXXXX EDUID : 258 FUNCTION: DB2 UDB, Ingest utility, SqludiErrorInfo::sqludiLogNonCliError, probe:20 DATA #1 : String, 161 bytes Ingest utility error information: (2) Error handling message (3) Source file name (4) Line number (5) SQLCA (6) DB2 ZRC error code (7) OSS (ECF) error code name DATA #2 : String, 55 bytes The utility reported the following message to the user. DATA #3 : File name, 21 bytes sqludi_job_register.C DATA #4 : Source file line number, 8 bytes 199 DATA #5 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 17 sqlerrmc: Invalid parameter sqlerrp : SQL10057 sqlerrd : (1) 0x9000000C (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 58004 DATA #6 : ZRC, PD_TYPE_ZRC, 4 bytes 0x00000000 DATA #7 : String, 21 bytes ECF_INVALID_PARAMETER CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x09000000051B4860 sqludiLogNonCliError__15SqludiErrorInfoCFCPCcCb + 0x1FC [1] 0x0900000005D5CC34 sqludiLog__15SqludiErrorInfoCFClCPCcCb + 0x438 [2] 0x09000000050BC4DC sqludiWriteMsg__15SqludiErrorDestFCPC15SqludiErrorInfoT1ClCUl + 0x364 [3] 0x0900000005CD9500 sqludiWriteMsg__15SqludiErrorInfoFClCPiCUl + 0x94 [4] 0x09000000051B30C8 sqludiCreateOrAttachSemaphore__17SqludiJobRegisterFCP15SqludiErr orDest + 0x574 [5] 0x09000000051B2890 sqludiCreateOrAttach__17SqludiJobRegisterFCPCcCP15SqludiErrorDes t + 0x1248 [6] 0x0900000005170980 sqludiJobController__FPv + 0xFC [7] 0x0900000004D5A63C sqludiJobController__FPv + 0xDA4 [8] 0x0900000000982E10 _pthread_body + 0xF0 [9] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 2016-11-08-15.24.09.435819+540 I61485A1678 LEVEL: Error PID : 14811222 TID : 258 PROC : db2bp INSTANCE: db2inst1 NODE : 000 DB : XXXXXX APPID : XX.X.XXX.XXX.XXXXX.XXXXXXXXXXXX HOSTNAME: XXXXXX EDUID : 258 FUNCTION: DB2 UDB, Ingest utility, SqludiJobRegister::sqludiCreateOrAttachSemaphore, probe:20 CALLED : DB2 Common, OSSe, OSSHIPCSemaphore::attach RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER Invalid parameter DATA #1 : String, 580 bytes A semaphore operation returned an error. Semaphore data: (2) Semaphore resource ID (3) Semaphore is attached? The following data is from semaphore.getInfo. It is not valid if the semaphore is not attached and it might not be valid if the return code is not ECF_OK: (4) Return code from getInfo (name) (5) Return code from getInfo (value) (6) Semaphore ID (7) Semaphore value (8) Max semaphore value (9) Number of processes waiting for increase (10) Number of processes waiting for zero (11) Number of semaphores in set (12) Last semaphore op time (13) Last semaphore change time DATA #2 : signed integer, 4 bytes 1950038994 DATA #3 : Boolean, 1 bytes true DATA #4 : String, 21 bytes ECF_INVALID_PARAMETER DATA #5 : Hex integer, 4 bytes 0x9000000C DATA #6 : Hex integer, 4 bytes 0x00200003 DATA #7 : unsigned integer, 8 bytes 18446744073709551615 DATA #8 : unsigned integer, 8 bytes 32767 DATA #9 : unsigned integer, 8 bytes 18446744073709551615 DATA #10: unsigned integer, 8 bytes 18446744073709551615 DATA #11: unsigned integer, 2 bytes 0 DATA #12: String, 25 bytes Thu Jan 1 09:00:00 1970 DATA #13: String, 25 bytes Thu Jan 1 09:00:00 1970 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 9. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem was first fixed in DB2 UDB Version 10.5 FixPack 9. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.11.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |