every java sp gets error:sql4301N java interpreter startup or com failed. reason 0

[acemann7]

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 ........

[Sean McKeough]

It's failing because the jdk doesn't have g:\sqllib\java\bin\javai.dll
(error thrown is file not found).

Note that version 7 only supports up to the 1.2 jdk. It can't start a
1.3 or 1.4 jvm...if you're using the 1.2 jdk you have to set a registry
var (DB2_USE_JDK_12=on) (these issues all go away with db2 v8).

ac******@hotmail.com wrote:

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\runtim e.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 ........

[acemann7]

Thanks for your suggestion.
You were right about the JDK11_PATH env variable in dbm cfg. I set it to
g:\sqllib\java\jdk (same one found in \sqllib\java\jre\bin also.) and got
further....
But I am still getting no where. More errors.

Also I think you ment DB2SET DB2_USE_JDK12 not JDK_12....
But is it "=1" or "=on". I see people using =1 on the web when I searched.

Can you please clarify:
1. when I javac the java code. Which javac should be used.
I see db2 v7 has 2 javac's. 1 in sqllib\java\java12\jdk\bin and the
other in \SQLLIB\java\jdk\bin
- lets say we want the 1.2 compiler and runtime only....

2. when i execute java.exe. which one should I use. There are 3 supplied in
db2, \sqllib\java\java12\jdk\bin which is the same as the one in
\sqllib\java\java12\jdk\jre\bin
and also in \sqllib\java\jdk\bin.

When I use the javac in the \sqllib\java\java12\jdk\bin\javac location I get
an error with the db2 supplied java source called: Spclient.java
error is:

G:\SQLLIB\function>\sqllib\java\java12\jdk\bin\jav ac Spclient.java
Note: Spclient.java uses or overrides a deprecated API. Recompile with "-deprec
ation" for details.
1 warning
What am I doing wrong.
I thought I followed all the steps.

[Sean McKeough]

Inline:

acemann7 wrote:

Thanks for your suggestion.
You were right about the JDK11_PATH env variable in dbm cfg. I set it to
g:\sqllib\java\jdk (same one found in \sqllib\java\jre\bin also.) and got
further....
But I am still getting no where. More errors.

Also I think you ment DB2SET DB2_USE_JDK12 not JDK_12....
But is it "=1" or "=on". I see people using =1 on the web when I searched.

Can you please clarify:
1. when I javac the java code. Which javac should be used.
I see db2 v7 has 2 javac's. 1 in sqllib\java\java12\jdk\bin and the
other in \SQLLIB\java\jdk\bin
- lets say we want the 1.2 compiler and runtime only.... If you're using the 1.2 compiler + runtime, then I'd suggest using the
1.2 javac...
the java compilers are all upwards compatible, but that'd be the safest.
2. when i execute java.exe. which one should I use. There are 3 supplied in
db2, \sqllib\java\java12\jdk\bin which is the same as the one in
\sqllib\java\java12\jdk\jre\bin
and also in \sqllib\java\jdk\bin.
You're talking about for your application now, right? I'm not sure of
the JDK levels for our clients, but they shouldn't affect the invocation
of the sp. When I use the javac in the \sqllib\java\java12\jdk\bin\javac location I get
an error with the db2 supplied java source called: Spclient.java
error is:

G:\SQLLIB\function>\sqllib\java\java12\jdk\bin\jav ac Spclient.java
Note: Spclient.java uses or overrides a deprecated API. Recompile with "-deprec
ation" for details.
1 warning

This isn't an error, it's just a warning...some of our tests throw
similar warnings. I think they're safe to ignore...if you're worried
about them, you can compile with the flag listed, to see which java
built in methods are being complained about.

[Philip Sherman]

The Java language evolves with time. Some APIs are "depreciated" or
"retired from active use". A depreciated API can be used but will be
flagged as a warning error which can be bypassed by using the "-deprec"
flag when compiling the program.

Your best option is to check all of the APIs you used in the program and
rewrite the depreciated one to use the replacement API. If you don't
want to do this; then add the option to your javac compile.

Phil Sherman

acemann7 wrote:

Thanks for your suggestion.
You were right about the JDK11_PATH env variable in dbm cfg. I set it to
g:\sqllib\java\jdk (same one found in \sqllib\java\jre\bin also.) and got
further....
But I am still getting no where. More errors.

Also I think you ment DB2SET DB2_USE_JDK12 not JDK_12....
But is it "=1" or "=on". I see people using =1 on the web when I searched.

Can you please clarify:
1. when I javac the java code. Which javac should be used.
I see db2 v7 has 2 javac's. 1 in sqllib\java\java12\jdk\bin and the
other in \SQLLIB\java\jdk\bin
- lets say we want the 1.2 compiler and runtime only....

2. when i execute java.exe. which one should I use. There are 3 supplied in
db2, \sqllib\java\java12\jdk\bin which is the same as the one in
\sqllib\java\java12\jdk\jre\bin
and also in \sqllib\java\jdk\bin.

When I use the javac in the \sqllib\java\java12\jdk\bin\javac location I get
an error with the db2 supplied java source called: Spclient.java
error is:

G:\SQLLIB\function>\sqllib\java\java12\jdk\bin\jav ac Spclient.java
Note: Spclient.java uses or overrides a deprecated API. Recompile with "-deprec
ation" for details.
1 warning
What am I doing wrong.
I thought I followed all the steps.