PH63985: DB2 13 FL506 SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 13 FL506 Support
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support Db2 13 function level           *
  *                      506.                                    *
  ****************************************************************
  This APAR provides enhancements and fixes to support
  the new Db2 13 function level 506.
  
  Db2 13 function level 506 introduced the capability to specify
  more than one row in the VALUES form of the INSERT statement.
  This new INSERT syntax is supported by Db2 Admin Tool.
  
  Additionally, starting in Db2 13 function level 506, you can add
  an implicitly hidden ROWID column to a table in a UTS table
  space. This enhancement added support of the ALTER TABLE ADD
  COLUMN statement with ROWID IMPLICITLY HIDDEN by using the AL or
  ALT command. Also, this ALTER operation is supported in Db2
  Object Comparison Tool. If an implicitly hidden ROWID column
  needs to be added to a target table, this change can now be done
  by using an ALTER statement rather than dropping and recreating
  the object.
  
  Db2 13 function level 506 introduced the NOKEYDELETE option for
  the LOAD utility to improve the elapsed time and availability
  when clearing data partitions.
  Db2 Admin Tool supports this new keyword on the
  Specify Utility Options - LOAD (ADB2UTC) panel. As an additional
  enhancement, when <DUMMY> is specified in the 'Unloaded data'
  field, Db2 Admin Tool prompts the user to unload the data as a
  backup and, if NOKEYDELETE is also specified to empty
  a partition, Db2 Admin Tool can optionally generate REORG INDEX
  utility statements to clear the resulting RBDPM status on the
  logical partitions of the NPSI.
  
  Also, as a part of the support for the LOAD generation for
  a partition, KEEP_EMPTY_PAGES and COPYDICTIONARY options were
  added on the ADB2UTC panel.
  
  Keywords:  DB2V13R1M506T/K
  

Problem conclusion

Temporary fix

Comments

• The enhancements have been delivered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI98978

Modules/Macros

• ADB21TAB ADB26CTU ADB26CUU ADB27C   ADB27CMR ADB27DUP ADB2CMF
  ADB2CMR  ADB2CMT  ADB2PA   ADB2U    ADB2UT   ADB2UTC  ADB2UTCI
  ADB2UTCO ADB2UTLX ADB2UTUL ADB2UTZ  ADB2UX   ADB2UXN  ADBCCMM
  ADBCDTS  ADBEUTC  ADBHUTC  ADBHUXN  ADBVERS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI98978

     UP24/11/09 P F411  

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.