Fixes are available
APAR status
Closed as program error.
Error description
A cursor load to a remote server fails with Tablespace full and gets terminated. After the load is cancelled db2 list applications still shows a db2lueff connection in the source server which does not go away until the target or remote server is restarted. In the target server the load gets defined as: db2 connect to target db2 "declare c1 cursor database source user xxx for select * from source_table" db2 "load from c1 of cursor messages c1.msg insert into target_table" The db2diag.log in the target server will show sqluKillUserExit after the tablespace full errors: 2008-12-11-12.20.50.177412+060 I13702A369 LEVEL: Error PID : 4038736 TID : 1 PROC : db2lueff INSTANCE: db2dbm96 NODE : 000 APPID : *LOCAL.db2dbm96.081211112048 FUNCTION: DB2 UDB, database utilities, sqluffGenerateFetchQueries, probe:3489 MESSAGE : Query DATA #1 : String, 37 bytes select * from xxx.source_table with ur 2008-12-11-12.20.51.707099+060 I14072A450 LEVEL: Warning PID : 4677820 TID : 1 PROC : db2lurex 0 INSTANCE: db2dbm96 NODE : 000 DB : T11YDZVD APPHDL : 0-816 APPID: *LOCAL.db2dbm96.081211112042 AUTHID : DB2DBM96 FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 DATA #1 : String, 79 bytes LOADID: 5230774.2008-12-11-12.20.46.091555.0 (2;19) UserExitSA is running. 0, 0 .... 2008-12-11-12.21.35.438525+060 E15033A1049 LEVEL: Error PID : 2732116 TID : 1 PROC : db2lfrm0 0 INSTANCE: db2dbm96 NODE : 000 DB : T11YDZVD APPHDL : 0-816 APPID: *LOCAL.db2dbm96.081211112042 AUTHID : DB2DBM96 FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent, probe:830 MESSAGE : ADM6044E The DMS table space "USER04K1" (ID "2") is full. .... 2008-12-11-12.21.36.597979+060 I20001A1575 LEVEL: Error PID : 5230774 TID : 1 PROC : db2agent (T11YDZVD) 0 INSTANCE: db2dbm96 NODE : 000 DB : T11YDZVD APPHDL : 0-816 APPID: *LOCAL.db2dbm96.081211112042 AUTHID : DB2DBM96 FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10 MESSAGE : Sending SIGKILL to the following process id DATA #1 : signed integer, 4 bytes 2179162 CALLSTCK: [0] 0x0900000003BB2030 sqlossig + 0x3C [1] 0x0900000004F5CFB8 sqluKillUserExit__FP23SQLU_USEREXIT_SHARED_CB + 0xAC [2] 0x0900000004F7A440 sqlulTerminate__FP8sqlucacbPsQ2_22SqluTerminationMessage21LoadTe rminationReasonPi + 0x4C4 [3] 0x0900000004F74CBC sqlulPrcErr__FP8sqlucacbP11SqluEduInfoP12SQLO_MSG_HDRQ2_11SqluMe ssage4TypeiPi + 0x25C [4] 0x0900000004F76FA8 @72@sqlulFRMResponse__FP8sqlucacbPP11SqluEduInfoP12SQLO_MSG_HDRP Q2_11SqluMessage4TypeP20sqlu_loadapi_load_cbPi + 0x230 [5] 0x0900000004F6DE28 @72@sqlulPollMsg__FP20sqle_agent_privatecbP8sqlucacbPi + 0x18F8 [6] 0x0900000004F660F4 sqluvload__FPUcT1P8SQLP_LSNP7sqlubmhPP15sqlu_media_listT5UcP26sq luCLoadRequestDescriptorP8sqluvlcbPi + 0x1F14 [7] 0x0900000004F38988 @72@call_sqluvload__FP20sqle_agent_privatecbP12SQLB_GLOBALSP26sq luCLoadRequestDescriptorP20sqlu_loadapi_load_cbiT5PiT7 + 0xA78 [8] 0x09000000050D7B30 sqluLoadPartition__FP20sqle_agent_privatecbP26sqluCLoadRequestDe scriptoriN23PiT6 + 0x788 [9] 0x0900000004E1597C sqlu_register_table_load__FP26sqluCLoadRequestDescriptorP24sqlus CLoadMPPCoordinatorP15sql_static_data + 0xE6C ... 2008-12-11-12.21.37.115865+060 I24300A495 LEVEL: Error PID : 4677820 TID : 1 PROC : db2lurex 0 INSTANCE: db2dbm96 NODE : 000 DB : T11YDZVD APPHDL : 0-816 APPID: *LOCAL.db2dbm96.081211112042 AUTHID : DB2DBM96 FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 DATA #1 : String, 124 bytes LOADID: 5230774.2008-12-11-12.20.46.091555.0 (2;19) UserExit Failure , 258, 9, Detected in file:sqlusUserExitSA.C, Line:1236 2008-12-11-12.21.37.116397+060 I24796A690 LEVEL: Error PID : 4677820 TID : 1 PROC : db2lurex 0 INSTANCE: db2dbm96 NODE : 000 DB : T11YDZVD APPHDL : 0-816 APPID: *LOCAL.db2dbm96.081211112042 AUTHID : DB2DBM96 FUNCTION: DB2 UDB, database utilities, sqlusCUserExitSubAgent::iRun, probe:1242 MESSAGE : ZRC=0x80150003=-2146107389=SQLU_INTRP "User interrupt detected in Load" DIA8003C The interrupt has been received. DATA #1 : LOADID, PD_TYPE_LOADID, 43 bytes 5230774.2008-12-11-12.20.46.091555.0 (2;19) DATA #2 : File name, 17 bytes sqlusUserExitSA.C DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes 0x870F0009 Even after terminating the load on the target server, db2 list applications will show a db2lueff on the source. Application snaphot will also show a db2lueff connetion: Application Snapshot Application handle = 785 Application status = UOW Waiting Status change time = 11/13/2008 13:42:46.548585 Application code page = 1252 Application country/region code = 1 DUOW correlation token = GABA6A3F.OBFB.081113120452 Application name = db2lueff Application ID = GABA6A3F.OBFB.081113120452 ... Connection request start timestamp = 11/13/2008 13:04:36.231809 Connect request completion timestamp = 11/13/2008 13:04:36.232117 Application idle time = 22 hours 7 minutes 12 seconds
Local fix
Restart source and/ or target server to release db2lueff connection on target.
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * AFTER LOAD FAILURE/ LOAD CANCEL DB2LUEFF STILL SHOWS IN DB2 * * LIST APPLICATIONS * * * * A cursor load to a remote server fails with Tablespace full * * and * * gets terminated. After the load is cancelled db2 list * * * * applications still shows a db2lueff connection in the source * * * * server which does not go away until the target or remote * * server * * is restarted. * * * * * * * * In the target server the load gets defined as: * * * * * * * * db2 connect to target * * * * db2 "declare c1 cursor database source user xxx for select * * * * * from source_table" * * * * db2 "load from c1 of cursor messages c1.msg insert into * * * * target_table" * * * * * * * * The db2diag.log in the target server will show * * sqluKillUserExit * * after the tablespace full errors: * * * * * * * * 2008-12-11-12.20.50.177412+060 I13702A369 LEVEL: * * Error * * PID : 4038736 TID : 1 PROC : * * * * db2lueff * * * * INSTANCE: db2dbm96 NODE : 000 * * * * APPID : *LOCAL.db2dbm96.081211112048 * * * * FUNCTION: DB2 UDB, database utilities, * * * * sqluffGenerateFetchQueries, probe:3489 * * * * MESSAGE : Query * * * * DATA #1 : String, 37 bytes * * * * select * from xxx.source_table with ur * * * * * * * * 2008-12-11-12.20.51.707099+060 I14072A450 LEVEL: * * Warning * * PID : 4677820 TID : 1 PROC : * * * * db2lurex 0 * * * * INSTANCE: db2dbm96 NODE : 000 DB : * * * * T11YDZVD * * * * APPHDL : 0-816 APPID: * * * * *LOCAL.db2dbm96.081211112042 * * * * AUTHID : DB2DBM96 * * * * FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 * * * * DATA #1 : String, 79 bytes * * * * LOADID: 5230774.2008-12-11-12.20.46.091555.0 (2;19) * * * * UserExitSA is running. 0, 0 * * * * .... * * * * 2008-12-11-12.21.35.438525+060 E15033A1049 LEVEL: * * Error * * PID : 2732116 TID : 1 PROC : * * * * db2lfrm0 0 * * * * INSTANCE: db2dbm96 NODE : 000 DB : * * * * T11YDZVD * * * * APPHDL : 0-816 APPID: * * * * *LOCAL.db2dbm96.081211112042 * * * * AUTHID : DB2DBM96 * * * * FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateExtent, * * * * probe:830 * * * * MESSAGE : ADM6044E The DMS table space "USER04K1" (ID "2") * * is * * full. * * * * .... * * * * * * * * 2008-12-11-12.21.36.597979+060 I20001A1575 LEVEL: * * Error * * PID : 5230774 TID : 1 PROC : * * * * db2agent (T11YDZVD) 0 * * * * INSTANCE: db2dbm96 NODE : 000 DB : * * * * T11YDZVD * * * * APPHDL : 0-816 APPID: * * * * *LOCAL.db2dbm96.081211112042 * * * * AUTHID : DB2DBM96 * * * * FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10 * * * * MESSAGE : Sending SIGKILL to the following process id * * * * DATA #1 : signed integer, 4 bytes * * * * 2179162 * * * * CALLSTCK: * * * * [0] 0x0900000003BB2030 sqlossig + 0x3C * * * * [1] 0x0900000004F5CFB8 * * * * sqluKillUserExit__FP23SQLU_USEREXIT_SHARED_CB + 0xAC * * * * [2] 0x0900000004F7A440 * * * * sqlulTerminate__FP8sqlucacbPsQ2_22SqluTerminationMessage21Load * * * rminationReasonPi + 0x4C4 * * * * [3] 0x0900000004F74CBC * * * * sqlulPrcErr__FP8sqlucacbP11SqluEduInfoP12SQLO_MSG_HDRQ2_11Sqlu * * * ssage4TypeiPi + 0x25C * * * * [4] 0x0900000004F76FA8 * * * * @72@sqlulFRMResponse__FP8sqlucacbPP11SqluEduInfoP12SQLO_MSG_HD * * * Q2_11SqluMessage4TypeP20sqlu_loadapi_load_cbPi + 0x230 * * * * [5] 0x0900000004F6DE28 * * * * @72@sqlulPollMsg__FP20sqle_agent_privatecbP8sqlucacbPi + * * 0x18F8 * * [6] 0x0900000004F660F4 * * * * sqluvload__FPUcT1P8SQLP_LSNP7sqlubmhPP15sqlu_media_listT5UcP26 * * * luCLoadRequestDescriptorP8sqluvlcbPi + 0x1F14 * * * * [7] 0x0900000004F38988 * * * * @72@call_sqluvload__FP20sqle_agent_privatecbP12SQLB_GLOBALSP26 * * * luCLoadRequestDescriptorP20sqlu_loadapi_load_cbiT5PiT7 + * * 0xA78 * * [8] 0x09000000050D7B30 * * * * sqluLoadPartition__FP20sqle_agent_privatecbP26sqluCLoadRequest * * * scriptoriN23PiT6 + 0x788 * * * * [9] 0x0900000004E1597C * * * * sqlu_register_table_load__FP26sqluCLoadRequestDescriptorP24sql * * * CLoadMPPCoordinatorP15sql_static_data + 0xE6C * * * * ... * * * * 2008-12-11-12.21.37.115865+060 I24300A495 LEVEL: * * Error * * PID : 4677820 TID : 1 PROC : * * * * db2lurex 0 * * * * INSTANCE: db2dbm96 NODE : 000 DB : * * * * T11YDZVD * * * * APPHDL : 0-816 APPID: * * * * *LOCAL.db2dbm96.081211112042 * * * * AUTHID : DB2DBM96 * * * * FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 * * * * DATA #1 : String, 124 bytes * * * * LOADID: 5230774.2008-12-11-12.20.46.091555.0 (2;19) * * * * UserExit Failure , 258, 9, Detected in * * file:sqlusUserExitSA.C, * * Line:1236 * * * * * * * * 2008-12-11-12.21.37.116397+060 I24796A690 LEVEL: * * Error * * PID : 4677820 TID : 1 PROC : * * * * db2lurex 0 * * * * INSTANCE: db2dbm96 NODE : 000 DB : * * * * T11YDZVD * * * * APPHDL : 0-816 APPID: * * * * *LOCAL.db2dbm96.081211112042 * * * * AUTHID : DB2DBM96 * * * * FUNCTION: DB2 UDB, database utilities, * * * * sqlusCUserExitSubAgent::iRun, probe:1242 * * * * MESSAGE : ZRC=0x80150003=-2146107389=SQLU_INTRP * * * * "User interrupt detected in Load" * * * * DIA8003C The interrupt has been received. * * * * DATA #1 : LOADID, PD_TYPE_LOADID, 43 bytes * * * * 5230774.2008-12-11-12.20.46.091555.0 (2;19) * * * * DATA #2 : File name, 17 bytes * * * * sqlusUserExitSA.C * * * * DATA #3 : ZRC, PD_TYPE_ZRC, 4 bytes * * * * 0x870F0009 * * * * * * * * * * * * Even after terminating the load on the target server, db2 * * list * * applications will show a db2lueff on the source. Application * * * * snaphot will also show a db2lueff connetion: * * * * * * * * Application Snapshot * * * * * * * * Application handle = 785 * * * * Application status = UOW Waiting * * * * Status change time = 11/13/2008 * * * * 13:42:46.548585 * * * * Application code page = 1252 * * * * Application country/region code = 1 * * * * DUOW correlation token = * * * * GABA6A3F.OBFB.081113120452 * * * * Application name = db2lueff * * * * Application ID = * * * * GABA6A3F.OBFB.081113120452 * * * * ... * * * * Connection request start timestamp = 11/13/2008 * * * * 13:04:36.231809 * * * * Connect request completion timestamp = 11/13/2008 * * * * 13:04:36.232117 * * * * Application idle time = 22 hours 7 * * minutes * * 12 seconds * **************************************************************** * RECOMMENDATION: * * Upgrade to v9.1FP8 * ****************************************************************
Problem conclusion
Problem was first fixed in Version 9.1FP8
Temporary fix
Comments
APAR Information
APAR number
IZ42812
Reported component name
DB2 UDB ESE AIX
Reported component ID
5765F4100
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-30
Closed date
2009-10-29
Last modified date
2009-10-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 UDB ESE HP-
Fixed component ID
5765F4103
Applicable component levels
R910 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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":"910"}]
Document Information
Modified date:
03 October 2021