APAR status
INTRAN
Error description
Info for all the XML support delivery APARs: XML System Services (XMLSS). XMLSS requires either z/OS V1.8 or z/OS Version V1.7 with APAR OA16303. In addition, use of XML schemas requires 31-bit SDK for z/OS, Java 2 Technology Edition, Version 5 (5655-N98) (SDK5) IBM SDK for z/OS, Java 2 Technology Edition, Version 1.4 (SDK1.4.2) is required for Application Execution: Applications or stored procedures written in Java, such as those using the JDBC or SQLJ interfaces to DB2. PK42409 Optimizer XML Possible poor query performance due to I/O or CPU cost estimate being too high for XML index PK43315 Load/Unload XML Whitespace and CCSID corrections PK47594 XML Performance improvement for large documents LOAD PK48453 XML Logical partition reset of XML NPIs changed to use dynamic prefetch PK50575 XML Add zAAP information in SMF101 accounting PK51571 XML XTABLE, XCAST PK51572 XML XTABLE, XCAST PK51573 XMLTABLE, XMLCAST PK52885 lock / cursor hold PK55585 XPath function, phase 1 PK55783: XML VALUE INDEX NOT USED WHEN JOINING XML TALBES PK55831 XPath function, phase 2 PK55966 The PTF is UK33456. Remove page lock for XML TS for readers. PK56337 XPATH performance PK57409 XMLTABLE enhancement PK57786 XML query performance XMLAGG PK58914 XMLTABLE performance enhancement PK59770 XML locking PK60691 PGB growth concurrency problem (ship as PK72414 PK72415 PK72417 PK72419 PK72420) PK66218 XML insert performance PK66539: POOR PERFORMANCE FROM XPATH WITH PARENT AXIS PK67678: INCORRECT OUTPUT WITH XPATH AND XS:DECIMAL OPERATIONS PK68073: ABEND04E RC00E70005 IN DSNNXML .DSNNORES:M103 WITH DSN_XMLVALIDATE PK68265: DEADLOCKS ON XML TABLE SPACE PK75426: ABEND04E RC00E70005 AT DSNNOCCN:M414 WITH XMLTABLE PK75613: XML INDEXES MISSING SOME KEYS PK75771: REALTIME STATISTICS (TOTALROWS/TOTALENTRIES) FOR XML NOT FLUSHED BY LOAD PK78724: SYSFUN.DSN_XMLVALIDATE XML VALIDATION RETURNS SQLCODE0 INSTEAD ERROR SQLCODE FOR INVALID XML DOCUMENT ELEMENT PK80732: XPATH PERFORMANCE ENHANCEMENT AND XML INDEX SUPPORT FOR SOME XPATH FUNCTIONS PK80735: ENABLING APAR FOR XPATH PERFORMANCE ENHANCEMENT AND XML INDEX SUPPORT FOR SOME XPATH FUNCTIONS PK81260: ENABLING APAR FOR XML JOIN INDEX PK82031: ABEND0C4 RC04 IN DSNXRXML+0E9C ON MERGE WITH XML HOSTVAR PK82271: ABEND04E RC00E70005 IN DSNXOLCM:M050 ON QUERY WITH XML AND PARALLELISM PK82361: RESIDUAL XMLEXISTS EVALUATION AVOIDANCE PK85435: INCORRECT UPDATE OF XML COLUMN WITH NULL VALUES PK88034: POOR PERFORMANCE OF XMLAGG FUNCTION PK88631: ABEND04E IN DSNXGRDS.DSNXMLSM ON QUERY WITH XMLEXISTS PK90032: Preconditioning APAR to remove the 50M bytes limitation on XML schema validation. PK90040: ENABLING APAR for PK90032. PK92804: INCORRRECT OUTPUT CAN OCCUR FOR NOT XMLEXISTS WHEN AN XML INDEX IS PICKED INCORRECTLY PK92908: INCORRECT FILTER FACTOR FOR XMLEXISTS WHEN VALUE INDEX IS SMALL AND FAILURE TO USE XML INDEX ON A VOLATILE TABLE PK94678: ABEND 04E@DSNNXML.DSNNOGET:M720 WHEN SELECT XML COLUMN BY USING DECLARE INSENSITIVE SCROLL CURSOR PK95474: INCORRECT XML DOCUMENT TAG GENERATED BY XMLELEMENT FUNCTION PK96558: MULITPLE INDEX ACCESS PATH ISSUE FOR QUERY WITH XMLEXISTS PK98387: SQLCODE113 WRONGLY ISSUED DURING XML-SCHEMA VALIDATION PM10455: ABEND0C4 RC00000004 IN DSNIBNRF OFFSET 1C6C / 1C68 / 1CB4 / 1CB0 AND DB2 DOWN DURING XML VALIDATE PM02362: function XML_VALIDATE_BLOB abends with a S0C4 in external routine DSNNVVBN PM02655: ABND=04E-00E70005,LOC=DSNNXML.DSNNOGET:M720 DURING XML PROCESSING PM02613: XMLSERIALIZE TO SERIALIZE THE XML TO A CLOB GETS A -904 PM05533: NULL DOCID ON DATAPAGE WHEN UPDATING SHORT ROW IN BRF FORMAT. PM05664: POOR PERFORMANCE OF XML QUREY DUE TO DB2 DOESN'T PUSHDOWN JOIN PREDICATE INTO XMLTABLE PM07882: RECEIVES SQLCODE20345 WHEN INSERTING XML DOC PM08749: PREDICATE CONTAINING MISMATCHED DATATYPES AND SUCY PREDICATE ALSO INVOLVES A COLUMN FROM XMLTABLE(FUNCTION) PM09319: QST DOES NOT HANDLE THE XML COLUMN IN MQB CORRECTLY PM10228: 0C4 RC38 IN DSNXODFX+396E CAN OCCUR WHEN THE QUERY CONTAins AN XMLEXISTS PREDICATE PM12492: ABEND04E RC00E70005 DSNXEFDA:M500 ON A TABLE WITH XML COLUMN DUE TO RECORD NOT FOUND CONDITION WHEN UPDATING AN XML COLUMN PM11267: ABEND04E RC00C90101 DSNIOST2:5024 ON A XML COLUMN WITH DPSI ACCESS PM11482: APPLY THE NEW SCAN ALGORITHM FOR THE XMLTABLE FUNCTION PM11557: ABEND0C4 RC10 DSNXOCMX +782 OCCURS WHEN REBINDING A PACKAGE THAT CONTAINS AN XMLEXISTS PREDICATE PM16546 ABEND0C4 AT DSNNXML.DSNNOGET PM18839: ABEND04E RC00C90101 DSNIBMIR:5001 OCCURS FOR AN XML TABLE BECAUSE OF AN EMPTY RID PM19247: SQLCODE -20339 WITH USER DEFINED FUNTION ROUTE FOR DSN_XMLVALIDATE PM19614: D0C4 RC0000003B DSNXOFC OFFSET 03F0 WHEN CREATE VIEW WITHOUT JOINS PM20923: Resource unavailable Reason 00C900BA RC00C900BA TYPE 00002006 when running INSERT into PART x and LOAD REPLACE PART y on partition by range (PBR) or classic partitioned table spaces. PM22166: ABEND04E 00E20006 DSNSVSVB+08A8 DURING ABEND033E PROCESSING DUE TO AN ATTEMPT TO FREE AN ALREADY FREE BLOCK IN XML V-POOL PM23584: ABEND04E RC00E70005 DSNXGXTT : M110 WHEN USING XMLFOREST WITH ELEMENT-CONTENT-EXPRESSION PM25036: D04E RC00E70005 AT DSNXRXML:P018 WHEN ACCESSING XML DATA EXISTENCE ENVIRONMENT PM54050: ABEND0C4 RC4 IN DSNX5XPD AT OFFSET0782 BECAUSE OF INVALID FUNCTION CODE WHILE PROCESSING XMLTABLE IN SELECT STATEMENT These two are for z/OS operating system: XML parsing 100% zIIP redirection - available on V1.10, APAR OA23828 for z/OS V1.8, V1.9. XML parsing 100% zAAP redirection - available on z/OS V1.9, APAR OA20308 for z/OS V1.8, V1.7. Here is some important info for XSR setup ( Required Java version has been listed above ) : Need to bind JCC driver packages to SYSXSR collection ID (in addition to null collection ID). Run on z/OS USS: java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://<server_name>:<port_number>/<database_name> -user <userid> -password <password> -collection SYSXSR -action replace WLM setup for XSR stored procedures (pay attention to DB2A.SDSNLOD2): Sample WLM environment WLMENV3: //V91AWLM3 PROC DB2SSN=V91A,NUMTCB=18,APPLENV=WLMENV3 //TCBNUM18 EXEC PGM=DSNX9WLM,TIME=NOLIMIT, // PARM='&DB2SSN,&NUMTCB,&APPLENV', // REGION=0M //STEPLIB DD DSN=DB2A.SDSNLOD2,DISP=SHR // DD DSN=DB2A.SDSNLOAD,DISP=SHR // DD DSN=CEEA.SCEERUN,DISP=SHR //SYSTSPRT DD SYSOUT=* //CEEDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=* Sample WLM environment for WLMJAVA: //V91AWLJA PROC DB2SSN=V91A,NUMTCB=2,APPLENV=WLMJAVA //TCBNUM1 EXEC PGM=DSNX9WLM,TIME=NOLIMIT, // PARM='&DB2SSN,&NUMTCB,&APPLENV', // REGION=0M //STEPLIB DD DSN=DB2A.SDSNLOD2,DISP=SHR // DD DSN=DB2A.SDSNLOAD,DISP=SHR // DD DSN=CEEA.SCEERUN,DISP=SHR //JAVAENV DD DSN=WLMJAVA.JSPENV,DISP=SHR //JSPDEBUG DD SYSOUT=A //CEEDUMP DD SYSOUT=A //SYSPRINT DD SYSOUT=A Sample WLMJAVA.JSPENV: ENVAR("JAVA_HOME=/usr/lpp/java150/J5.0", "JVMPROPS=/tmp/jvmprops.txt", "JCC_HOME=/usr/lpp/db2/db2910_base", ?DB2_BASE=/usr/lpp/db2/db2910_base?), XPLINK(ON) ================================================================ A useful link for searching of DB2 APARs containing XML : http://www-01.ibm.com/support/search.wss?rs=64&r=100&cs=utf-8&ra nkfile=0&cc=&coll=0&spc=&stc=&apar=include&q1=XML&sort=desc&tc=S SEPEK&ibm-search.x=18&ibm-search.y=11&dc=DB550+D100&dtm
Local fix
N/A DB2 V9 apars : PM41092 : ABEND0C4 RC38 AT DSNNXML.DSNNQXCA OFFSET A1C8 PM44210 : PRECONDITIONING APAR FOR XML INSERT PAGE LATCH CONTENTION RELIEF IN DB2 9 FOR Z/OS PM22974 :ABEND04E RC00E70005 LOC=DSNNXML DSNNOGET : M720 BECAUSE OF 00C90001 FROM DSNISETO WHEN RETRIEVING XML RECORD PM17697 : IMPROVE PERFORMANCE FOR PARSING HEAVY TEXT XML DOCUMENTS PK90040 : Enabling APAR to remove the 50M bytes limitation on XML schema PM48742 INCORRECT RESULT WHEN XML INDEX WITH KEY TYPE OF SQL DECFLOAT IS USED FOR XMLEXISTS. DB2 V9/V10 apars : PM48518 : ABEND0C4 RC38 AT DSNXXAGG OFFSET 19C0 WITH XMLAGG FUNCTION PM37959 : WHEN SERIALIZING XML DATA, THE SPACE CHARACTER MIGHT NOT BE ADDED BETWEEN TWO ATOMIC VALUES PM27153 : HUGE STORAGE USED WHEN XMLSERIALIZE FUNCTION IS INPUT ARGUMENT OF LENGTH FUNCTION, MAY ISSUE SQLCODE904 RESOURCE 0000090A TOO PM43179 : SQLCODE -171 DURING BIND USING A FILE REFERENCE HOST VARIABLE OF XML DATA TYPE IN AN APPLICATION PREPARED BY THE DB2 COPROCESSOR PM34949 : Unexpected -440 on XMLSERIALIZE with XMLTABLE inside. PM50325 :INCORROUT MAY OCCUR WHEN USING A DECLFOAT XML INDEX, OR USING XMLEXISTS WITH XQUERY. PM49543 : XML STORAGE ENHANCEMENT PM45162 : ABEND0C4-00000038, DSNILREP+69AA DURING VIEW UPDATE PM44216 : XML INSERT PAGE LATCH CONTENTION RELIEF FOR DB2 9 FOR Z/OS PM43936 : DB2 ONLY ALLOCATED 15850 BYTES FOR THE XMLDATA COLUMN BUFFER PM41568 UN-DELETED RETRY PRRS IN DSNNOPAR CAUSING A LOOP PROBLEM PM33341 : ABEND04E RC00E20005 AND VARIOUS OTHER SYMPTOMS FROM STORAGE OVERLAY WHEN USING XMLELEMENT FUNCTION PM45561 : ROW NOT RETURNED AFTER AN INSERT AND COMMIT IN A BUSY DATA SHARING SYSTEM WHEN AN XML COLUMN EXISTS WITH ISO(UR) DB2 V10 apars : PM47618 : ENABLING APAR FOR EMBEDDED XQUERY SUPPORT PM47617 : PRECONDITIONING APAR FOR EMBEDDED XQUERY SUPPORT Also refer to apar PM61918 PM37641 : PROBLEM OCCURS WHEN RUNNING A V9 PACKAGE WITH NESTED XML FUNCTIONS ON V10. FUNCTIONS MIGHT BE SKIPPED PM40339 : ABEND04E RC00E70005 DSNXEFDA M500 BECAUSE DSNNQUER PM31806 : ABEND04E RC00E70005 at DSNNXML.DSNNAINP:M100 PM51173 : ABEND04E RC00E70005 OCCURS AT LOCATION DSNNOSCO:M404 AFTER MIGRATION TO V10 CM PM38413 : ENABLE PERFORMANCE ENHANCEMENT FOR COMPLEX XPATH PREDICATES. PM34453 : PERFORMANCE ENHANCEMENT FOR COMPLEX XPATH PREDICATES. PM45226 : ABEND04E DSNNXML DSNNOLCK M210 PM39239 : ABEND04E RC00E70005 DSNXGRDS.DSNXEFDA:M500 PM37363 : ABEND04E RC00C90101 DSNIDM.DSNIBHUN ERQUAL5006 PM37176 : TIMEOUTS ON TABLES WHEN DEFINED WITH XML DATATYPE FOR THE XMLRECORD PM34812 : ABEND04E RC00E70005 DSNNXML.DSNNOEXP:M720 PM28385 : MULTIPLE FIXES IN THIS APAR: ABEND04E DSNNXML.DSNNOGET:M770 PM27379 : ABEND0C1 RC00000001 FROM DSNTLPLK OFFSET0A3C WHILE ISSUING THE NOTIFY TO INVALIDATE THE XML GRAMMER IN THE CACHE IN COEX MODE PM33771 : THE APAR FIXES THE FOLLOWING ISSUES:04E-00E20009 AND 04E-00E70005 PM34137 : CHECK DATA INCORRECTLY REPORT CORRUPTED DATA FOR XML DOCUMENT WITH LONG TEXT VALUE PM38431 : ENTITY REFERENCES IN LONG ATTRIBUTE VALUE ARE NOT REPLACED BY THEIR VALUES IN BINARY XML STREAM PM46655 : SQLCODE -20465 INCORRECTLY ISSUED PM53282 : IMPROVE CPU PERFORMANCE OF XDBX VALIDATION PM61918 : COMMA IN XML PREDICATE IS INTERPRETED AS "AND"
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14426
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
001
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-19
Closed date
Last modified date
2012-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 July 2012