View previous topic :: View next topic
|
Author |
Message |
pjbluesman
New User
Joined: 01 Dec 2011 Posts: 3 Location: Brazil
|
|
|
|
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 |
|
|
Chandu C
New User
Joined: 22 Jun 2012 Posts: 2 Location: INDIA
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
pjbluesman
New User
Joined: 01 Dec 2011 Posts: 3 Location: Brazil
|
|
|
|
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 |
|
|
pjbluesman
New User
Joined: 01 Dec 2011 Posts: 3 Location: Brazil
|
|
|
|
I forgot to send the SQLSTATE = 38X04 (DXXC004E - The XML Extender was unable to operate the specified locator). |
|
Back to top |
|
|
|