Install problems re DB2 V8 (FP8)

[Henry Reardon]

I installed DB2 for Linux, Unix, and Windows on V8.2 (i.e. 8.1.7) on
Windows XP on Friday. I had some problems with migration which are still
outstanding - see my earlier thread - but I managed to drop the old
SAMPLE database and create a new one that works fine. That enabled me to
resume work on my current project.

However, I am having problems with UDFs over and above the ones I
mentioned in the earlier thread. I have a UDF that worked perfectly in
DB2 V7.2 and I've been trying to prepare it against DB2 8.2. Every time
I try though, I get SQL1131N DARI (Stored Procedure process has been
terminated abnormally. SQLSTATE=38503) on the call sqlj.install_ja r()
statement.

I also tried using the Development Center to make a simple Java Stored
Procedure but it keeps tripping over SQL1131N too.

I've tried installing FP8 to see if that would help but I didn't see any
difference in behaviour for either my UDF or the new stored proc; I
invariably get SQL1131N during the call to sqlj.install_ja r().

I find this strange because I thought SQL1131N only occurred when a
stored procedure or UDF contained an error that was detected when the
proc or UDF was running; I don't believe I ever encountered SQL1131N
during preparation of a program before.

I checked my DBM configuration and noticed that the JDK_PATH was wrong;
it was still set to the 1.2 JDK which I had used in DB2 7.2. I changed
it to C:\Program Files\SQLLIB\ja va\jdk but this made no difference in
the behaviour I get. I looked at JAVA_HEAP_SZ and it is 4096; that is
the correct value, isn't it?

I also noticed that my (System) CLASSPATH value contained C:\Program
Files\SQLLIB\ja va\java12\jdk\l ib\tools.jar so I removed the java12
directory from that path to make it conform to the true location of the
1.4 JDK with DB2 8.2.

Since I'm still getting the SQL1131N, I assume that there is still more
that I need to change. Can anyone tell me what those things are?
---

Also, I also noticed that the JDK in the Environment Settings of the
Development Center was set to 1.3 but no directory path was specified. I
changed this to JDK 1.4 and set the directory path to C:\Program Files
\SQLLIB\java\jd k and click 'OK'. However, if I go back in and check it
immediately, the JDK is set back to 1.3, although it has remembered my
directory path. Of course, the JDK in DB2 is 1.4, not 1.3, so I don't
know if this is going to work. Why isn't DB2 remembering the JDK change?
Or is DB2 trying to tell me that I *must* use JDK 1.3 with the
Development Center?
--
Henry

[Gert van der Kooij]

In article <6%************ *******@news20. bellglobal.com> , Henry
Reardon (He************ *****@hotmail.c om) says...

Sorry I can't help directly (my last linux system was active about 5
years ago) but maybe the DB2 HOWTO contains some missing links.
You can find it at http://www.tldp.org/HOWTO/DB2-HOWTO/

[Henry Reardon]

Gert van der Kooij <ge**@invalid.n l> wrote in
news:MP******** *************** *@news.xs4all.n l:

In article <6%************ *******@news20. bellglobal.com> , Henry
Reardon (He************ *****@hotmail.c om) says...

Sorry I can't help directly (my last linux system was active about 5
years ago) but maybe the DB2 HOWTO contains some missing links.
You can find it at http://www.tldp.org/HOWTO/DB2-HOWTO/

Uhh, actually I'm running Windows XP (SP1) and said so in my post. I guess
you saw the "DB2 for Linux, Unix and Windows" and assumed I was running
Linux.

Do you have any ideas for Windows?
--
Henry

[Gert van der Kooij]

In article <HW************ *******@news20. bellglobal.com> , Henry
Reardon (He************ *****@hotmail.c om) says...

Gert van der Kooij <ge**@invalid.n l> wrote in
news:MP******** *************** *@news.xs4all.n l:

In article <6%************ *******@news20. bellglobal.com> , Henry
Reardon (He************ *****@hotmail.c om) says...

Sorry I can't help directly (my last linux system was active about 5
years ago) but maybe the DB2 HOWTO contains some missing links.
You can find it at http://www.tldp.org/HOWTO/DB2-HOWTO/

Uhh, actually I'm running Windows XP (SP1) and said so in my post. I guess
you saw the "DB2 for Linux, Unix and Windows" and assumed I was running
Linux.

Do you have any ideas for Windows?

Sorry, I must have been sleaping already :)

I can only confirm your observation that setting another JDK in the
environments settingd isn't saved. Sorry I can't help any further.