PM10427: NFDB29 ADMIN SUPPORT FOR IMPLICIT LOB AND XML TABLESPACES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN Support for implicit LOB and XML tablespaces.
  Parser
  GEN
  Merge
  ALC
  RDEF
  RENDB
  ADBTEP2
  Interpret WSL
  No RUNSTATS & image copy for LOB and XML objects
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS who use the change                  *
  *                 functions on objects that have               *
  *                 been implicitly defined for LOB or           *
  *                 XML objects.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Changed atrributes are not              *
  *                      preserved. There are no utilities       *
  *                      generated for implicit objects.         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  DB2 Administration Tool did not preserve the
  changed attributes when an implicit object was
  dropped and recreated as part of a change
  to an object, and did not generate utilities for the
  implicit objects.
  
  Note:
  
  The MIG function will be updated with the
  same capabilities in a later PTF.
  
  This maintenance includes the ability to perform
  Image copy in ALC/RDEF/RENDB path. New default
  data sets are needed for use by utilities when
  operating against a clone table.  The default data sets
  have been added to SAMP ADB2UCU2.  This sample
  must be added to the existing ADB2UCUS member
  in the ISPF skeleton data set (ISPSLIB).  Installations
  may wish to modify the  provided default data set names
  provided in the sample. While running Image copy without
  modifying this member an error may occur:
  
  DSNUGUTC -  TEMPLATE SYSCOPY
              DSN '' UNIT SYSDA
  
  DSNUGTDS - INVALID QUALIFIER IN
             TEMPLATE SYSCOPY
  
  DSNUGBAC - UTILITY EXECUTION TERMINATED,
             HIGHEST RETURN CODE=8
  

Problem conclusion

• DB2 Administration Tool has been enhanced to
  preserve the attributes of implicit objects when they
  are recreated, and utilities will now be generated.
  

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:

Modules/Macros

•    ADBBIND  ADBCCMM  ADBCDTS  ADBCRCM  ADBETEP
  ADBHGEN  ADBH1SAR ADBH7A   ADBH8M   ADBTEPI  ADBTEP2  ADB1000
  ADB2GEN  ADB2GENS ADB2MSK  ADB2PA   ADB2PA3  ADB2PA6  ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2RER  ADB2RES
  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2U    ADB2UCU2 ADB2USC
  ADB2USCO ADB2USK  ADB2USO  ADB2USOP ADB2USR  ADB2USU  ADB2UUOP
  ADB2WCM  ADB2WIN  ADB2WVL  ADB2W1I  ADB2ZP   ADB21DAJ ADB21S
  ADB21SA  ADB21SAJ ADB21SAR ADB21XA  ADB21XAV ADB25LD  ADB25TL1
  ADB27    ADB27A   ADB27AC  ADB27ACM ADB27AD  ADB27DC1 ADB27TUL
  ADB33    ADB5000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK57306

     UP10/06/03 P F006

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.