PM32117: OBJECT COMPARE DROP/RECREATE TABLE USES " " AS TSNAME E.G. IN DBNAME." "

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using DB2 Object Comparison Tool for z/OS, and change
  is detected requiring a table to get dropped/recreated,
  *.DDL.CREATE file generates is erroneous missing tsname.
  .
  e.g. CREATE TABLE xxx.xxxxx
         IN dbname."        "
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare tables and ignore table     *
  *                 space names.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Object Comparison Tool,      *
  *                      when SYSTABLES.TSNAME is ignored, a     *
  *                      blank table space name is generated.    *
  *                      If executed, the user will receive a    *
  *                      SQLCODE -104/SQLCODEN104:               *
  *                                                              *
  *                      DSNT408I SQLCODE = -104, ERROR:         *
  *                      ILLEGAL SYMBOL "''". SOME               *
  *                      SYMBOLS THAT MIGHT                      *
  *                      BE LEGAL ARE: <IDENTIFIER>              *
  *                      DSNT411I SQLCAID    = SQLCAL            *
  *                      SQLCA IDENTIFIER                        *
  *                      DSNT418I SQLSTATE   = 42601             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      Also found:                             *
  *                      New triggers are not reported if the    *
  *                      report option "Only changed objects"    *
  *                      on panel GOC5RO 'Specify Compare        *
  *                      Reporting Options' has been chosen.     *
  *                      These triggers are correctly            *
  *                      reported in the "COMPARISON             *
  *                      SUMMARY REPORT", but missing from       *
  *                      the "OBJECT COMPARISON REPORT".         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When SYSTABLES.TSNAME is ignored, a blank table space name is
  generated.   If executed, the user will receive a SQLCODE -104/
  SQLCODEN104.
  
  Also found:
  New triggers are not reported if the report option "Only
  changed objects" on panel GOC5RO 'Specify Compare Reporting
  Options' has been chosen.  These triggers are correctly
  reported in the "COMPARISON SUMMARY REPORT", but missing
  from the "OBJECT COMPARISON REPORT".
  

Problem conclusion

• Code change will generate the correct tsname in the comparison
  report.
  

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

•    ADB2CMS  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66440

     UP11/04/08 P F104

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.