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

Obtain the fix for this APAR.

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