PI25024: DB2 ADMIN COMPARE GENERATE COMPARE JOBS PANEL RETURNS DATA SET NOT USABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare Generate Compare Jobs panel returns Data Set not
  usable,  with details:
     The data set for input must be fixed, LRECL=80 or Variable,
  LRECL between 16000 and 16384. Organization must be PS or PO
  
  
  The Changes data set was defined as:
    PO
    FB
    80
    27920
    PDS
  

Local fix

• Define your CHANGES file like so:
     //CHANGES  DD DSN=CPCS.JESSEM1.CHANGES.JCLLIB,
     //            DISP=(NEW,CATLG,DELETE),
     //            DCB=(LRECL=16384,RECFM=VB,BLKSIZE=27998),
     //            SPACE=(TRK,(5,5),RLSE),
     //            UNIT=SYSDA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison           *
  *                 Tool for z/OS who specifies a CHANGE         *
  *                 dataset that is fixed length with an         *
  *                 LRECL of 80 for the 'Changes file            *
  *                 data set name' field on panel GOC5           *
  *                 'Generate Compare Jobs'.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a user specifies a CHANGE dataset  *
  *                      that is fixed length with an LRECL of   *
  *                      80 for the 'Changes file data set       *
  *                      name' field on panel GOC5 without       *
  *                      using Change Management, the Object     *
  *                      Compare job fails with return code      *
  *                      12 / RC=12 and error message            *
  *                      ADB7350E / msgadb7350e:                 *
  *                                                              *
  *                      ADB7350E Module : ADB2CMT detected      *
  *                      an ONCODE condition 22 in               *
  *                      WRITE_FILE_CHANGES at 18567             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user specifies a CHANGE dataset that is fixed length
  with an LRECL of 80 for the 'Changes file data set name' field
  on panel GOC5 without using Change Management, the Object
  Compare job fails with return code 12 / RC=12 and error
  message ADB7350E / msgadb7350e:
  
  ADB7350E Module : ADB2CMT detected an ONCODE condition
  22 in   WRITE_FILE_CHANGES at 18567
  

Problem conclusion

• Problem has been resolved.
  
  When a user specifies 'Change' for 'Generate apply jobs'
  to generate a DELTA change on panel GOC5 or specifies 'YES' for
  'Generate apply jobs' on panel GOC5 and use Change Management,
  the CHANGES data set must be either fixed length with LRECL=80
  or variable length with LRECL between 16000 and 16384.
  
  When a user specifies 'No' for 'Generate one job' on panel
  GOC5 or specifies 'Yes' for 'Generate one job' on panel
  GOC5 and does not use Change Management, the CHANGES
  file data set must be variable length with LRECL of 16384.
  
  If these conditions are not met, the new error message
  ADBC158E / msgadbc158e is issued:
  
  ADBC158E:
  Verification of the data set failed.
  
  For a DELTA change, the data set must be either fixed length
  with LRECL=80 or variable length with LRECL between 16000
  and 16384.  For a non-DELTA change, the CHANGES file data set
  must be variable length with LRECL of 16384.
  
  Explanation
  The data sets must be a certain record length type in order to
  pass verification.  For a DELTA change, the data set must be
  either fixed length with LRECL=80 or variable length with LRECL
  between 16000 and 16384. For a non-DELTA change, the CHANGES
  file data set must be variable length with LRECL of 16384.
  
  System action
  
  Processing stops.
  
  User response
  
  Specify data sets with valid record length types.
  

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:

  UI23465 UI23466

Modules/Macros

•    ADBC15   ADB2CPS  ADB2VERD
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI23465

     UP14/12/02 P F412

• RB10 PSY UI23466

     UP14/12/02 P F412

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.