PH69806: PART LVL LOAD UTILITY OF A TABLE WITH AN XML COLUMN GETS DSNU1135I EVEN IF THE XML TABLESPACE IS ALREADY IN EXTENDED RBA FORMAT

APAR status

• Closed as program error.

Error description

• PART LEVEL LOAD UTILITY OF A TABLE WITH AN XML COLUMN GETS
  MSGDSNU1135I EVEN IF THE XML TABLESPACE IS ALREADY IN EXTENDED
  RBA FORMAT
  
  DSNU1135I
  
  EXTENDED FORMAT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users of the LOAD INTO   *
  *                 TABLE PART REPLACE of a table with XML       *
  *                 columns.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNU1135I and RC4 issued for a LOAD  *
  *                      PART REPLACE utility on a table space   *
  *                      with a table including an XML column.   *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A LOAD PART REPLACE utility on a partitioned table space in
  the 10-byte extended RBA / LRSN format with a table
  including an XML column in an XML table space also
  in the 10-byte extended RBA/LRSN format, issues the
  following message causing the LOAD to end with a RC4.
  DSNU1135I - EXTENDED PAGE FORMAT CONVERSION ON XML TABLESPACE
  dbname.tsname IS IGNORED
  
  No UTILITY_OBJECT_CONVERSION keyword was specified on
  the LOAD statement so the conversion specified in the subsystem
  parameter UTILITY_OBJECT_CONVERSION=NOBASIC was used, which
  causes LOAD to default to the EXTENDED format. However, when
  issuing the DSNU1135I message, LOAD was not checking to see
  whether the XML object was already in the extended format.
  
  The same problem can occur for an object in EXTENDED format
  and the RBALRSN_CONVERSION EXTENDED keyword is specified on
  the LOAD statement.
  

Problem conclusion

• LOAD PART REPLACE utility code has been modified to check the
  RBA/LRSN format of the XML table space before issuing the
  warning message DSNU1135I.
  

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:

  UO07392

Modules/Macros

• DSNUGRSP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels