I was bored so did a clean install of UDB 8.1 PE. Checked that the
Development Centre compiled JAVA Stored Procedures OK.
DB2ROUTINE_DEBUG did not appear on a db2set command.
Issued db2set DB2ROUTINE_DEBUG=OFF
Tried Compiling Java Procedure and got the infamous -1131 error
Attached is the diag.log as requested
2003-11-11-17.42.51.270000 Instance:DB2 Node:000
PID:2792(db2.exe) TID:3236 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012EFB4 : 0x00000002 ....
PID:2792 TID:3236 Node:000 Title: Path/Filename
C:\IBM\SQLLIB/conv/12520850.cnv
2003-11-11-17.44.44.372000 Instance:DB2 Node:000
PID:4064(db2javit.exe) TID:4076 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0010D0B4 : 0x00000002 ....
PID:4064 TID:4076 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.44.48.648000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1224 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0006EC1C : 0x00000002 ....
PID:4080 TID:1224 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.45.39.401000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CBEC08 : 0x00000002 ....
PID:4080 TID:1368 Node:000 Title: Path/Filename
C:\IBM\SQLLIB/conv/ucs21252.cnv
2003-11-11-17.45.39.431000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CBD990 : 0x00000003 ....
PID:4080 TID:1368 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.45.39.451000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CBD960 : 0x00000003 ....
PID:4080 TID:1368 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.45.39.471000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CBDBB0 : 0x00000003 ....
PID:4080 TID:1368 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.45.39.491000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CBDB8C : 0x00000003 ....
PID:4080 TID:1368 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.45.39.672000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
oper system services sqloopenp Probe:110
GetLastError:
0x0215C364 : 0x00000002 ....
PID:1500 TID:1184 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00002.BRG
2003-11-11-17.45.39.902000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:2656 Appid:none
oper system services sqlofindn Probe:100
GetLastError:
0x025DF468 : 0x00000012 ....
2003-11-11-17.45.39.972000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
data protection sqlpinit Probe:160
Database started with next LSN of 00000000007D000C.
2003-11-11-17.45.43.217000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
BSU Java support sqlejReplaceJar Probe:20 Database:ROBS
checking jar file:
0x0215ACD4 : 433A 5C49 424D 5C53 514C 4C49 425C 6675 C:\IBM\SQLLIB\fu
0x0215ACE4 : 6E63 7469 6F6E 5C6A 6172 5C52 4F42 535C nction\jar\ROBS\
0x0215ACF4 : 5351 4C33 3130 3131 3130 3133 3331 3536 SQL3101110133156
0x0215AD04 : 302E 6A61 72 0.jar
2003-11-11-17.45.43.577000 Instance:DB2 Node:000
PID:2532(db2fmp.exe) TID:2508 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012EA48 : 0x00000002 ....
PID:2532 TID:2508 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.45.43.647000 Instance:DB2 Node:000
PID:2532(db2fmp.exe) TID:2508 Appid:none
BSU Java support sqlejSuffixEnv Probe:20
Setting environment variable:
0x6C88BD70 : 0x48544150 PATH
2003-11-11-17.45.43.667000 Instance:DB2 Node:000
PID:2532(db2fmp.exe) TID:2508 Appid:none
BSU Java support sqlejSuffixEnv Probe:21
New value:
0x00685880 : 433A 5C57 494E 444F 5753 5C73 7973 7465 C:\WINDOWS\syste
0x00685890 : 6D33 323B 433A 5C57 494E 444F 5753 3B43 m32;C:\WINDOWS;C
0x006858A0 : 3A5C 5749 4E44 4F57 535C 5379 7374 656D :\WINDOWS\System
0x006858B0 : 3332 5C57 6265 6D3B 633A 5C69 626D 5C73 32\Wbem;c:\ibm\s
0x006858C0 : 716C 6C69 625C 6A61 7661 5C6A 646B 3B43 qllib\java\jdk;C
0x006858D0 : 3A5C 4942 4D5C 5351 4C4C 4942 5C42 494E :\IBM\SQLLIB\BIN
0x006858E0 : 3B43 3A5C 4942 4D5C 5351 4C4C 4942 5C46 ;C:\IBM\SQLLIB\F
0x006858F0 : 554E 4354 494F 4E3B 433A 5C49 424D 5C53 UNCTION;C:\IBM\S
0x00685900 : 514C 4C49 425C 5341 4D50 4C45 535C 5245 QLLIB\SAMPLES\RE
0x00685910 : 504C 3B43 3A5C 4942 4D5C 5351 4C4C 4942 PL;C:\IBM\SQLLIB
0x00685920 : 5C6A 6176 615C 6A64 6B5C 6A72 655C 6269 \java\jdk\jre\bi
0x00685930 : 6E5C 636C 6173 7369 63 n\classic
2003-11-11-17.45.43.677000 Instance:DB2 Node:000
PID:2532(db2fmp.exe) TID:2508 Appid:none
BSU Java support sqlejGetBlocks Probe:22
Attempting to load JEXT DLL Path:
0x0012F7E8 : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x0012F7F8 : 6E n
2003-11-11-17.45.43.697000 Instance:DB2 Node:000
PID:2532(db2fmp.exe) TID:2508 Appid:none
BSU Java support sqlejGetBlocks Probe:27
Attempting to load JEXT DLL Name:
0x6C871BF0 : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x6C871C00 : 6E5C 4442 324A 4558 542E 444C 4C n\DB2JEXT.DLL
2003-11-11-17.45.43.727000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
oper system services sqlofica Probe:10 Database:ROBS
PID:1500 TID:1184 Node:000 Title: SQLCA ^
0x021575AC : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x021575BC : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x021575CC : 2020 2020 2020 2020 2020 2020 2020 2020
0x021575DC : 2020 2020 2020 2020 2020 2020 2020 2020
0x021575EC : 2020 2020 2020 2020 2020 2020 2020 2020
0x021575FC : 2020 2020 2020 2020 5351 4C45 5246 4D45 SQLERFME
0x0215760C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0215761C : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0215762C : 2020 2033 3835 3033 38503
2003-11-11-17.45.43.738000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
oper system services sqlofica Probe:10 Database:ROBS
PID:1500 TID:1184 Node:000 Title: SQLCA ^
0x0205A048 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x0205A058 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x0205A068 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0205A078 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0205A088 : 2020 2020 2020 2020 2020 2020 2020 2020
0x0205A098 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x0205A0A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0205A0B8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0205A0C8 : 2020 2033 3835 3033 38503
2003-11-11-17.45.43.758000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1636 Appid:*LOCAL.DB2.015481174539
DRDA Application Requester sqljrDrdaArCall Probe:110
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8037006D".
PID:4080 TID:1636 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1131 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEJAR
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 38503
2003-11-11-17.45.43.788000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1636 Appid:*LOCAL.DB2.015481174539
oper system services sqlofica Probe:10
PID:4080 TID:1636 Node:000 Title: SQLCA ^
0x09BFC588 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x09BFC598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x09BFC5A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5D8 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x09BFC5E8 : 6D00 3780 0000 0000 0000 0000 0000 0000 m.7.............
0x09BFC5F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x09BFC608 : 2020 2033 3835 3033 38503
2003-11-11-17.49.14.551000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1184 Appid:*LOCAL.DB2.015481174539
data protection sqlpterm Probe:3200
Database shutdown with next LSN of 00000000007D000C.
2003-11-11-17.49.14.571000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:*LOCAL.DB2.015481174539
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x09CBF374 : 0x00000047 G...
2003-11-11-17.49.14.581000 Instance:DB2 Node:000
PID:4080(javaw.exe) TID:1368 Appid:*LOCAL.DB2.015481174539
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
2003-11-11-17.50.07.637000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173822
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x0D42F858 : 0x00000047 G...
2003-11-11-17.50.07.787000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173822
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
2003-11-11-17.50.07.807000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173821
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x0D42F858 : 0x00000047 G...
2003-11-11-17.50.07.817000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173821
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
2003-11-11-17.50.07.837000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173820
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x0D42F858 : 0x00000047 G...
2003-11-11-17.50.07.857000 Instance:DB2 Node:000
PID:2296(db2dasstm.exe) TID:2488 Appid:*LOCAL.DB2.00FBC1173820
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
2003-11-11-17.50.18.813000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:3668 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x025DD5D4 : 0x00000002 ....
PID:1500 TID:3668 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.50.24.481000 Instance:DB2 Node:000
PID:1500(db2syscs.exe) TID:1820 Appid:*LOCAL.DB2.011D81173813
data protection sqlpterm Probe:3200
Database shutdown with next LSN of 0000000000DAC00C.
2003-11-11-17.52.05.770000 Instance:DB2 Node:000
PID:1912(db2jds.exe) TID:1936 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0088E990 : 0x00000002 ....
PID:1912 TID:1936 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.08.735000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:436 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012DED0 : 0x00000002 ....
PID:108 TID:436 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.09.386000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0111EA04 : 0x00000002 ....
PID:808 TID:896 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.09.806000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0111DCA8 : 0x00000003 ....
PID:808 TID:896 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.52.09.886000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0111DC78 : 0x00000003 ....
PID:808 TID:896 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.52.10.087000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0111DEC8 : 0x00000003 ....
PID:808 TID:896 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.52.10.848000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0111DEA4 : 0x00000003 ....
PID:808 TID:896 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.52.10.878000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.10.888001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.10.908000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.10.938000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqlofica Probe:10
PID:808 TID:896 Node:000 Title: SQLCA ^
0x01160588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x01160598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x011605A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x011605E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x011605F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x01160608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.09.506000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x009ACD4C : 0x00000003 ....
PID:108 TID:852 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.52.11.208000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x009ACD1C : 0x00000003 ....
PID:108 TID:852 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.52.11.218000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x009ACF6C : 0x00000003 ....
PID:108 TID:852 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.52.11.228001 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x009ACF48 : 0x00000003 ....
PID:108 TID:852 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.52.11.288001 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:108 TID:852 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.11.308000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:108 TID:852 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.11.328001 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.11.349000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqlofica Probe:10
PID:108 TID:852 Node:000 Title: SQLCA ^
0x007BC588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x007BC598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x007BC5A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x007BC5E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x007BC5F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x007BC608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.11.359000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:108 TID:852 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.11.369001 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:108 TID:852 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.11.389000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.11.389001 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqlofica Probe:10
PID:108 TID:852 Node:000 Title: SQLCA ^
0x007BC588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x007BC598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x007BC5A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x007BC5D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x007BC5E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x007BC5F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x007BC608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.08.755000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007ACD90 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.11.789000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AD8FC : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\apply_names.ini
2003-11-11-17.52.11.799000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2wse2.lvl
2003-11-11-17.52.11.809000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2conee.lvl
2003-11-11-17.52.11.819001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2conpe.lvl
2003-11-11-17.52.11.869000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2ese.lvl
2003-11-11-17.52.11.869002 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2dlm.lvl
2003-11-11-17.52.11.889001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2gse.lvl
2003-11-11-17.52.11.899001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2wm.lvl
2003-11-11-17.52.11.919001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2nse.lvl
2003-11-11-17.52.11.929001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2wse2.lvl
2003-11-11-17.52.11.939001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2conee.lvl
2003-11-11-17.52.11.969000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2conee.lvl
2003-11-11-17.52.11.989000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.12.009001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.12.060000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.12.070000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqlofica Probe:10
PID:808 TID:896 Node:000 Title: SQLCA ^
0x01160588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x01160598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x011605A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x011605E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x011605F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x01160608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.09.416000 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008EE400 : 0x00000002 ....
PID:760 TID:828 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.12.300000 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED688 : 0x00000003 ....
PID:760 TID:828 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.52.12.310001 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED658 : 0x00000003 ....
PID:760 TID:828 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.52.12.320001 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED8A8 : 0x00000003 ....
PID:760 TID:828 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.52.12.350001 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED884 : 0x00000003 ....
PID:760 TID:828 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.52.11.999000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2qpsvr.lvl
2003-11-11-17.52.12.510000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2cube.lvl
2003-11-11-17.52.12.510002 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2rcon.lvl
2003-11-11-17.52.12.530000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2lsdc.lvl
2003-11-11-17.52.12.560000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AC4B0 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\db2exp.lvl
2003-11-11-17.52.12.670000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AD8F4 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\apply_names.ini
2003-11-11-17.52.12.680000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x007AD098 : 0x00000002 ....
PID:468 TID:756 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\cfg\vendor.cfg
2003-11-11-17.52.13.081000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:89 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.13.091001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.13.101001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.13.101002 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqlofica Probe:10
PID:808 TID:896 Node:000 Title: SQLCA ^
0x01160588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x01160598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x011605A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x011605E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x011605F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x01160608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.14.112000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.14.122001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:808 TID:896 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.14.133000 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.14.133001 Instance:DB2 Node:000
PID:808(iwh2serv.exe) TID:896 Appid:none
oper system services sqlofica Probe:10
PID:808 TID:896 Node:000 Title: SQLCA ^
0x01160588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x01160598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x011605A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x011605D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x011605E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x011605F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x01160608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.14.433000 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:760 TID:828 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.14.473001 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqloSSemClose Probe:20
Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.
PID:760 TID:828 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.
2003-11-11-17.52.14.473003 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
DRDA Application Requester sqljrInit Probe:27
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81370012".
2003-11-11-17.52.14.483000 Instance:DB2 Node:000
PID:760(iwh2log.exe) TID:828 Appid:none
oper system services sqlofica Probe:10
PID:760 TID:828 Node:000 Title: SQLCA ^
0x00940588 : 5351 4C43 4120 2020 8800 0000 F8FB FFFF SQLCA ....øûÿÿ
0x00940598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x009405A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x009405B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x009405C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x009405D8 : 2020 2020 2020 2020 5351 4C4A 5243 4C54 SQLJRCLT
0x009405E8 : 1200 3781 1200 0000 0000 0000 0000 0000 ..7.............
0x009405F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x00940608 : 2020 2035 3730 3139 57019
2003-11-11-17.52.14.463000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
oper system services sqlomkdirp Probe:100
GetLastError:
0x008EF6B4 : 0x000000B7 ·...
PID:468 TID:1304 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2
2003-11-11-17.52.14.984001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED3D8 : 0x00000003 ....
PID:468 TID:1304 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.52.14.994001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED3A8 : 0x00000003 ....
PID:468 TID:1304 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.52.15.004000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED5F8 : 0x00000003 ....
PID:468 TID:1304 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.52.15.014001 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x008ED5D4 : 0x00000003 ....
PID:468 TID:1304 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.52.15.094000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
common communication sqlcctcpconnmgr Probe:160
DIA3218I "1" TCP/IP connection manager(s) was/were successfully started.
2003-11-11-17.52.15.104000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1304 Appid:none
common communication sqlcctcp_start_listen Probe:80
DIA3000I "TCPIP" protocol support was successfully started.
2003-11-11-17.52.15.344000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1232 Appid:*LOCAL.DB2.006A81175215
oper system services sqloopenp Probe:110
GetLastError:
0x0111C364 : 0x00000002 ....
PID:468 TID:1232 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.15.875000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:276 Appid:*LOCAL.DB2.006341175216
oper system services sqloopenp Probe:110
GetLastError:
0x0117C364 : 0x00000002 ....
PID:468 TID:276 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.16.105000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:756 Appid:none
base sys utilities startdbm Probe:911
ADM7513W Database manager has started.
2003-11-11-17.52.16.967000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1396 Appid:*LOCAL.DB2.003C01175217
oper system services sqloopenp Probe:110
GetLastError:
0x0128C364 : 0x00000002 ....
PID:468 TID:1396 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.17.397000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1544 Appid:none
oper system services sqlofindn Probe:100
GetLastError:
0x012EF468 : 0x00000012 ....
2003-11-11-17.52.18.649000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1232 Appid:*LOCAL.DB2.006A81175215
data protection sqlpinit Probe:160
Database started with next LSN of 0000000000DAC00C.
2003-11-11-17.52.21.022000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:*LOCAL.DB2.003C01175217
DRDA Communication Manager sqljcReceive Probe:30
CCI Error:
0x009AE4D8 : 0x00000047 G...
2003-11-11-17.52.21.303000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:*LOCAL.DB2.003C01175217
DRDA Communication Manager sqljcReceive Probe:30
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8136001C".
2003-11-11-17.52.22.645000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1196 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x01F0F594 : 0x00000002 ....
PID:468 TID:1196 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQL00001\SQLT0001.0\SQL00002.TDA
2003-11-11-17.52.24.568000 Instance:DB2 Node:000
PID:108(db2dasstm.exe) TID:852 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x009ADE58 : 0x00000002 ....
PID:108 TID:852 Node:000 Title: Path/Filename
C:\IBM\SQLLIB/conv/1252ucs2.cnv
2003-11-11-17.52.27.071000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1396 Appid:*LOCAL.DB2.003C01175227
oper system services sqloopenp Probe:110 Database:DWCTRLDB
GetLastError:
0x0128C364 : 0x00000002 ....
PID:468 TID:1396 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.27.161000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:1396 Appid:*LOCAL.DB2.003C01175227
oper system services sqloopenp Probe:110 Database:DWCTRLDB
GetLastError:
0x0128CC58 : 0x00000002 ....
PID:468 TID:1396 Node:000 Title: Path/Filename
C:\IBM\SQLLIB/conv/ucs21252.cnv
2003-11-11-17.52.27.582000 Instance:DB2 Node:000
PID:2316(db2fmp.exe) TID:2320 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012EA48 : 0x00000002 ....
PID:2316 TID:2320 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.52.27.892000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:2348 Appid:*LOCAL.DB2.003C01175228
oper system services sqloopenp Probe:110
GetLastError:
0x0237C364 : 0x00000002 ....
PID:468 TID:2348 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.28.002000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:2352 Appid:*LOCAL.DB2.003C01175229
oper system services sqloopenp Probe:110
GetLastError:
0x023DC364 : 0x00000002 ....
PID:468 TID:2352 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00001.BRG
2003-11-11-17.52.50.395000 Instance:DB2 Node:000
PID:2508(db2javit.exe) TID:2512 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0010D0B4 : 0x00000002 ....
PID:2508 TID:2512 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.53.09.192000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2532 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0006EC1C : 0x00000002 ....
PID:2528 TID:2532 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.54.02.869000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2840 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CAEC20 : 0x00000002 ....
PID:2528 TID:2840 Node:000 Title: Path/Filename
C:\IBM\SQLLIB/conv/ucs21252.cnv
2003-11-11-17.54.02.909000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2840 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CAD9A8 : 0x00000003 ....
PID:2528 TID:2840 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNODIR
2003-11-11-17.54.02.939000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2840 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CAD978 : 0x00000003 ....
PID:2528 TID:2840 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLNODIR\SQLNOBAK
2003-11-11-17.54.02.969000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2840 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CADBC8 : 0x00000003 ....
PID:2528 TID:2840 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWDIR
2003-11-11-17.54.02.999000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:2840 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x09CADBA4 : 0x00000003 ....
PID:2528 TID:2840 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\SQLGWDIR\SQLGWBAK
2003-11-11-17.54.03.370000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3408 Appid:*LOCAL.DB2.014F81175403
oper system services sqloopenp Probe:110
GetLastError:
0x0253C364 : 0x00000002 ....
PID:468 TID:3408 Node:000 Title: Path/Filename
C:\DB2\NODE0000\SQLDBDIR\SQL00002.BRG
2003-11-11-17.54.03.960000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3420 Appid:none
oper system services sqlofindn Probe:100
GetLastError:
0x0257F468 : 0x00000012 ....
2003-11-11-17.54.04.101000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3408 Appid:*LOCAL.DB2.014F81175403
data protection sqlpinit Probe:160
Database started with next LSN of 00000000007D000C.
2003-11-11-17.54.16.448000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3408 Appid:*LOCAL.DB2.014F81175403
BSU Java support sqlejReplaceJar Probe:20 Database:ROBS
checking jar file:
0x0253ACD4 : 433A 5C49 424D 5C53 514C 4C49 425C 6675 C:\IBM\SQLLIB\fu
0x0253ACE4 : 6E63 7469 6F6E 5C6A 6172 5C52 4F42 535C nction\jar\ROBS\
0x0253ACF4 : 5351 4C33 3130 3131 3130 3133 3331 3536 SQL3101110133156
0x0253AD04 : 302E 6A61 72 0.jar
2003-11-11-17.54.17.620000 Instance:DB2 Node:000
PID:3640(db2fmp.exe) TID:3644 Appid:none
oper system services sqloopenp Probe:110
GetLastError:
0x0012EA48 : 0x00000002 ....
PID:3640 TID:3644 Node:000 Title: Path/Filename
C:\IBM\SQLLIB\DB2\db2nodes.cfg
2003-11-11-17.54.17.900000 Instance:DB2 Node:000
PID:3640(db2fmp.exe) TID:3644 Appid:none
BSU Java support sqlejSuffixEnv Probe:20
Setting environment variable:
0x6C88BD70 : 0x48544150 PATH
2003-11-11-17.54.18.021000 Instance:DB2 Node:000
PID:3640(db2fmp.exe) TID:3644 Appid:none
BSU Java support sqlejSuffixEnv Probe:21
New value:
0x00685880 : 433A 5C57 494E 444F 5753 5C73 7973 7465 C:\WINDOWS\syste
0x00685890 : 6D33 323B 433A 5C57 494E 444F 5753 3B43 m32;C:\WINDOWS;C
0x006858A0 : 3A5C 5749 4E44 4F57 535C 5379 7374 656D :\WINDOWS\System
0x006858B0 : 3332 5C57 6265 6D3B 633A 5C69 626D 5C73 32\Wbem;c:\ibm\s
0x006858C0 : 716C 6C69 625C 6A61 7661 5C6A 646B 3B43 qllib\java\jdk;C
0x006858D0 : 3A5C 4942 4D5C 5351 4C4C 4942 5C42 494E :\IBM\SQLLIB\BIN
0x006858E0 : 3B43 3A5C 4942 4D5C 5351 4C4C 4942 5C46 ;C:\IBM\SQLLIB\F
0x006858F0 : 554E 4354 494F 4E3B 433A 5C49 424D 5C53 UNCTION;C:\IBM\S
0x00685900 : 514C 4C49 425C 5341 4D50 4C45 535C 5245 QLLIB\SAMPLES\RE
0x00685910 : 504C 3B43 3A5C 4942 4D5C 5351 4C4C 4942 PL;C:\IBM\SQLLIB
0x00685920 : 5C6A 6176 615C 6A64 6B5C 6A72 655C 6269 \java\jdk\jre\bi
0x00685930 : 6E5C 636C 6173 7369 63 n\classic
2003-11-11-17.54.18.271000 Instance:DB2 Node:000
PID:3640(db2fmp.exe) TID:3644 Appid:none
BSU Java support sqlejGetBlocks Probe:22
Attempting to load JEXT DLL Path:
0x0012F7E8 : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x0012F7F8 : 6E n
2003-11-11-17.54.18.291000 Instance:DB2 Node:000
PID:3640(db2fmp.exe) TID:3644 Appid:none
BSU Java support sqlejGetBlocks Probe:27
Attempting to load JEXT DLL Name:
0x6C871BF0 : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x6C871C00 : 6E5C 4442 324A 4558 542E 444C 4C n\DB2JEXT.DLL
2003-11-11-17.54.18.441000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3408 Appid:*LOCAL.DB2.014F81175403
oper system services sqlofica Probe:10 Database:ROBS
PID:468 TID:3408 Node:000 Title: SQLCA ^
0x025375AC : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x025375BC : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x025375CC : 2020 2020 2020 2020 2020 2020 2020 2020
0x025375DC : 2020 2020 2020 2020 2020 2020 2020 2020
0x025375EC : 2020 2020 2020 2020 2020 2020 2020 2020
0x025375FC : 2020 2020 2020 2020 5351 4C45 5246 4D45 SQLERFME
0x0253760C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0253761C : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x0253762C : 2020 2033 3835 3033 38503
2003-11-11-17.54.18.622000 Instance:DB2 Node:000
PID:468(db2syscs.exe) TID:3408 Appid:*LOCAL.DB2.014F81175403
oper system services sqlofica Probe:10 Database:ROBS
PID:468 TID:3408 Node:000 Title: SQLCA ^
0x021BE048 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x021BE058 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x021BE068 : 2020 2020 2020 2020 2020 2020 2020 2020
0x021BE078 : 2020 2020 2020 2020 2020 2020 2020 2020
0x021BE088 : 2020 2020 2020 2020 2020 2020 2020 2020
0x021BE098 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x021BE0A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x021BE0B8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x021BE0C8 : 2020 2033 3835 3033 38503
2003-11-11-17.54.18.912000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:3476 Appid:*LOCAL.DB2.014F81175403
DRDA Application Requester sqljrDrdaArCall Probe:110
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x8037006D".
PID:2528 TID:3476 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1131 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEJAR
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 38503
2003-11-11-17.54.18.952000 Instance:DB2 Node:000
PID:2528(javaw.exe) TID:3476 Appid:*LOCAL.DB2.014F81175403
oper system services sqlofica Probe:10
PID:2528 TID:3476 Node:000 Title: SQLCA ^
0x09BFC588 : 5351 4C43 4120 2020 8800 0000 95FB FFFF SQLCA .....ûÿÿ
0x09BFC598 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
0x09BFC5A8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5B8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5C8 : 2020 2020 2020 2020 2020 2020 2020 2020
0x09BFC5D8 : 2020 2020 2020 2020 5351 4C45 4A41 5220 SQLEJAR
0x09BFC5E8 : 6D00 3780 0000 0000 0000 0000 0000 0000 m.7.............
0x09BFC5F8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x09BFC608 : 2020 2033 3835 3033 38503
"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bo**********@hanover.torolab.ibm.com...
Hmmmm...can you post what you see in the db2diag.log when the failure
occurs? (If you can put everything from db2start to the point of
failure, that'd be great).
Rob S wrote:
Tried setting
DB2ROUTINE_DEBUG=OFF
Restarted DB2 (and machine) and still the same problem.
"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bo**********@hanover.torolab.ibm.com...
It might be interesting to try turning off the debug registry var, and
seeing if the -1131 goes away...
In any case, the dari process should never trap on a call to one of our
jar routines...can you contact service?
Rob S wrote:
Further Update :
I rebooted my machine and now I get
ROBS.JAVAPROC1 - Build started.
C:\IBM\SQLLIB\java\jdk\bin\javac -classpath
".;C:\IBM\SQLLIB\java\db2java.zip;C:\IBM\SQLLIB\ja va\runtime.zip;C:\IBM\SQLLIB\java\sqlj.zip" "JAVAPROC1.java"
ROBS.JAVAPROC1 - Javac completed.
C:\IBM\SQLLIB\java\jdk\bin\jar cf SQL31011101331560.jar
JAVAPROC1.classROBS.JAVAPROC1 - Jar file created.
Call sqlj.replace_jar ('file:///C|/Documents and
Settings/RobS/Application
Data/IBM/DB2/DC/Projects/bld1068556626026/SQL31011101331560.jar',
'"ROBS".SQL31011101331560', 0)
[IBM][CLI Driver][DB2/NT] SQL1131N DARI (Stored Procedure) process has
been
terminated abnormally. SQLSTATE=38503
ROBS.JAVAPROC1 - Build failed.
ROBS.JAVAPROC1 - Roll back completed successfully.
Any help would be appreciated. It worked fine after installing UDB
before
rebooting.
My DBM cfg is below
Database Manager Configuration
Node type = Database Server with local clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
1.153307e-006
Max number of concurrently active databases (NUMDB) = 3
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = YES
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) =
C:\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 4
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = OFF
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = YES
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = C:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 46
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 512
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
DRDA services heap size (4KB) (DRDA_HEAP_SZ) = 128
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 100
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 200
Agent pool size (NUM_POOLAGENTS) =
100(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) =
MAX_COORDAGENTS
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initialize fenced process with JVM (INITFENCED_JVM) = NO
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time (INDEXREC) = ACCESS
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = RESCC
SPM log size (SPM_LOG_FILE_SZ) = 256
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 512
And my environment variables
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\RobS\Application Data
CLASSPATH=.;c:\IBMDebug\lib\dertrjrt.jar;C:\IBM\SQ LLIB\java\db2java.zip;C:\I
BM\SQLLIB\java\db2jcc.jar;C:\IBM\SQLLIB\java\sqlj. zip;C:\IBM\SQLLIB\java\db2
jcc_license_cu.jar;C:\IBM\SQLLIB\bin;C:\IBM\SQLLIB \tools\db2XTrigger.jar;C:\IBM\SQLLIB\java\common.jar
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=RESCC
ComSpec=C:\WINDOWS\system32\cmd.exe
DB2INSTANCE=DB2
DB2TEMPDIR=C:\IBM\SQLLIB\
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\RobS
INCLUDE=C:\IBM\SQLLIB\INCLUDE;C:\IBM\SQLLIB\LIB;C: \IBM\SQLLIB\TEMPLATES\INCLUDE
LIB=C:\IBM\SQLLIB\LIB
LOGONSERVER=\\RESCC
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sys tem32\Wbem;C:\IBM\SQLLIB\B
IN;C:\IBM\SQLLIB\FUNCTION;C:\IBM\SQLLIB\SAMPLES\RE PL;c:\ibm\sqllib\java\jdk;PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE; .WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 1, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0801
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\RobS\LOCALS~1\Temp
TMP=C:\DOCUME~1\RobS\LOCALS~1\Temp
USERDOMAIN=RESCC
USERNAME=RobS
USERPROFILE=C:\Documents and Settings\RobS
VWSPATH=C:\IBM\SQLLIB
VWS_LOGGING=C:\IBM\SQLLIB\LOGGING
VWS_TEMPLATES=C:\IBM\SQLLIB\TEMPLATES
windir=C:\WINDOWS
"Rob S" <a@aa.com> wrote in message
news:bo**********@hercules.btinternet.com...
>I have UDB 8.1 Personal Edition installed.
>
>I'm using Development centre to develop JAVA Stored Procedues. I am
unable
>to debug them.
>I have installed IBM Distributed Debugger and have set
DB2ROUTINE_DEBUG=ON.
>I installed Distributed Debugger after UDB. The Procs will build with
debug
>but no debugger window appears when run in debug mode. I followed the
>instructions that came with Debugger regarding the installation
directory
>etc.
>
>SQLPROC debugging works fine.
>
>Do I need to somehow install from UDB ?
>
>Any help would be appreciated ?
>
>