IBM Support

II14426: INFO APAR TO LINK TOGETHER ALL THE XML SUPPORT DELIVERY APARS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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



Document information

More support for: z/OS family

Software version: 001

Operating system(s): MVS

Reference #: II14426

Modified date: 02 July 2012


Translate this page: