PM99085: WHEN THE TABLE HAS LOB/XML, IT WILL USE THE SYNTAX FROM ADM DEFA ULT WHICH DO NOT HAVE DSNTYPE AND DIR FORMAT CAUSING -452.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the table have LOB/XML, it will use the following syntax
  from ADM default which do not have DSNTYPE and DIR format
  causing SQLCODE=-452 error because out of directory in the data
  sets:
  DSNU283I  @ 031 21:44:14.09 DSNUULVA - LOB ERROR
  SQLCODE = -452
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS.                                        *
  ****************************************************************
  * 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 the 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:

  UI16231 UI16233

Modules/Macros

• GOC5
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RA10 PSY UI16233

     UP14/03/22 P F403

• RA20 PSY UI16231

     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.