Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DSNT408I SQLCODE = -443 with a -818 SQLERRD

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

New User


Joined: 01 Dec 2011
Posts: 3
Location: Brazil

PostPosted: Wed Oct 03, 2012 9:02 am    Post subject: DSNT408I SQLCODE = -443 with a -818 SQLERRD
Reply with quote

We have DB2 z/OS V8 running with DB2 XML Extender installed. Our production and dev environments work fine, however our test environment is receiving this error when the application submits a batch job or even submit a SQL statement thru SPUFI.

We have tried replacing the test libraries with the production libraries and did a rebind,but that did not resolve the issue.

Code:
DSNT408I SQLCODE = -443, ERROR: EXTERNAL FUNCTION EXTRACTCLOBS (SPECIFIC NAME
DXXEXTRACT2CLCL) HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT
DXXC004E Unable to operate the LOB Locat
DSNT418I SQLSTATE = 38X04 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRTN SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -818 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFCCE' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
DSNE610I NUMBER OF ROWS DISPLAYED IS 0


And now, we have no clue on how to fix that, any help will be great.

Code'd
Back to top
View user's profile Send private message

Chandu C

New User


Joined: 22 Jun 2012
Posts: 2
Location: INDIA

PostPosted: Wed Oct 03, 2012 11:30 am    Post subject: Reply to: DSNT408I SQLCODE = -443 with a -818 SQLERRD
Reply with quote

I have googled it, the following may be useful icon_smile.gif

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fn504.htm
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Oct 03, 2012 12:34 pm    Post subject: Reply to: DSNT408I SQLCODE = -443 with a -818 SQLERRD
Reply with quote

are You sure that You replied to the right post/topic ?
the link You posted talks about a -504

the current topic is about a -443

googling for SQLERRD=-818 EXTRACTCLOBS
returned a couple of links worth to meditate on
Back to top
View user's profile Send private message
pjbluesman

New User


Joined: 01 Dec 2011
Posts: 3
Location: Brazil

PostPosted: Wed Oct 03, 2012 6:13 pm    Post subject: Reply to: DSNT408I SQLCODE = -443 with a -818 SQLERRD
Reply with quote

It doesn´t seems to be related to the issue I got. The bind problem(-818) is a suspect since the message error does not show up the module which is be mismatched.
I´ve already performed the binds on XML packages and plans with no luck, has also used the production subsystem(this one is working fine XML features) DBRM library to rebind them and no luck either. All the subsystem (Prod, Develop, and Test) should be in the same level but something goes wrong on Develop subsystem that made XML stop to work properly. Would it be some problem with XML data or tables with bad data or configuration?
Back to top
View user's profile Send private message
pjbluesman

New User


Joined: 01 Dec 2011
Posts: 3
Location: Brazil

PostPosted: Wed Oct 03, 2012 10:43 pm    Post subject: Reply to: DSNT408I SQLCODE = -443 with a -818 SQLERRD
Reply with quote

I forgot to send the SQLSTATE = 38X04 (DXXC004E - The XML Extender was unable to operate the specified locator).
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 SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us