PH42324: INSERT PARTITION FAILURE RELATED TO AUX, HISTORY AND ARCHIVE TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Insert partition failure related to AUX, history and archive
  tables.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS and Object Comparison Tool for z/OS     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes to resolve     *
  *                      the issues described in the summary     *
  *                      below.                                  *
  ****************************************************************
  This APAR provides fixes to resolve the following errors:
  
  1. An incorrect table space name is displayed on panel ADBPUI
  'Image Copy Utilities' after the UT line command was issued on
  panel ADB21I 'Information from SYSIBM.SYSCOPY' for the image
  copies that were selected by using the ICS line command on
  a database.
  2. The apply job generated by Object Compare might fail on
  REORG TABLESPACE with error DSNU204I because of the REBUILD-
  pending status on an index.
  3. Change Management analyze might fail with error ADB8062E
  when an index is changed to update the name of the table on
  which the index is defined and the old table is dropped.
  4. An ignore changes specification for the owner of the index
  does not take effect in the compare report.
  5. An apply work statement list (WSL) generated by Object
  Compare to insert partitions into the target table might fail
  with SQLCODE -665 when the 'Advisory Auto Reorg' option
  is set to YES.
  6. Error message ADB3349E has incorrect formatting.
  7. When a new WSL data set is created on panel ADB2W 'Manage
  Work Statement Lists', it might be in a locked state, and batch
  jobs that use it might fail while waiting for it.
  8. Inserting a new partition on panel ADB27CPV 'Alter
  Partitioned Table' might cause an error ONCODE=350 if the
  partitioning key has more than one column and part of the limit
  key value is omitted.
  9. Inserting more than 100 columns into a table using the INS
  line command on panel ADB21TIN 'Build SQL INSERT Prototype'
  might cause ISPF dialog error ISPP363.
  10. Options with protected fields for the REORG TABLESPACE
  utility on panel ADB2USO 'Specify Utility Options - REORG' have
  the same color as other input fields.
  11. Panel ADB26CTU 'ALTER Table' does not have a warning to
  indicate that 'Data Length' cannot be empty if
  'Column type' is CHAR.
  12. Running GEN on an SQL function might fail with error
  ONCODE=8094 if it was migrated from old Db2 version and
  has TEXT_ENVID=0.
  13. REORG TABLESPACE in an apply job might fail with error
  DSNU103I if the 'Prefix for data sets' parameter is 17
  characters long.
  14. Error ONCODE=520 might occur during compare when processing
  dependent objects on functions and procedures and the DEBUG
  option is set.
  15. Panel ADBPUSOC 'DSN String for SYSCOPY' is not scrollable.
  16. Importing DDL using table KEY LABEL mask TBKEYLABL might
  result in the table KEY LABEL value not being masked correctly
  in the registered change.
  17. A Change Management analyze operation might fail with error
  ADB8072E when processing partition changes for a table with
  LOB columns, an archive-enabled table or a system-period
  temporal table.
  Compare might generate DROP and CREATE for the table space,
  instead of ALTER, when applying partition changes for history or
  archive tables.
  18. A Compare apply job might fail with error SQLCODE -20385
  while altering a table column if the table space was altered and
  is in REORG-pending status.
  19. Altering a non-UTS table space by using the ALT function
  might unintentionally convert it to UTS if the APPLCOMPAT zparm
  value is V12R1M504 or higher.
  20. A Change Management recover operation might generate
  ADMIN START FOR TABLE with ACCESS(RW) and TRUNCATE for the
  archive-enabled table that was dropped, which might lead to
  error ADB5006E.
  A LOAD statement might be generated twice for an archive table,
  which might result in duplicate data in the table.
  
  Keywords: DSNU204I; msgADB8062E; SQLCODE665N; msgADB3349E;
  ONCODE350; ISPP363; ONCODE8094; DSNU103I; ONCODE520;
  msgADB8072E; SQLCODE20385N; msgADB5006E;
  

Problem conclusion

• The problems have been resolved.
  

Temporary fix

Comments

• ×**** PE21/12/16 FIX IN ERROR. SEE APAR PH42870  FOR DESCRIPTION
  

APAR Information

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

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

  UI78376

Modules/Macros

• ADB21D   ADB21I   ADB21SAR ADB21TIN ADB26CTU ADB27AP  ADB2CID
  ADB2CM2  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMT  ADB2MSQ
  ADB2REH  ADB2UCUU ADB2USO  ADB2WLVD ADB3000  ADBCCMM  ADBCVOC
  ADBGAJOB ADBPUI   ADBPUSOC ADBTEP2  ADBTEPR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI78376

     UP22/01/04 P F112

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.