|
Problem IC85478
|
Status: Closed |
DPF LOAD WITH SOURCEUSEREXIT OPTION MIGHT HANG, WHEN SPECIFIED SOURCEUSEREXIT EXITS EARLY WITHOUT TRYING TO OPEN NAMED PIPES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DPF Load with sourceuserexit option might hang when specified
sourceuserexit exits early without trying to open named pipes.
When querying for db2 applications, it still shows that load is
running. The error in db2diag.log is as below:
2012-06-12-09.12.54.659363-240 I26873A1043 LEVEL: Error
PID : 22216706 TID : 9255 PROC : db2sysc
400
INSTANCE: p***** NODE : 400 DB : N*****1
APPHDL : 400-74 APPID: *N400.p*****.120612131244
AUTHID : P****
EDUID : 9255 EDUNAME: db2lurex 400
FUNCTION: DB2 UDB, database utilities,
sqlusCUserExitSubAgent::iRun, probe:1385
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 50 bytes
LOADID: 8484.2012-06-12-09.12.45.102512.400 (87;3)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3255 sqlerrml:
22
sqlerrmc: cf_get_files_text.sh 2
sqlerrp : SQLUUREX
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000190
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Note that the problem only applies to DB2 Version 9.7 Fix Pack 3
to Fix Pack 6. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
N/A |
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.07.2012
23.10.2012
23.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
