PI94747: DB2 ADMIN TOOL - OBJECT COMPARE JOB ENDS WITH RC=8 IN STEP T03VAL, SQLCODE -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Adding a new column to a table when the table contains views on
  views and the views are changed as well to include the new
  column, the generated object compare job fails with RC=8 in
  step T03VAL and message:
  CREATE VIEW ...
  
   DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ".". SOME
            SYMBOLS THAT MIGHT BE LEGAL ARE: ARRAY + - ROW
            NEXTVAL PREVVAL NEXT PREVIOUS ( <INTEGER>
  
  SQLCODEN104
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who use Object Compare         *
  *                 to compare a view DDL with catalog           *
  *                 objects.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Submitting a WSL job generated by       *
  *                      the Object Compare Tool ends with       *
  *                      RC=8 in step T03VAL with                *
  *                      SQLCODE=-104 / SQLCODEN104.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When comparing View DDL to the DB2 catalog with option
  'RUN SQLID' specified, the generated WSL fails with error
  message:
  
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL
  ".". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: ARRAY
  + - ROW NEXTVAL PREVVAL NEXT PREVIOUS
  ( >INTEGER< )
  
  The generated view is incorrect as it is missing the correlation
  name. For example:
  
  CREATE VIEW viewname AS
   WITH AS(SELECT ..
                      FROM ..
                      WHERE..) T2
   GROUP BY , AS(SELECT .COL <== correlation name T2 is missing
          FROM ..
         WHERE..
         ..)
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADB2CM3  ADB2PA   ADB2PA7
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI56654

     UP18/06/22 P F806

• RC10 PSY UI56655

     UP18/06/22 P F806

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.