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.
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.
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?