PM29850: IBM INTERNAL FOR PM13454. FFA10 PM29858.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IBM INTERNAL FOR PM13454
  

Local fix

• APPLY PTF
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool or      *
  *                 DB2 Object Comparison Tool for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following miscellaneous issues:     *
  *                                                              *
  *                      - Incorrect syntax for the WLM          *
  *                      ENVIRONMENT clause on an ALTER          *
  *                      PROCEDURE statement.                    *
  *                      - Synonym for a table reported twice    *
  *                      in the DB2 Object Comparison Tool       *
  *                      summary report.                         *
  *                      - Clone table not dropped if there      *
  *                      are no other changes to the base        *
  *                      table.                                  *
  *                      - Incorrect SQLID or SCHEMA when        *
  *                      adding a Trigger.                       *
  *                      - Occasional ONCODE using DB2           *
  *                      Object Comparison Tool for z/OS         *
  *                      V10 when processing version files       *
  *                      created in V7.2.                        *
  *                      - Tablespace STOGROUP default           *
  *                      incorrect in the DDL reader.            *
  *                      - TIMESTAMP scale default for DB2       *
  *                      Administration Tool for z/OS V7.2       *
  *                      objects corrected when using V10.       *
  *                      - Invalid SET CURRENT RULES = 'STD'     *
  *                      for table with explicit LOB objects.    *
  *                      - Additional support for the 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
  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 TE_UDF
  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:

  UK64440

Modules/Macros

•    GOCGAJOB GOC2CMF  GOC2CMP  GOC2CMR  GOC2CMS
  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK64440

     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.