472,780 Members | 2,062 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 software developers and data experts.

Error running SQLJ.INSTALL_JAR

Hi,

(V8.1 FP2)

Trying to run SQLJ.INSTALL_JAR, we get the following error

SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
SQLSTATE=38503

Not sure why this has started failing now (we did upgrade to fp2 fairly
recently, so don't know if there is something that needs rebinding?)

The trouble is, it doesn't log any messages to give us a clue as to
what the internal problem is ?

Can we by-pass this CALL completely by simply manually copying the JAR files into
sqllib/function/jar/INSTANCE

ourselves, or is there something else this Proc. does ?
PS. why is it in schema SQLJ anyway? and why is it not present in SYSCAT.PROCEDURES?

Thanks.

Paul.
Nov 12 '05 #1
4 4974
Ah Paul, so many questions. :-)

Answers inline.

Paul Reddin wrote:
Hi,

(V8.1 FP2)

Trying to run SQLJ.INSTALL_JAR, we get the following error

SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
SQLSTATE=38503

Not sure why this has started failing now (we did upgrade to fp2 fairly
recently, so don't know if there is something that needs rebinding?)

The trouble is, it doesn't log any messages to give us a clue as to
what the internal problem is ? Do you get a trap file in the db2dump directory? If not, can you email
me a server side trace?
Can we by-pass this CALL completely by simply manually copying the JAR files into
sqllib/function/jar/INSTANCE The problem will be that you won't be able to create the procedure using
a jar file in the external name...on the create of a parm style java
stored proc, we acutally validate that the jar entry exists in the
sysjar schemas, and look at the jar for the class that's specified. This
is part of the sqlj part 1 spec (see below).

ourselves, or is there something else this Proc. does ?
PS. why is it in schema SQLJ anyway? and why is it not present in SYSCAT.PROCEDURES? This was done as part of SQLJ part 1 (java standards...see www.sqlj.org
for more info). We can't catalog it because it does funny things to the
sp parameters, such as materializing the first parm (url) into a blob if
the jar file lives on the client system. At some point we want to deploy
a version called db2_install_jar or the like that will take the lob parm
directly, live in the system catalogs, and be compilable etc.

Thanks.

Paul.


Nov 12 '05 #2
Some were ponderings rather than questions directly! :-)
- Thanks for all the answers.

- It's great to get immediate feedback on this as it is really
hindering our progress.

We have now solved the problem (to a point).

The issue seems to be that SQLJ.INSTALL_JAR does not work
when we use JDK 1.4.1 (which we need to use for JAVA Regular
Expression support)

So having reset JDK_PATH=/opt/IBMJava2-131, we are able to run
it succesfully!

However, having run successfully, we we now change back to
JDK_PATH=/opt/IBMJava2-141, to be able to run our UDFs, and we get
two dbfmp processes which spin-off running @ 100% CPU and never
come back (query never ends) ???

We know the UDFs work under 1.4.1, as they are runnning fine on
another machine (with JDK_PATH=/opt/IBMJava2-141, which was created
from a backup/restore of the database which is now not working).

So, may be running of INSTALL_JAR with 1.3.1 is not compatible with
actually
running the UDFs with 1.4.1 ??

This is really hurting my head, I thought Java was meant to get away
from all these inter-dependencies, it just seems to be worse! :-(

Thanks again.

Paul.


Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bo**********@hanover.torolab.ibm.com>...
Ah Paul, so many questions. :-)

Nov 12 '05 #3
Paul,

The only thing that we do on install_jar in a db2fmp, is read out this
list of classes for the jar that's being installed. Other than that,
there should be no lingering effect on the system, when the JDK is
changed (unless we somehow got back a bad list of classes with the 1.3
jdk, but I'd find that very surprising)...

Are you _sure_ the JDK is at the same level on both systems (the one
that works, vs this one)? I had seen problems on early jdk levels with
the jvm starting, and to me it sounds like this is what you were seeing
both for the install_jar, and maybe for this hanging problem (hung on a
severe trap?!?)...

BTW, I was able to run install_jar on a windows box, and AIX box with
the IBM 1.4.1 jdks...both the jvm builds were pretty recent. I'm also
aware of a problem with 1.4.1 SUN jvms where poll is being used too
frequently, and the CPU use in idle fmps is high (being investigated by
SUN)...

Paul Reddin wrote:
Some were ponderings rather than questions directly! :-)
- Thanks for all the answers.

- It's great to get immediate feedback on this as it is really
hindering our progress.

We have now solved the problem (to a point).

The issue seems to be that SQLJ.INSTALL_JAR does not work
when we use JDK 1.4.1 (which we need to use for JAVA Regular
Expression support)

So having reset JDK_PATH=/opt/IBMJava2-131, we are able to run
it succesfully!

However, having run successfully, we we now change back to
JDK_PATH=/opt/IBMJava2-141, to be able to run our UDFs, and we get
two dbfmp processes which spin-off running @ 100% CPU and never
come back (query never ends) ???

We know the UDFs work under 1.4.1, as they are runnning fine on
another machine (with JDK_PATH=/opt/IBMJava2-141, which was created
from a backup/restore of the database which is now not working).

So, may be running of INSTALL_JAR with 1.3.1 is not compatible with
actually
running the UDFs with 1.4.1 ??

This is really hurting my head, I thought Java was meant to get away
from all these inter-dependencies, it just seems to be worse! :-(

Thanks again.

Paul.


Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bo**********@hanover.torolab.ibm.com>...
Ah Paul, so many questions. :-)


Nov 12 '05 #4
Sean,

Thanks for the feedback again.

Yesterday, we managed to install the UDFs on yet another Linux Box,
and this worked! i.e install_jar and UDFs both run correctly with
JDK1.4.1

So, out of 4 servers we now have the following:
2 work & 2 don't.

So it is looking like there is a combination of Linux & JVM level that
isn't
working.

Interestingly, the two that work are Single CPU runnning RedHat 7.3,
the two that don't are 2x CPU RedHat AS 2.1.

So, in conclusion, we are investigating the Linux,JVM combinations to
get this working consistently.

Thanks for all your help.

Paul.
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bernard Dhooghe | last post by:
DB2 UDB V8.1 Fixpak 4 AIX 5.1 CLASSPATH: /usr/opt/db2_08_01/java/db2jcc.jar:/usr/opt/db2_08_01/java/db2jcc_license_cu.jar:/usr/opt/db2_08_01/java/sqlj.zip:/usr/java131/jre/lib/rt.jar: Program:...
10
by: Raquel | last post by:
UDB PE 8.1 on Win XP. ok, this function caused a lot of grief today. My stored procedures are java stored procedures, all FENCED and directly placed in \sqllib\function directory (not built into...
2
by: Raquel | last post by:
UDB V8.1.3 on XP. While trying out SQLj procedures, I just 'compile' my stored procedure code (by command sqlj program-name.sqlj) and run it. That's it. So, how and when is db2profc and all the...
7
by: Jean-Marc Blaise | last post by:
Hi, The dev center calls sqlj.DB2_UPDATEJARINFO ('JMARC.JMB','JMB','file:JMB.sqlj') to update the sqlj routine source. I tried in CLP from the directory containing jar and sqlj files (Windows...
4
by: tomtailor | last post by:
Hello! I try to create a Java Procedure in DB2 running under SuSE 9.3. But the install_jar command fails with: Error 58004 Error starting the Java Interpeter. a db2set -all command results...
3
by: tol7481 | last post by:
Hi, I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box, but I have some problems. I've added to the classpath the following JARs sqllib/java/db2java.zip...
0
by: mzhang | last post by:
Hi, Can anyone help? I'm kind stuck. I have db2 workgroup 8.2 on RHEL 4.0, java 1.4.2. Here is the errors db2 " call sqlj.install_jar ('file:/home/int24/vap/phx/vap/storedProc.jar', ...
1
by: vasilip | last post by:
I'm trying to insert large polygon data via sql statement. since the data was over 32k I had to use sqlj to insert my data. I made a class that inserts the data. ran sqlj, generated the .java...
0
by: ajitkathar | last post by:
In my SQLJ procedure , there is call to another stored procedure using a callable statement. But during excecution when .excute() happens . . the DB2 V7 database shuts down. Plz help. Follwing...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.