PM29858: IBM INTERNAL FOR PM13454 PM23880 PM27179

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IBM INTERNAL FOR PM13454 PM23880 PM27179
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following miscellaneous issues:         *
  *                      - incorrect syntax for WLM ENVIRONMENT  *
  *                      clause on ALTER PROCEDURE statement.    *
  *                      - Synonym for a table reported twice    *
  *                      in the OC summary report.               *
  *                      - clone table not dropped if no other   *
  *                      changes to base table.                  *
  *                      - Incorrect SQLID or SCHEMA when adding *
  *                      Trigger.                                *
  *                      - Occasional ONCODE using V10 when      *
  *                      processing version files created by     *
  *                      V7.2.                                   *
  *                      - Tablespace STOGROUP default incorrect *
  *                      in DDL reader.                          *
  *                      - TIMESTAMP scale default for V7.2      *
  *                      objects corrected when using V10.       *
  *                      - Invalid SET CURRENT RULES = 'STD'     *
  *                      for table with explicit LOB objects.    *
  *                      - Additional support for Create         *
  *                      Function PARAMETER VARCHAR (NULTERM     *
  *                      | STRUCTURE) support.                   *
  *                      - the following protection exception    *
  *                      was received:                           *
  *                      ERROR condition was raised              *
  *                      Traceback of user routines:             *
  *                      Compile Unit Entry      Statement       *
  *                                   CREATE_UDF 3927            *
  *                                   ADB2REH    632             *
  *                      _snip_                                  *
  *                                                              *
  *                                   GOC2CMP    150             *
  *                      IBM0534S ONCODE=8094                    *
  *                      Protection exception                    *
  *                      From entry point CREATE_UDF             *
  *                      at statement 3927                       *
  ****************************************************************
  * RECOMMENDATION: Apply PTF.                                   *
  ****************************************************************
  Following miscellaneous issues:
  - incorrect syntax for WLM ENVIRONMENT clause on the
  ALTER PROCEDURE statement.
  - Synonym for a table reported twice in the OC summary
  report.
  - clone table not dropped if no other changes to base
  table.
  - Incorrect SQLID or SCHEMA when adding a Trigger.
  - Occasional ONCODE using V10 when processing version
  files created by V7.2.
  - Tablespace STOGROUP default incorrect in DDL reader.
  - TIMESTAMP scale default for V7.2 objects corrected when
  using V10.
  - Invalid SET CURRENT RULES = 'STD' for table with explicit
  LOB objects.
  - Additional support for Create Function PARAMETER VARCHAR
  (NULTERM | STRUCTURE) support.
  - the following protection exception was received:
  ERROR condition was raised
  Traceback of user routines:
  Compile Unit Entry      Statement
               CREATE_UDF 3927
               ADB2REH    632
  
  _snip_
               GOC2CMP    150
  IBM0534S ONCODE=8094
  Protection exception
  From entry point CREATE_UDF
  at statement 3927
  

Problem conclusion

• The code has been corrected.
  

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

•    ADBCCMM  ADBCDTS  ADBEUSV  ADBGAJOB ADBHMEX
  ADBH1SAR ADBH1VV  ADBH7A   ADBH7CT  ADBMAIN  ADBTCHK  ADBTEP2
  ADB2ALL0 ADB2CC   ADB2CJAB ADB2CJDB ADB2CMF  ADB2CMP  ADB2CMPR
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2MEX  ADB2MEXG ADB2M1S  ADB2REG
  ADB2REH  ADB2USV  ADB2UXV  ADB21    ADB21A   ADB21D   ADB21S
  ADB21SA  ADB21SP  ADB21T   ADB21TC  ADB21TPS ADB21VV  ADB21VV0
  ADB21X   ADB21XA  ADB21XP  ADB21XUR ADB25TL1 ADB27    ADB27A
  ADB27AC  ADB27AD  ADB28HPU ADB28T   ADB6000  H0IHA10J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.