PM57188: WHEN A TABLE HAS LOB/XML, IT WILL USE SYNTAX FROM ADMIN DEFAULT WHICH DO NOT HAVE DSNTYPE AND DIR FORMAT CAUSING SQLCODEN452

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a table has LOB/XML, it will use the
  syntax from ADMIN default which do not have DSNTYPE and
  DIR format causing -452 because of out of directory in the data
  sets.
  

Local fix

• Apply PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use 'ALT Alter Table Space' (ALT)   *
  *                 to rename a table space.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      ALT process will define a LOB/XML       *
  *                      template of allocating PDS data sets,   *
  *                      which will cause UNLOAD to fail with    *
  *                      SQLCODE=-452 / SQLCODEN452 caused by    *
  *                      out of directory in ALT process:        *
  *                                                              *
  *                      DSNU283I  @ DSNUULVA - LOB ERROR        *
  *                        SQLCODE = -452                        *
  *                        SQLERRM = >data_set<                  *
  *                        SQLSTATE= 428A1                       *
  *                        SQLERRP = DSNOLFRV                    *
  *                         ...                                  *
  *                                                              *
  *                      and error message ADB5184E /            *
  *                      msgadb5184e:                            *
  *                                                              *
  *                      DSNU012I  >time_stamp< DSNUGBAC -       *
  *                      UTILITY EXECUTION TERMINATED,           *
  *                      HIGHEST RETURN CODE=8                   *
  *                      ADBT015I Failure attempting to          *
  *                      execute                                 *
  *                      ADB2UTIL with parm                      *
  *                      SSID,C0000001,,                         *
  *                             8                                *
  *                      ADB5184E The run is ending due to an    *
  *                      error with a non-SQL command.           *
  *                      Additional messages may have been sent  *
  *                       to the DD SYSTSPRT...                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Admin should supply an interface to the customer to specify
  HFS as the default LOB/XML template
  

Problem conclusion

• Program has been changed to allow a user to specify HFS as the
  default LOB/XML template data sets.
  

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:

  UI16224 UI16225 UI16226

Modules/Macros

• ADBTUNL  ADB2UCUU ADB2UCU5 ADB2UCU6 ADB2UC13 ADB2USU  ADB2UTUL
  ADB28HPU ADB28UL1 ADB28UT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UI16226

     UP14/03/22 P F403

• RA20 PSY UI16224

     UP14/03/22 P F403

• RB10 PSY UI16225

     UP14/03/22 P F403

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.