PI98607: GOC - SUPPORT FOR GEN TO TOLERATE/SUPPORT DB2 FUNCTION LEVEL.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• GOC - SUPPORT FOR GEN TO TOLERATE/SUPPORT CURRENT DB2 FUNCTION L
  EVEL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: For DB2 Object Comparison Tool for      *
  *                      z/OS Version 12, Release 1 ONLY:        *
  *                                                              *
  *                      1- Continuous Delivery (CD) support for *
  *                      GEN.                                    *
  *                                                              *
  *                      2 - This service enhances the Change    *
  *                      Management batch interface and the      *
  *                      Object Compare output. Prior to         *
  *                      this enhancement, the jobs produced     *
  *                      a variety of output files with error    *
  *                      messages occurring in any of the files. *
  *                      When a problem occurs, it is difficult  *
  *                      to determine what the problem is.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
   For DB2 Object Comparison Tool for z/OS, Version 12, Release
   1 ONLY:
  
  1- A new Db2 function level check has been added to GEN so users
  are warned if GEN doesn't support or tolerate the current
  Db2 function level. In addition the following has been added:
  
  a- If a user has accepted using a function level that
  isn't supported or tolerated on the Admin prompt panel
  subsequent created GEN jobs will automatically include a
  new GEN option:
  ACCEPT_RISK_FOR_FL='nnn' , where 501<nnn<999
  This option will allow GEN to continue running on a
  function level even if GEN doesn't support or tolerate
  the current function level.
  b- GEN will issue a message if the current function level
  doesn't support/tolerate a particular function level.
  However, as a temporary solution GEN will allow
  users to run on function level 502 although GEN
  currently does not support KEYLABELs. It is expected
  that GEN will be changed to only support function
  level 501 until full support for function level is
  provided.
  c- On the GEN panels a new field has been added
  to allow GEN to generate DDL for a particular function
  level - just like it today allows the user to generate
  DDL for a particular Db2 version. This field is not yet
  being used by GEN.
  d- APPLCOMPAT, and CONCENTRATE STATEMENTS
  attributes will now be generated for functions and
  procedures when running on Db2 V12 FL 500 or above.
  
  2- In this enhancement, warning and error messages are
  duplicated to a common output file, in addition to being
  written to their existing output file. Also, new messages
  indicating the start and end of the CM batch phases will
  also be written to the common output file.
  

Problem conclusion

Temporary fix

Comments

• For DB2 Object Comparison Tool for z/os, Version 12, Release 1
  ONLY:
  
  New functionality has been added to GEN.
  Problem has been resolved.
  
  CM batch and Object Compare will support a new DD statement,
  ADBMSGS, and if this DD name is present it will duplicate all
  warning and error messages to this file. Those messages will
  continue to be written to their existing output file.
  
  In Object Compare, some messages that were previously unnumbered
  are now displayed with a message number, for example, this
  message is now a warning message:
  
   ADB7954W ADBCCMM Foreign key FATHERPK dropped because all the
    columns were deleted from the primary/unique key
    Various 'dropped' and 'deleted' situations will be displayed
    with ADB7954W.
  
   Also, "empty file messages" are now displayed with ADB79543I:
    ADB7953I ADB2CMF Target: No records in target file.
  

APAR Information

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

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

  UI56653

Modules/Macros

•    GOCDB2   GOC2DTC  H25GC10J
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI56653

     UP18/06/22 P F806

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.