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 |
