PI94835: SQLCODE -206/SQLCODEN206 CM BATCH CHANGE RUN JOB BECAUSE VIEW DDL GENERATED WITH EXTRA QUALIFIER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CM Batch analyze job may generate view DDL with an invalid
  additional qualifier ('Z' in the example below, where 'X' is a
  valid correlation name), resulting in the following error when
  the change job is run:
  DSNT408I SQLCODE = -206, ERROR:  Z.X.column-name IS NOT
  VALID IN THE CONTEXT WHERE IT IS USED
  DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING
  ERROR
  DSNT416I SQLERRD = -225 0 0 -1 0 0 SQL DIAGNOSTIC
  INFORMATION DSNT416I SQLERRD = X'FFFFFF1F' X'00000000'
  X'00000000'
  X'FFFFFFFF'
  X'00000000' X'00000000'
  SQL DIAGNOSTIC
  INFORMATION
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and the DB2 Object Comparison       *
  *                 Tool for z/OS who use the change             *
  *                 management batch (CM Batch) interface        *
  *                 functionality to compare and run changes.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: A CM Batch change run job including     *
  *                      view DDL may result in error            *
  *                      SQLCODE -206 / SQLCODEN206              *
  *                      because the import/analyze process      *
  *                      generated an extraneous qualifier       *
  *                      in front of a column name.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When importing and analyzing view DDL containing
  a WHERE clause such as the following:
  
  WHERE X.COL1=Y.COL2 (where X and Y are correlation
  names)
  
  An extraneous qualifier ('Z' in the example below)
  may be generated in front of the first column name:
  
  WHERE Z.X.COL1=Y.COL2
  
  Since such a column does not exist, when the change run
  job is executed to create the view, a SQLCODE=-206 /
  SQLCODEN206 error may result:
  
  DSNT408I SQLCODE = -206, ERROR: Z.X.COL1 IS NOT
  VALID IN THE CONTEXT WHERE IT IS USED
  DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE
  

Problem conclusion

• The 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:

  UI55493 UI55494

Modules/Macros

•    ADB2CM3
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55493

     UP18/04/28 P F804

• RC10 PSY UI55494

     UP18/04/28 P F804

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.