PM75054: CREATE PROCEDURE FAILED WITH 0C4 AT DSNOGETD+383C BECAUSE DB2 FAILED TO SET CORRECT ACCESS LIST ENTRY TOKEN(ALET).

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Create Procedure failed with 0c4 at DSNOGETD+383C because db2
    failed to set correct Access List Entry Token(ALET) on Access
    Register 14.
     It was set to Home Address Space Mode(2), but it had to be set
    to Primary(0) or Secondary(1) address space mode.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and 10 for z/OS users who use      *
    *                 PREPARE statement in SQL/PL to access XML    *
    *                 data.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND0C4 at DSNIDM.DSNOGETD+37FE     *
    *                      will occur when running a SQL/PL stored *
    *                      procedure which contains a PREPARE      *
    *                      statement and the prepared SQL          *
    *                      statement accesses XML data.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND0C4 at DSNIDM.DSNOGETD+37FE will occur when running a
    SQL/PL stored procedure which contains a PREPARE statement and
    the prepared SQL statement accesses XML data.
    
    For example:
    
      Following command creates a table with one XML column.
    
        CREATE TABLE T1 (X1 XML);
    
      Following statement will create a SQL/PL stored procedure with
      a prepare statement and the SQL statement for the prepared
      statement is inserting data to XML column.
    
        CREATE PROCEDURE MYPROC()
        L1: BEGIN
          DECLARE MYSQL CHAR(128);
          DECLARE MYATT VARCHAR(100);
          DECLARE MYXML VARCHAR(100);
          SET MYSQL = 'INSERT INTO T1 VALUES(?)' ;
          SET MYATT = 'ATOMIC';
          SET MYXML = '<a>111</a>';
          PREPARE S1 ATTRIBUTES MYATT FROM MYSQL;
          EXECUTE S1 USING MYXML;
        END L1 @
    
    When the stored procedure is called, the ABEND0C4 at
    DSNIDM.DSNOGETD+37FE will occur.
    

Problem conclusion

  • DB2 code is modified, so the abend will not occur.
    
    Additional keywords: SQLXML SQLPL XMLALL
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM75054

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-15

  • Closed date

    2013-01-23

  • Last modified date

    2013-03-04

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK91144 UK91145

Modules/Macros

  •    DSNNAINP DSNXRIB9 DSNXRID9 DSNXRIHB DSNXRIHD
    DSNXRIHR DSNXRIHS DSNXRIS9
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91144

       UP13/02/08 P F302

  • R910 PSY UK91145

       UP13/02/08 P F302

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM75054

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation