PM70375: MESSAGE 'ADBC002E - SEVERE ERROR. COMPARE TERMINATES' RC12 AND NO ADDITIONAL INFORMATION AS TO THE CAUSE OF THE ERROR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS's compare job issues a
  message 'ADBC002E - Severe error. Compare terminates' and ends
  with a return code 12 / RC12 without providing any guidance as
  to the cause of the error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare SQL PL functions,       *
  *                 including non-inline SQL scalar functions    *
  *                 and SQL table functions.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for z/OS *
  *                      compare job issues a message:           *
  *                                                              *
  *                      'ADBC002E - Severe error.               *
  *                      Compare terminates'                     *
  *                                                              *
  *                      and ends with a return code 12 / RC12   *
  *                      without providing any guidance as to    *
  *                      the cause of the error.                 *
  *                                                              *
  *                      Problem occurs because the              *
  *                      compared objects include non-inline     *
  *                      SQL scalar functions which are not      *
  *                      currently supported.  Compare is        *
  *                      supposed to issue the following         *
  *                      error message in the comparison         *
  *                      report, however, when the option        *
  *                      'Only changed objects' on panel         *
  *                      GOC5RO 'Specify Compare Reporting       *
  *                      Options' is set to 'YES', the error     *
  *                      message gets suppressed in the          *
  *                      compare report:                         *
  *                                                              *
  *                      ADB8003E - SQL PL User defined          *
  *                      functions not yet supported by          *
  *                      Object Compare. Run will terminate      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS compare job issues a
  message:
  
  'ADBC002E - Severe error. Compare terminates'
  
  and ends with a return code 12 / RC12 without providing any
  guidance as to the cause of the error.
  
  Problem occurs because the compared objects include non-inline
  SQL scalar functions which are not currently supported.
  Compare is supposed to issue the following error message
  in the comparison report, however, when the option 'Only
  changed objects' on panel GOC5RO 'Specify Compare Reporting
  Options' is set to 'YES', the error message gets suppressed
  in the compare report:
  
  ADB8003E - SQL PL User defined functions not yet supported by
  Object Compare. Run will terminate
  

Problem conclusion

• Problem has been resolved. With this APAR fix, when the
  reporting option 'Only changed objects' is set to 'YES' or
  'NO', Object Compare will issue the error message ADB7158E
  in the compare report when it detects an unsupported non-inline
  SQL scalar function or SQL table function.
  
  ADB7158E:
  >text1< >text2< from >text3< is a >text4< which is not
  yet supported by Object Compare.
  
  >text1<: Object type. Such as 'User defined function'.
  >text2<: Name of the object.
  >text3<: Source or target.
  >text4<: Detailed object type description which is not yet
  supported by DB2 Object Compare. Such as 'non-inline SQL
  Scalar function'.
  
  This APAR introduces a new option 'Bypass unsupported object'
  on panel GOC5 'Generate Compare Jobs'. The acceptable
  values for this option and the corresponding behavior
  are as following:
  
  No  - Compare will terminate processing when it detects
        there is an unsupported object either from source or
        target. This is the default value.
  Yes - Compare will bypass the unsupported object and
        continue processing for the other objects.
  
  When the NO option is used, Compare will issue
  error message ADB7158E and terminate with return
  code 12 / RC12. No APPLY jobs or WSL will be generated.
  
  ADB7158E: The user defined function >function_name<
  from >origin< is a >function_type<.
  
  Explanation
  
  This message is displayed when the compared objects
  include the non-inline SQL scalar function or the SQL table
  function, and the compare option 'Bypass SQL PL
  functions' (parameter BYPASSSQLPL) is not set to 'YES'.
  
  System action
  
  Processing stops.
  
  User response
  
  Remove the reported SQL PL function from the source or the
  target and try again. Alternatively, you can set the compare
  option 'Bypass SQL PL functions' to 'YES' and try again.
  
  When the YES option is selected, the non-inline SQL scalar
  function and the SQL table function are bypassed and not
  compared. In this case, the generated APPLY job or work
  statement list needs to be examined to verify that the content
  is complete.  Compare will issue following warning messages
  ADB7159W and ADB7160W in the report and end with return code
  6 / RC6.
  
  ADB7159W:The user defined function >function_name< from
  >origin< is a >function_type< and has been skipped because
  the parameter BYPASSSQLPL is specified.
  
  Explanation
  
  This message is displayed when the compared objects include
  the non-inline SQL scalar function or the SQL table function,
  and the compare option 'Bypass SQL PL functions' (parameter
  BYPASSSQLPL) is set to 'YES'.
  
  System action
  
  Processing continues.
  
  User response
  
  Examine the generated APPLY jobs or work statement list to
  verify that the content is complete. Alternatively, you can
  remove the reported SQL PL function from the source or the
  target and try again.
  
  ADB7160W: SQL PL functions have been bypassed because
  the parameter BYPASSSQLPL is specified. Please examine
  the APPLY jobs or work statement list to verify the
  content is complete.
  
  Explanation
  
  This message is displayed when the compared objects include
  non-inline SQL scalar function or SQL table function and
  compare parameter BYPASSSQLPL is specified (Compare option
  'Bypass SQL PL functions' is set to 'YES'). Refer to
  message ADB7159W for the bypassed functions.
  
  System action
  
  Processing continues.
  
  User response
  
  Examine the generated APPLY jobs or work statement list to
  verify the content is complete. Or remove the reported SQL PL
  functions from the source or the target and try again.
  
  This APAR does not add support for SQL PL User Defined
  Functions.
  

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

•    ADB2CMF  ADB2CMP  ADB2CMR  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK81655

     UP12/09/12 P F209

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.