PI89334: DB2 ADMINISTRATION TOOL - SQLCODE683 SHOULD BE FOUND IN STEP WSLVAL6 IN CHANGE MANAGEMENT ANALYZE JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CHANGE MANAGEMENT (CM) RUN JOB returned error SQLCODE = -683.
  This error should had been found in STEP WSLVAL6 in CM
  ANALYZE JOB
  
  SQLCODEN683
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS. *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change does not validate    *
  *                      invalid combination of BUSINESS_TIME    *
  *                      columns' length. Identification of the  *
  *                      statement causing the error during the  *
  *                      merge phase of analyzing a change was   *
  *                      difficult.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In a merge phase of analyzing a change, there was no validation
  of an invalid column specification for a BUSINESS_TIME period
  column which ends with SQLCODE -683 / SQLCODEN683 at apply job
  as shown below:
  
  DSNT408I SQLCODE = -683, ERROR: THE SPECIFICATION FOR COLUMN,
  DISTINCT TYPE, FUNCTION, OR PROCEDURE column_name CONTAINS
  INCOMPATIBLE CLAUSES
  
  A new message ADB8069E will be displayed when the above case:
  ADB8069E The specification for a column column_name is invalid.
  Also an identification of the statement at the point of failure
  was difficult due to the lack of actual statement information
  in the job outputs.
  
  A new informational message, ADB8068I, will be displayed which
  helps users to identify the statement at the point of failure.
  ADB8068I Partial statement at the point of error:
           partial_stetement
  

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

•    ADBCCMM  ADBCDTS  ADBCVOC  ADB2RPT  ADB8000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.