UDB JDBC procedure call causes S04E in DB2

N61601

I'm trying to call a z/OS stored procedure from Win UDB and am getting
a SQLCODE: -444, SQLSTATE: 42724.
On the the z/OS system log, I see -
DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
LUWID=GA79647C.C009.01FA42152919=180
THREAD-INFO=PCTEST:MYPC:PCTEST:javaw.exe
RECEIVED ABEND=04E
FOR REASON=00D3003B
DSNL028I -PRDA GA79647C.C009.01FA42152919=180 103
ACCESSING DATA FOR
LOCATION 2.121.130.124
IPADDR 2.121.130.124

I haven't been able to find anything by searching IBM.

Does anyone have any idea what's causing this?

Thank you in advance,
Serenity

Mar 12 '08 #1

Subscribe Reply

7689

Serge Rielau

N6****@gmail.com wrote:

I'm trying to call a z/OS stored procedure from Win UDB and am getting
a SQLCODE: -444, SQLSTATE: 42724.
On the the z/OS system log, I see -
DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
LUWID=GA79647C.C009.01FA42152919=180
THREAD-INFO=PCTEST:MYPC:PCTEST:javaw.exe
RECEIVED ABEND=04E
FOR REASON=00D3003B

OK, Your Windows box is not guilty (for a change), that much is clear.
I'd try to find these hex numbers (or their numeric equivalents) in Java
land. Perhaps a NULL pointer exception, etc, etc...

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Mar 12 '08 #2

Colin Booth

N6****@gmail.com wrote:

I'm trying to call a z/OS stored procedure from Win UDB and am getting
a SQLCODE: -444, SQLSTATE: 42724.
On the the z/OS system log, I see -
DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
LUWID=GA79647C.C009.01FA42152919=180
THREAD-INFO=PCTEST:MYPC:PCTEST:javaw.exe
RECEIVED ABEND=04E
FOR REASON=00D3003B
DSNL028I -PRDA GA79647C.C009.01FA42152919=180 103
ACCESSING DATA FOR
LOCATION 2.121.130.124
IPADDR 2.121.130.124

I haven't been able to find anything by searching IBM.

Does anyone have any idea what's causing this?

Thank you in advance,
Serenity

I have not got all the z/os manuals but i think that this may be idle thread
timeout. Is your connection idle for significant periods of time?

Colin

Mar 12 '08 #3

Knut Stolze

Colin Booth wrote:

N6****@gmail.com wrote:

>I'm trying to call a z/OS stored procedure from Win UDB and am getting
a SQLCODE: -444, SQLSTATE: 42724.
On the the z/OS system log, I see -
DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
LUWID=GA79647C.C009.01FA42152919=180
THREAD-INFO=PCTEST:MYPC:PCTEST:javaw.exe
RECEIVED ABEND=04E
FOR REASON=00D3003B
DSNL028I -PRDA GA79647C.C009.01FA42152919=180 103
ACCESSING DATA FOR
LOCATION 2.121.130.124
IPADDR 2.121.130.124

I haven't been able to find anything by searching IBM.

Does anyone have any idea what's causing this?

Thank you in advance,
Serenity

I have not got all the z/os manuals but i think that this may be idle
thread timeout. Is your connection idle for significant periods of time?

The reason code is available at Lookat, and it is indeed a timeout:

http://publibz.boulder.ibm.com/cgi-b...CJ12/SPTD3003B

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Mar 12 '08 #4

Similar topics

10630

JDBC: calling a stored procedure with multiple return values.

by: randy.p.ho | last post by:

Using JDBC, is there a way to call a stored procedure with multiple return values? Thanks.

Microsoft SQL Server

6165

JDBC function call: PS vs CS

by: John Sidney-Woollett | last post by:

Is it possible to call a Postgres stored function (as if it were a procedure), using a PreparedStatement which will receive no return value, instead of having to use a CallableStatement and ignore...

PostgreSQL Database

3758

RUNSTATS and JDBC

by: Gerald Khin | last post by:

Calling a RUNSTATS statement through JDBC fails due to a syntax error. I guess that this is because RUNSTATS is no SQL. JNI is not an option for me. I wonder if there is some package or stored...

DB2 Database

1833

Cryptic JDBC exception

by: Tom Davies | last post by:

Can anyone tell me how to find out what causes this error -- the message is not very revealing! I'm using DB2 8.1 fixpak 5 on Windows XP, using the Sun JDK 1.4.2. Thanks, Tom ...

DB2 Database

9196

problem using java packages in jdbc stored procedures

by: Kent Lewandowski | last post by:

hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...

DB2 Database

1443

Problem batching stored procedure calls using JDBC

by: usenet | last post by:

Hi. I have a DB2 stored procedure that I call using JDBC. Now I'm trying to batch the call. This is done by the book: stmt = connection.prepareCall(" ... "); stmt.setString(1, "foo");...

DB2 Database

8434

Java / JDBC DB2 export

by: info | last post by:

Hi, how could I do an export of tables via Java / JDBC. There are very big tables. I thought about: EXPORT TO c:\aa.ixf OF ixf SELECT * FROM TEST1 How could I call this from JDBC / Java? ...

DB2 Database

3506

inline SQL PL over JDBC

by: Kenevel | last post by:

Hi there, Is it possible to use inline SQL PL over JDBC? If so, which statement type is required and what syntax does the inline SQL PL take? A CallableStatement, for example, need to be...

DB2 Database

4173

IBM DB2 JDBC Driver CallableStatement update count

by: Otto Carl Marte | last post by:

Hi, When using a CallableStatement with the IBM DB2 Universal JDBC Driver the executeUpdate and getUpdateCount() methods on CallableStatement always return -1. According to the JDBC...

DB2 Database

7134

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7180

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7229

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6905

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

3108

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3103

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1429

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

667

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

311

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General