PH16874: VARIOUS FIXES ALTER TRIGGER PARSER FORMATTING ONCODE = 150 SQLCODE = -4743 ADB21TAU ADB21PL ADB25TS ADB21K COPYDDN

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR provides fixes for the
  following issues:
  
  1) The plan name is missing in the title
  of panel ADB21K 'Packages' when
  navigating to it from the panel ADB21P
  'Plans' or the panel ADB21PL 'Package
  List'.
  
  2) Formatter improvements for CREATE/
  ALTER TABLE/INDEX, long names and ADMIN
  ACCEL statements.
  
  3) A parser issue when importing ALTER
  TABLESPACE MEMBER CLUSTER NO with
  masking.
  
  4) ONCODE 150 when registering a change
  that involves long names and masking.
  
  5) DTC does not recognize a semi-colon
  in the embedded SQL in the trigger body,
  causing a parser error.
  
  6) The COPYDDN option is not generated
  for REORG and causes a 'A REQUIRED DD
  CARD OR TEMPLATE IS MISSING' failure.
  
  7) Renaming a database using ALT and
  CM=YES drops the child tables.
  
  8) ISPF dialog error when opening the
  up help panel for ADB25TS 'Template
  Disk Options'.
  
  9) Panel ADB21TAU 'Alter table -
  Utilities' hangs if no utility is
  selected and you want to go back
  after execution of the ALTER
  statement.
  
  10) The location name is missing in an
  object comparison job report for the
  target, during DDL - Catalog compare.
  
  11) Value 0 is not allowed for the insert
  algorithm when altering a table space.
  
  12) Altering a table using ALT, CM=NO and
  GEN override of the Db2 function level
  may result in SQLCODE -4743.
  
  
  KEYWORDS:  SQLCODEN4743 ONCODE150
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration and Object   *
  *                 Comparison Tool for z/OS.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides fixes for the        *
  *                      following issues:                       *
  *                                                              *
  *                      - The plan name is missing in the       *
  *                      title of panel ADB21K 'Packages' when   *
  *                      navigating to it from the panel ADB21P  *
  *                      'Plans' or the panel ADB21PL 'Package   *
  *                      List'.                                  *
  *                      - Formatter improvements for CREATE/    *
  *                      ALTER TABLE/INDEX, long names and ADMIN *
  *                      ACCEL statements.                       *
  *                      - A parser issue when importing ALTER   *
  *                      TABLESPACE MEMBER CLUSTER NO with       *
  *                      masking.                                *
  *                      - ONCODE 150 when registering a change  *
  *                      that involves long names and masking.   *
  *                      - DTC does not recognize a semi-colon   *
  *                      in the embedded SQL in the trigger      *
  *                      body, causing a parser error.           *
  *                      - The COPYDDN option is not generated   *
  *                      for REORG and causes a 'A REQUIRED DD   *
  *                      CARD OR TEMPLATE IS MISSING' failure.   *
  *                      - Renaming a database using ALT and     *
  *                      CM=YES drops the child tables.          *
  *                      - ISPF dialog error when opening the    *
  *                      up help panel for ADB25TS 'Template     *
  *                      Disk Options'.                          *
  *                      - Panel ADB21TAU 'Alter table -         *
  *                      Utilities' hangs if no utility is       *
  *                      selected and you want to go back        *
  *                      after execution of the ALTER            *
  *                      statement.                              *
  *                      - The location name is missing in an    *
  *                      object comparison job report for the    *
  *                      target, during DDL - Catalog compare.   *
  *                      - Value 0 is not allowed for the insert *
  *                      algorithm when altering a table space.  *
  *                      - Altering a table using ALT, CM=NO and *
  *                      GEN override of the Db2 function level  *
  *                      of 100 causes SQLCODE -4743.            *
  ****************************************************************
  This APAR provides fixes for the following issues:
  
  - The plan name is missing in the title of panel ADB21K
  'Packages' when navigating to it from the panel ADB21P 'Plans'
  or the panel ADB21PL 'Package List'.
  - Formatter improvements for CREATE/ALTER TABLE/INDEX, long
  names and ADMIN ACCEL statements.
  - A parser issue when importing ALTER TABLESPACE MEMBER CLUSTER
  NO with masking.
  - ONCODE 150 when registering a change involving long names and
  masking.
  - DTC does not recognize a semi-colon in the embedded SQL in the
  trigger body, causing a parser error.
  - The COPYDDN option is not generated for REORG and causes a
  'A REQUIRED DD CARD OR TEMPLATE IS MISSING' failure.
  - Renaming a database using ALT and CM=YES drops the child
  tables.
  - ISPF dialog error when opening the help panel for ADB25TS
  'Template Disk Options'.
  - Panel ADB21TAU 'Alter table - Utilities' hangs if no
  utility is selected and you want to go back after the execution
  of the ALTER statement.
  - The location name is missing in an object comparison job
  report for the target, during DDL - Catalog compare.
  - Value 0 is not allowed for the insert algorithm when altering
  a table space.
  - Altering a table using ALT, CM=NO and GEN override of the Db2
  function level of 100 causes SQLCODE -4743.
  

Problem conclusion

• Fixes are being delivered.
  

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:

  UI68168

Modules/Macros

• ADB21    ADB21K   ADB21KI1 ADB21L   ADB21P   ADB21PL  ADB21SA
  ADB21TAU ADB28MC  ADB28MM  ADB2C14  ADB2CID  ADB2CM1  ADB2CM2
  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS
  ADB2CMT  ADB2CMU  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2RE   ADB2REE
  ADB2REG  ADB2REH  ADB2REU  ADB2REZ  ADB2WCL  ADBCCM   ADBCDTS
  ADBCEXP  ADBCP    ADBCRCM  ADBCRSP  ADBCVOC  ADBGAJOB ADBH5TS
  ADBHM1S  ADBSALT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI68168

     UP20/03/10 P F003  

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.