IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kishpra

New User


Joined: 24 May 2010
Posts: 92
Location: Pune

PostPosted: Sat Feb 18, 2017 2:31 am
Reply with quote

Hello Team,

My Java application is trying to call a Native SQL stored procedure AA400400 which is using a DB2 table.

When calling that stored procedure, we are getting the below error in Java application logs:

10:49:31,261 INFO [stdout] (http-/10.1.109.2:8443-1) DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=PROCEDURE;AA400400 DRIVER=4.14.113

My application connection URL in standalone file:
<connection-url> jdbc:db2://TZZSST.zpc.us.com:1330/TZZDB2T:currentSchema=TZZ1;resultSetHoldability=2;
</connection-url>

Application call to stored procedure
Call AA400400(NULL,NULL);

It does not points to correct schema TZZ1 and we can see the stored proc running in different schema i.e. SYSPROC.

We updated the connection URL as:
<connection-url> jdbc:db2://TZZSST.zpc.us.com:1330/TZZDB2T:currentSchema=TZZ1;currentFunctionPath="SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","TZZ1";resultSetHoldability=2;
</connection-url>

But it still runs under SYSPROC.

Then we changed the connection URL as below:
<connection-url> jdbc:db2://TZZSST.zpc.us.com:1330/TZZDB2T:currentSchema=TZZ1;currentFunctionPath="TZZ1","SYSFUN","SYSPROC","SYSIBMADM","SYSIBM";resultSetHoldability=2;
</connection-url>

But still getting -440.

Please advise.

Thanks.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2573
Location: NYC,USA

PostPosted: Sun Feb 19, 2017 7:46 am
Reply with quote

Did you contact DBA at your site first? Did you try executing this sp outside java environment pointing to desired schema?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Error 0C1 Reason Code 1 with branch i... PL/I & Assembler 3
No new posts Getting error while xped JCL & VSAM 10
No new posts can someone please help me in finding... IBM Tools 9
No new posts SYNCSORT Error - CONTROL FIELD BEYOND... SYNCSORT 10
Search our Forums:

Back to Top