Windows 2000
udb v 7.2
Got the latest fixpak 13
Applied it.
Still can't get a single java sp to run.
I used to get reason "2"... now reason "0" - reason 0 is not even
documented.
I point jdk11_path to:
Java Development Kit 1.1 installation path (JDK11_PATH) =
g:\sqllib\java
I used to point to a 1.4 jdk I had installed with the same errors.
Tried simple routines.... last try was with samples provided.
Followed instructions.
java Spserver.java
copy files to %DB2PATH\function
registered/cataloged sp
compiled client
ran client...
Just errors.
Call stored procedure named IN_PARAMS
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL4301N Java
interpre
ter startup or communication failed, reason code "0". SQLSTATE=58004
Any ideas:
I have attached the last errors from the log file:
2005-04-20-22.53.50.878000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP Probe:101
..;g:\SQLLIB\java\db2java.zip;g:\SQLLIB\java\runti me.zip;g:\SQLLIB\java\sqlj..zip;g:\SQLLIB\bin
2005-04-20-22.53.50.908000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
oper_system_services sqloJVMstart Probe:35
Attempting to load JNI Path:
673a 5c73 716c 6c69 625c 6a61 7661 5c62 g:\sqllib\java\b
696e in
2005-04-20-22.53.50.938000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
oper_system_services sqloJVMstart Probe:27
Attempting to load JNI Name:
673a 5c73 716c 6c69 625c 6a61 7661 5c62 g:\sqllib\java\b
696e 5c6a 6176 6169 2e64 6c6c in\javai.dll
2005-04-20-22.53.50.968000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
oper_system_services sqloJVMstart Probe:30
sqloloadmodule failed. RC:
0ae6 ffff .æÿÿ
2005-04-20-22.53.50.988000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
oper_system_services sqloJAttach Probe:5
JVM startup failed. RC:
34ef ffff 4ïÿÿ
2005-04-20-22.53.51.008000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejAttach Probe:10
Error from sqloJAttach. RC:
34ef ffff 4ïÿÿ
2005-04-20-22.53.51.028000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP_dll Probe:10
Error from attach. rc:34ef ffff
4ïÿÿ
2005-04-20-22.53.51.058000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP_dll Probe:150
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFEF33".
2005-04-20-22.53.51.068000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP_dll Probe:160
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFEF33".
2005-04-20-22.53.51.088000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP_dll Probe:170
DIA9999E An internal error occurred. Report the following error code :
"0x
0".
2005-04-20-22.53.51.108000 Instance:DB2 Node:000
PID:1968(db2dari.exe) TID:968 Appid:
BSU Java support sqlejCallSTP Probe:30
Error from DB2JEXT CallSTP. RC:
33ef ffff 3ïÿÿ
Data Title:SQLCA PID:104 TID:1924 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -4301 sqlerrml: 1
sqlerrmc: 0
sqlerrp : SQL07029
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: 58004
Data Title:DB2RA PID:104 TID:1924 Node:000
5351 4c44 4232 5241 2801 0000 0501 0200 SQLDB2RA(.......
2900 1700 8800 0000 0900 0080 f0fb 3201 )...ˆ... ..€ðû2.
0000 0000 0000 0000 0000 0000 0c00 0000 ................
0400 0040 5801 3a01 0200 0000 0800 0040 ...@X.:........@
6401 3a01 0800 0000 0100 0040 6801 3a01 d.:........@h.:.
0800 0000 0100 0040 7001 3a01 0800 0000 .......@p.:.....
0100 0040 7801 3a01 2002 0000 0500 0040 ...@x.:. ......@
8001 3a01 2002 0000 0500 00c0 3c04 3a01 €.:. ......À<.:.
0400 0000 0700 0080 2c08 3a01 0f00 0000 .......€,.:.....
0100 0040 5c06 3a01 c400 0000 0400 0040 ...@\.:.Ä......@
6c06 3a01 0400 0000 0700 00c0 3007 3a01 l.:........À0.:.
0400 0000 0700 00c0 3407 3a01 0400 0000 .......À4.:.....
0700 00c0 3807 3a01 0400 0000 0700 00c0 ...À8.:........À
3c07 3a01 0400 0000 0700 00c0 4007 3a01 <.:........À@.:.
0400 0000 0700 00c0 4407 3a01 0000 0000 .......ÀD.:.....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 3c00 0000 0400 00c0 fcee 3201 ....<......Àüî2.
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........
Data Title:SQLCA PID:1936 TID:260 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -4301 sqlerrml: 1
sqlerrmc: 0
sqlerrp : SQL07029
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: 58004
Data Title:DB2RA PID:1936 TID:260 Node:000
5351 4c44 4232 5241 2801 0000 0501 0200 SQLDB2RA(.......
2900 1700 8800 0000 0900 0080 0cf1 0600 )...ˆ... ..€.ñ..
0000 0000 0000 0000 0000 0000 0c00 0000 ................
0400 0040 c0de 0600 0200 0000 0800 0040 ...@ÀÞ.........@
e2f0 0600 0800 0000 0100 0040 d2f0 0600 âð.........@Òð..
0800 0000 0100 0040 52f0 0600 0800 0000 .......@Rð......
0100 0040 daf0 0600 2002 0000 0500 0040 ...@Úð.. ......@
e0f8 630b 2002 0000 0500 00c0 e0f8 630b àøc. ......Ààøc.
0400 0000 0700 0080 dcd2 0600 0f00 0000 .......€ÜÒ......
0100 0040 40ef 0600 c400 0000 0400 0040 ...@@ï..Ä......@
48f0 0600 0400 0000 0700 00c0 ecd2 0600 Hð.........ÀìÒ..
0400 0000 0700 00c0 f0d2 0600 0400 0000 .......ÀðÒ......
0700 00c0 f4d2 0600 0400 0000 0700 00c0 ...ÀôÒ.........À
f8d2 0600 0400 0000 0700 00c0 fcd2 0600 øÒ.........ÀüÒ..
0400 0000 0700 00c0 00d3 0600 0000 0000 .......À.Ó......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 3c00 0000 0400 00c0 f07c 2c0b ....<......Àð|,.
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........