PI27375: UNLOAD OF TABLE WITH XML USING DSNTYPE(PDS) ABENDS WITH -452

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unload of table with XML data using DSNTYPE(PDS) abends
  with -452
  .
  Additional Keywords: SQLCODEN452 msgDSNU283I rc8
  

Local fix

• use DSNTYPE(LIBRARY)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 utility users of UNLOAD and using File       *
  *                 Reference Variables (FRV)                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: UNLOAD of a table with an XML column    *
  *                      using an FRV issues message             *
  *                      MSGDSNU283I - XML ERROR                 *
  *                         SQLCODE = -452                       *
  *                         SQLERRM = data_set_name(member) 13   *
  *                         SQLSTATE = 428A1                     *
  *                      and ends with RC8                       *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  RUNSTATS was run on a newly created, empty table containing an
  XML column, followed by a LOAD without the STATISTICS keyword.
  An UNLOAD of the table, using an FRV for the XML column, issued:
  DSNU283I - XML ERROR
       SQLCODE  = -452
       SQLERRM  = data_set_name(member)  13
       SQLSTATE = 428A1
  and ended with RC8.
  
  An examination of the JES dataset for the DBM1 address space
  shows:
  MSGIEC217I - B14-10 specifying the partition data set (PDS) for
  the XML member(s).
  
  The TEMPLATE statement for the XML data specified DSNTYPE(PDS)
  and did not specify DIR for the number of directory blocks
  desired so UNLOAD attempted to calculate it.  Because RUNSTATS
  had been run on the empty table, the number of directory blocks
  needed was calculated to be 0.
  
  When the attempt was made to write the first XML member to the
  PDS, the above error occurred because of there being no
  directory blocks.  This in turn caused message DSNU283I - XML
  ERROR SQLCODE=-452 SQLSTATE=428A1 to be issued and the utility
  ended with RC8.
  
  This error can also occur with the table containing a LOB
  column.
  
  ADDITIONAL KEYWORDS: SQLCODE452 ICE217I ABENDB14 RC10
  

Problem conclusion

• UNLOAD FRV code has been changed to use a default value of 50
  directory blocks when a value of 0 has been calculated.
  
  
  It should be noted that this change is being made to help in the
  unloading of a table with LOB and/or XML columns and a minimal
  number of rows.  Valid statistics still need to be present so
  that an accurate number of directory blocks can be calculated.
  

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:

  UI24783 UI24784

Modules/Macros

•    DSNUULDB DSNUULPB
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI24783

     UP15/02/13 P F502

• RB10 PSY UI24784

     UP15/02/13 P F502

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.