Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Stored procedure returning SQLSTATE=56072

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Anney

New User


Joined: 06 Jan 2007
Posts: 7
Location: Chennai

PostPosted: Fri Nov 16, 2007 3:53 pm    Post subject: Stored procedure returning SQLSTATE=56072
Reply with quote

Hi,

Am executing a DB2 Stored procedure from ASP. Getting this error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][CLI Driver][DB2] SQL30005N Execution failed because function not supported by the server: location "" product ID "" reason code "". SQLSTATE=56072

Can any one guide me how to resolve this?

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

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Nov 18, 2007 4:06 am    Post subject:
Reply with quote

Hello,

Do you have anything working from that win-based system to db2 or is this the first attempt?

With no more to go on, it sounds like there is a problem in the data source definition. Once you define the data source, are you able to successfully test the connection?

If you have not already done so, i'd suggest talking with the dba(s) and the network support people from both ends to track down the problem(s).
Back to top
View user's profile Send private message
Anney

New User


Joined: 06 Jan 2007
Posts: 7
Location: Chennai

PostPosted: Fri Nov 23, 2007 9:28 am    Post subject:
Reply with quote

Thanks Dick.

Seems like the stored procedure consumed more CPU service units than the ASUTIME value allows. DB2 might have cancelled the procedure.

ASUTIME was increased to resolve this.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 24, 2007 9:03 am    Post subject:
Reply with quote

You're welcome.

Thank you for posting your solution - it may help another person later icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us