Stored Procedure Builder on UDB 6.1

Pierre Evans

Stored Procedure Builder on UDB 6.1
Greetings all,
Has anyone used the new Stored Procedure Builder yet in UDB 6.1 ?
I've started to test it but haven't been able to successfully build a Java
SP (although it will generate). I keep getting a SQL4301, which indicates
"An error occurred while attempting to start or communicate with
a Java interpreter".

I get a reason code of 0 which does not match any in the explanation.
I suspect the issue to be the location of the "Java Development Kit 1.1
installation path" , as it wasn't
set initially in the DBM configuration . How can I determine the
appropriate location ?

The Control Center/Stored Procedure Builder is on a Windows NT client ,
with UDB EEE installed on a RS6000 SP.
Thanks in advance
Pierre



Leo Pedron

Re: Stored Procedure Builder on UDB 6.1
(in response to Pierre Evans)
Try setting the (KEEPDARI) parameter in the DBM CFG to NO and set the
(JAVA11_PATH) parm to \SQLLIB\JAVA\JDK. Refer to the Application Building
Guide and Application Development Guide for sample stored procedure source
code that you can use to test the SPB. You can find them online
http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report#UDBPUBS

These examples helped us to find our mistakes. My experience with the SPB
is only with JDBC apps.

Leo Pedron
Boscov's Dept Stores

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Tuesday, January 04, 2000 10:31 AM
To: [login to unmask email]
Subject: Stored Procedure Builder on UDB 6.1


Greetings all,
Has anyone used the new Stored Procedure Builder yet in UDB 6.1 ?
I've started to test it but haven't been able to successfully build a Java
SP (although it will generate). I keep getting a SQL4301, which indicates
"An error occurred while attempting to start or communicate with
a Java interpreter".

I get a reason code of 0 which does not match any in the explanation.
I suspect the issue to be the location of the "Java Development Kit 1.1
installation path" , as it wasn't
set initially in the DBM configuration . How can I determine the
appropriate location ?

The Control Center/Stored Procedure Builder is on a Windows NT client ,
with UDB EEE installed on a RS6000 SP.
Thanks in advance
Pierre








Pierre Evans

Re: Stored Procedure Builder on UDB 6.1
(in response to Leo Pedron)
Leo,
I tried setting those DBM parms but the only difference is that I now
get a return code "1" with SQL4301. I suspect the problem is caused by the
JDK - I dont recall installing that on the system, hence there's no jdk
subdirectory in \sqllib\java.
Do you know if the JDK is installed by default when UDB 6.1 is installed,
or is it a separate install ?
I used lslpp to check the software installed, and it listed Java Support,
but not the JDK. Just skimming through the install cd's doesnt reveal any
for JDK.
Thanks for your input.
Pierre




Leo Pedron <[login to unmask email]> on 01/04/2000 10:51:12 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Pierre Evans/STS/AUTOZONE)
Subject: Re: Stored Procedure Builder on UDB 6.1




Try setting the (KEEPDARI) parameter in the DBM CFG to NO and set the
(JAVA11_PATH) parm to \SQLLIB\JAVA\JDK. Refer to the Application Building
Guide and Application Development Guide for sample stored procedure source
code that you can use to test the SPB. You can find them online
http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report#UDBPUB
S

These examples helped us to find our mistakes. My experience with the SPB
is only with JDBC apps.

Leo Pedron
Boscov's Dept Stores

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Tuesday, January 04, 2000 10:31 AM
To: [login to unmask email]
Subject: Stored Procedure Builder on UDB 6.1


Greetings all,
Has anyone used the new Stored Procedure Builder yet in UDB 6.1 ?
I've started to test it but haven't been able to successfully build a Java
SP (although it will generate). I keep getting a SQL4301, which indicates
"An error occurred while attempting to start or communicate with
a Java interpreter".

I get a reason code of 0 which does not match any in the explanation.
I suspect the issue to be the location of the "Java Development Kit 1.1
installation path" , as it wasn't
set initially in the DBM configuration . How can I determine the
appropriate location ?

The Control Center/Stored Procedure Builder is on a Windows NT client ,
with UDB EEE installed on a RS6000 SP.
Thanks in advance
Pierre



the










Leo Pedron

Re: Stored Procedure Builder on UDB 6.1
(in response to Pierre Evans)
The JDK is installed as a part of the SDK. I believe that the SDK now comes
as a part of UDB 6.1, but I'm not sure that it installed by default. If you
don't have a \SQLLIB\JAVA\JDK directory then you most likely need to install
the SDK. The SDK can be downloaded from www.software.ibm.com/data/db2/java
if your CD doesn't have it. I have only installed this product on NT
servers(so far), it may be different on UNIX based platforms.

After you're sure that you have installed the SDK, I believe that you also
need to add \SQLLIB\JAVA\jdbc\bin to your path. Also be sure that
\SQLLIB\FUNCTION directory is part of you path, but I believe that this is
included automatically. This default may be part of the SDK install.

HTH,
Leo Pedron
Boscov's Dept Stores

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Wednesday, January 05, 2000 11:58 AM
To: [login to unmask email]
Subject: Re: Stored Procedure Builder on UDB 6.1


Leo,
I tried setting those DBM parms but the only difference is that I now
get a return code "1" with SQL4301. I suspect the problem is caused by the
JDK - I dont recall installing that on the system, hence there's no jdk
subdirectory in \sqllib\java.
Do you know if the JDK is installed by default when UDB 6.1 is installed,
or is it a separate install ?
I used lslpp to check the software installed, and it listed Java Support,
but not the JDK. Just skimming through the install cd's doesnt reveal any
for JDK.
Thanks for your input.
Pierre




Leo Pedron <[login to unmask email]> on 01/04/2000 10:51:12 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Pierre Evans/STS/AUTOZONE)
Subject: Re: Stored Procedure Builder on UDB 6.1




Try setting the (KEEPDARI) parameter in the DBM CFG to NO and set the
(JAVA11_PATH) parm to \SQLLIB\JAVA\JDK. Refer to the Application Building
Guide and Application Development Guide for sample stored procedure source
code that you can use to test the SPB. You can find them online
http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report#UDBPUB
S

These examples helped us to find our mistakes. My experience with the SPB
is only with JDBC apps.

Leo Pedron
Boscov's Dept Stores

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Tuesday, January 04, 2000 10:31 AM
To: [login to unmask email]
Subject: Stored Procedure Builder on UDB 6.1


Greetings all,
Has anyone used the new Stored Procedure Builder yet in UDB 6.1 ?
I've started to test it but haven't been able to successfully build a Java
SP (although it will generate). I keep getting a SQL4301, which indicates
"An error occurred while attempting to start or communicate with
a Java interpreter".

I get a reason code of 0 which does not match any in the explanation.
I suspect the issue to be the location of the "Java Development Kit 1.1
installation path" , as it wasn't
set initially in the DBM configuration . How can I determine the
appropriate location ?

The Control Center/Stored Procedure Builder is on a Windows NT client ,
with UDB EEE installed on a RS6000 SP.
Thanks in advance
Pierre



the