PH04920: CM BATCH COMPARE SQLCODE -683 SQLCODEN683 BUSINESS_TIME ANALYZE INCOMPATIBLE CLAUSES COLUMN SPECIFICATION APPLY JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In a merge phase of analyzing a change, there was no validation
  of an invalid column specification for a BUSINESS_TIME period
  column.  The apply job may therefore end with a -683 SQL error
  code, as shown below:
  
  DSNT408I SQLCODE = -683, ERROR:  THE SPECIFICATION FOR COLUMN,
  DISTINCT TYPE,
   FUNCTION, OR PROCEDURE column_name CONTAINS INCOMPATIBLE
                 CLAUSES
  
  Instead of the above error, a new message ADB8069E will be
  displayed:
  
  ADB8069E The specification for a column column_name is invalid.
  
  A new informational message, ADB8068I, will also be displayed to
  help users to identify the statement at the point of failure.
  ADB8068I Partial statement at the point of error:
  
  
           [partial_statement]
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS who applied PTFs UI58928 or UI58929.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Due to an error in PTFs UI58928         *
  *                      and UI58929, the following fix          *
  *                      for PI89334 was not implemented.        *
  *                                                              *
  *                      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:                                              *
  ****************************************************************
  Due to an error in PTFs UI58928 and UI58929, the following fix
  for PI89334 was not implemented.
  
  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_statement
  

Problem conclusion

• The problems have been resolved.
  This is the fixer for PTFs UI58928 and UI58929.
  Please refer to those PTFs for additional closing
  text for APARs included with those deliveries.
  

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

•    ADB$$PRM ADBASP   ADBCCM   ADBCCMM  ADBCDTS
  ADBCMBIV ADBCUST  ADBCVOC  ADBDAT   ADBEALT  ADBEDIAG ADBEDSNU
  ADBEMTAR ADBE8T   ADBGAJOB ADBHAG   ADBHAL   ADBHAO   ADBHAQ
  ADBHAR   ADBHAS   ADBHPCO  ADBHZAK  ADBMAIN  ADBPZAK  ADBPZAK0
  ADBPZAT  ADBP1AR0 ADBR     ADBRIP9  ADBSALT  ADBSPCO  ADBTEP2
  ADBTIMC  ADBTTP   ADBXGTI  ADB2AUH  ADB2CME  ADB2CMF  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMT  ADB2CMU  ADB2CM3  ADB2CUST ADB2GC
  ADB2GG   ADB2GH   ADB2GK   ADB2GL   ADB2GP   ADB2GR   ADB2GZ
  ADB2MSK  ADB2PA   ADB2PA7  ADB2PCO  ADB2RE   ADB2REE  ADB2REG
  ADB2REH  ADB2REM  ADB2REZ  ADB2RPT  ADB2U    ADB2US   ADB2USO1
  ADB2W    ADB2WVL  ADB2W1   ADB2W10  ADB2ZBH  ADB2000  ADB21
  ADB21II1 ADB21KB  ADB21KR  ADB21KRT ADB21SAR ADB21SI1 ADB21TSE
  ADB21TSR ADB21XAR ADB21XAS ADB21XA0 ADB233   ADB25LD  ADB26CX
  ADB28HPL ADB28HPU ADB28M   ADB28MM  ADB28M2  ADB3000  ADB8000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI59717

     UP18/11/17 P F811 Ø

• RC10 PSY UI59718

     UP18/11/17 P F811 Ø

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.