Debugging Java Stored Procs in Stored Procedure Builder 
Author Message
 Debugging Java Stored Procs in Stored Procedure Builder

I have DB2 UDB EE v7.1 with FixPack 3 installed on my machine (Win2K
Server).  I am trying to debug stored procedures created with Stored
Procedure Builder in java (JDBC). I have followed the instructions of
the debugging stored procedures faq on the IBM site but have not been
successful.  Those steps are:

Install the distributed de{*filter*}.
Set the db2 instance to support debugging (db2set
db2routine_debug=on).
Start the de{*filter*} deamon on the client (idebug.exe -qdaemon
-quiport=8000).
Start the stored procedure builder.
Compile stored procedure for debugging. (Proper setting for debug
table)

I then ran the stored proc in SPB.  The de{*filter*} was not invoked.  I
made sure the CLASSLIB environment variable was correct and added the
JDK bin directory to the beginning of the system path.  The STB never
enables its options on the debug tab or tool buttons.

I've also set the DB2_USE_JDK11=TRUE and entered a JDK11_PATH into my
DBM Configuration.  No luck.

If anyone can point me in the right direction I'd really appreciate
it.  I'm new to DB2 UDB and can't seem to locate the proper reference
material.  Thanks.



Mon, 31 Jan 2005 07:14:56 GMT
 Debugging Java Stored Procs in Stored Procedure Builder

Quote:

> I have DB2 UDB EE v7.1 with FixPack 3 installed on my machine (Win2K
> Server).  I am trying to debug stored procedures created with Stored
> Procedure Builder in java (JDBC). I have followed the instructions of
> the debugging stored procedures faq on the IBM site but have not been
> successful.  Those steps are:

> Install the distributed de{*filter*}.
> Set the db2 instance to support debugging (db2set
> db2routine_debug=on).
> Start the de{*filter*} deamon on the client (idebug.exe -qdaemon
> -quiport=8000).
> Start the stored procedure builder.
> Compile stored procedure for debugging. (Proper setting for debug
> table)

> I then ran the stored proc in SPB.  The de{*filter*} was not invoked.  I
> made sure the CLASSLIB environment variable was correct and added the
> JDK bin directory to the beginning of the system path.  The STB never
> enables its options on the debug tab or tool buttons.

> I've also set the DB2_USE_JDK11=TRUE and entered a JDK11_PATH into my
> DBM Configuration.  No luck.

There is no DB2_USE_JDK11 only a DB2_USE_JDK12. Do you use a Java2 JVM?
I remember there were some problems in earlier fixpacks for debugging
Java2 JVMs (actually there's also a difference between JDK1.2.1 and
JDK1.2.2). What's the exact JVM version you're using? Do a "java
-fullversion"

Quote:
> If anyone can point me in the right direction I'd really appreciate
> it.  I'm new to DB2 UDB and can't seem to locate the proper reference
> material.  Thanks.

Your setup seems right. I recommend either using an Java1 or a Java2 JVM
with the latest fixpack.

Regards, Dirk

--
-------------- This is not an IBM official response --------------

All the information and opinions expressed herein are those of the
author and are not an official IBM statement.

It's also not OK to contact the author with questions using his
email adress.



Tue, 01 Feb 2005 00:37:09 GMT
 Debugging Java Stored Procs in Stored Procedure Builder

Quote:


> > I have DB2 UDB EE v7.1 with FixPack 3 installed on my machine (Win2K
> > Server).  I am trying to debug stored procedures created with Stored
> > Procedure Builder in java (JDBC). I have followed the instructions of
> > the debugging stored procedures faq on the IBM site but have not been
> > successful.  Those steps are:

> > Install the distributed de{*filter*}.
> > Set the db2 instance to support debugging (db2set
> > db2routine_debug=on).
> > Start the de{*filter*} deamon on the client (idebug.exe -qdaemon
> > -quiport=8000).
> > Start the stored procedure builder.
> > Compile stored procedure for debugging. (Proper setting for debug
> > table)

> > I then ran the stored proc in SPB.  The de{*filter*} was not invoked.  I
> > made sure the CLASSLIB environment variable was correct and added the
> > JDK bin directory to the beginning of the system path.  The STB never
> > enables its options on the debug tab or tool buttons.

> > I've also set the DB2_USE_JDK11=TRUE and entered a JDK11_PATH into my
> > DBM Configuration.  No luck.

> There is no DB2_USE_JDK11 only a DB2_USE_JDK12. Do you use a Java2 JVM?
> I remember there were some problems in earlier fixpacks for debugging
> Java2 JVMs (actually there's also a difference between JDK1.2.1 and
> JDK1.2.2). What's the exact JVM version you're using? Do a "java
> -fullversion"

> > If anyone can point me in the right direction I'd really appreciate
> > it.  I'm new to DB2 UDB and can't seem to locate the proper reference
> > material.  Thanks.

> Your setup seems right. I recommend either using an Java1 or a Java2 JVM
> with the latest fixpack.

> Regards, Dirk

Thanks Dirk,

Here's the output from the java -fullversion command:

D:\Documents and Settings\jbodamer>java -fullversion
java full version "JDK 1.1.8 IBM build n118p-19991124 (JIT enabled:
ibmjitc V3.5
-IBMJDK1.1-19991124)"

I'm looking for the 1.2.2 JDK on IBM's site now, hoping that an
upgrade will solve my debugging problem.  I appreciate your help, any
other ideas would be welcome.  Thanks again.



Tue, 01 Feb 2005 23:21:48 GMT
 Debugging Java Stored Procs in Stored Procedure Builder

Quote:


> Thanks Dirk,

> Here's the output from the java -fullversion command:

> D:\Documents and Settings\jbodamer>java -fullversion
> java full version "JDK 1.1.8 IBM build n118p-19991124 (JIT enabled:
> ibmjitc V3.5
> -IBMJDK1.1-19991124)"

> I'm looking for the 1.2.2 JDK on IBM's site now, hoping that an
> upgrade will solve my debugging problem.  I appreciate your help, any
> other ideas would be welcome.  Thanks again.

Try it with the JDK1.1.8 first and make sure DB2_USE_JDK12 isn't set.

Is there anything in db2diag.log when you debug?

Dirk

--
-------------- This is not an IBM official response --------------

All the information and opinions expressed herein are those of the
author and are not an official IBM statement.

It's also not OK to contact the author with questions using his
email adress.



Tue, 01 Feb 2005 23:55:42 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Calling a Java Stored Procedure from another Java Stored Stored Procedure

2. Gettting SQL0751N trying to call java stored procedure from a java stored procedure

3. Stored procedures problem using DB2 Stored Procedure Builder

4. Debugging Java stored procedures on AS/400

5. Stored Procedures Builder on OS/390 - Java

6. Stored Procedure Builder and VisualAge for Java

7. Stored Procedure Builder does not start from VA Java 3.02

8. Calling Java Stored Procedure from SQL Stored Procedure

9. Debugging stored procs

10. Debug Stored Procs

11. Suddenly cant debug SqlServer7 Stored Procs with Interdev

12. Debugging Stored procs in SQL 2000


 
Powered by phpBB® Forum Software