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

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

• GOC2CMS
  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK66435

     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.