|
Problem IC85478
|
Status: Geschlossen |
DPF LOAD WITH SOURCEUSEREXIT OPTION MIGHT HANG, WHEN SPECIFIED SOURCEUSEREXIT EXITS EARLY WITHOUT TRYING TO OPEN NAMED PIPES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
**************************************************************** |
| Local-Fix: |
N/A |
| verfügbare FixPacks: |
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
|
| Lösung |
First fixed in DB2 Version 9.7 Fix Pack 7. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.07.2012
23.10.2012
23.10.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP7
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.7
|
 |
