PI64711: ABEND S322 CAN OCCUR WHEN CREATING A VIEW ON AN XMLTABLE 16/12/09 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND S322 can occur for a CREATE VIEW on an XMLTABLE.
  (d183709)
  ABENDS322
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of CREATE VIEW     *
  *                 that references built-in function XMLTABLE   *
  *                 and have PE UI37474 (APAR PI22614) installed *
  ****************************************************************
  * PROBLEM DESCRIPTION: After PE PTF UI37474 (APAR PI22614) is  *
  *                      installed, CREATE VIEW may receive      *
  *                      ABEND S322 if the view definition meets *
  *                      the following conditions:               *
  *                                                              *
  *                        1. does not reference any base tables *
  *                           or views                           *
  *                                                              *
  *                        2. reference the built-in function    *
  *                           XMLTABLE and this XMLTABLE is the  *
  *                           first table in the definition      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  After PE PTF UI37474 (APAR PI22614) is installed, CREATE VIEW
  may receive ABEND S322 if the view definition meets the
  following conditions:
  
    1. does not reference any base tables or views
  
    2. reference the built-in function (BIF) XMLTABLE and this
       XMLTABLE is the first table in the definition
  
  The view creation that meets the above conditions may not
  execute to completion, and the job may loop and hang.
  
  The following illustrates such a view:
  
    CREATE VIEW V1 AS
      SELECT T.*
        FROM XMLTABLE('$x/a/b'
             PASSING XMLPARSE(DOCUMENT
             '<a><b>9<c>1</c></b><b>8<c>1</c><d>2</d></b></a>'
             ) AS "x"
          COLUMNS
            C1 VARCHAR(3) PATH 'name(.)',
            C2 VARCHAR(3) PATH 'text()' DEFAULT '0') AS T;
  
  PTF UI37474 (APAR PI22614) contained several corrections
  that addressed the un-initialized pointers. One of the
  corrections caused the loop and hang in the create view that
  is described above.
  
  Prior to PTF UI37474, the view owner row in SYSIBM.SYSTABAUTH
  had an invalid string in the SCREATOR column and XMLTABLE in
  the STNAME column.
  
  With PTF UI37474, the insertion to SYSIBM.SYSTABAUTH for the
  view owner caused the loop and resulted in ABEND S322.
  

Problem conclusion

• DB2 has been modified to create the view successfully, where
  the view definition meets the following conditions:
  
    1. does not reference any base tables or views
  
    2. reference the built-in function (BIF) XMLTABLE and this
       XMLTABLE is the first table in the definition
  
  With the PI64711 fix, the view owner row in SYSIBM.SYSTABAUTH
  has SYSIBM in the SCREATOR column and XMLTABLE in the STNAME
  column.
  
  According to the SQL Reference, the schema for XMLTABLE is
  SYSIBM but the function name cannot be specified as a qualified
  name. This rule remains unchanged.
  
  Additional Keywords: SQLCREATEVIEW SQLXMLTABLE LOOP DB2HANG
                       ABENDS322
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI43646

Modules/Macros

• DSNXOACL DSNXOADT DSNXOEXC DSNXOFD  DSNXOGD
  DSNXOOS2 DSNXOPDS DSNXOP0  DSNXOQ2  DSNXOTDA DSNXOTL  DSNXOVC
  DSNXOVD  DSNXOVM  DSNXOV1  DSNXOXRW DSNXOYNS DSNXQMCH
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI43646

     UP17/01/18 P F701 «

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.