PI84979: CM OR COMPARE JOB USING TEMPLATE ENDS ADB0006E ADBCCM - ERROR(S)FOUND. PLEASE REVIEW OUTPUT ADB2PA RETURNING RC=16

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Admin Tool parser currently rejects parentheses and equal
  signs in a TEMPLATE statement.  This accords with the syntax
  diagrams in DB2 documentation.   However, DB2 in fact tolerates
  parentheses and equal signs, and the Administration Tool/Object
  Compare parser should do so as well.
  
  Example: Both below syntax is tolerated by DB2, even though
  syntax diagram does not mention paren or equal.
  TEMPLATE FIC
  DSN('&SS.&LR.&PB..&DB..&LR.&PB.&IC..&SN..P&PA.(+1)')
  MODELDCB SD.MODEL GDGLIMIT(255) VOLCNT(100)
  DISP(NEW,CATLG,CATLG) UNIT(CST)
  
  OR
  
  TEMPLATE FIC
  DSN('&SS.&LR.&PB..&DB..&LR.&PB.&IC..&SN..P&PA.(+1)')
  MODELDCB SD.MODEL GDGLIMIT 255 VOLCNT 100 DISP(NEW,CATLG,CATLG)
  UNIT=CST
  

Local fix

• Do not use parentheses or equal signs in templates
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A CM Batch or Compare job may           *
  *                      end with RC=16 due to incorrect         *
  *                      parsing of a TEMPLATE.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A CM Batch or Compare job which uses a TEMPLATE
  including parentheses or equal signs, supported in
  DB2 V12, may end with the following error messages:
  
   ADB0006E ADBCCM - ERROR(S) FOUND. PLEASE
   REVIEW OUTPUT
   ADB2PA RETURNING RC=16
  
  The following are examples of the TEMPLATE options
  that may cause this error:
  
   GDGLIMIT(255) (GDGLIMIT 255, as per syntax diagram)
   VOLCNT(100) (VOLCNT 100, as per syntax diagram)
   UNIT(CST) or UNIT=CST (UNIT CST, as per syntax diagram)
  

Problem conclusion

• Problem is resolved. The above-mentioned TEMPLATE options are
  supported, and job output indicates a parser error more clearly
  when appropriate.
  

Temporary fix

Comments

• ×**** PE17/12/01 PTF IN ERROR. SEE APAR PI90970  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI52183 UI52184

Modules/Macros

•    ADBCCM   ADB2PA   ADB2PA6
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52183

     UP17/11/29 P F711

• RC10 PSY UI52184

     UP17/11/30 P F711

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.