PI66475: ENHANCE CM BATCH INTERFACE AND OBJECT COMPARE OUTPUT - IMPROVE MESSAGING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ENHANCE CM BATCH INTERFACE AND OBJECT COMPARE OUTPUT - IMPROVE
  MESSAGING.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the Change                  *
  *                 Management batch interface and               *
  *                 and Object Compare.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Prior to this enhancement, the          *
  *                      CM Batch and Object Compare             *
  *                      jobs produced a variety of              *
  *                      output files with error messages        *
  *                      appearing in any of the files making    *
  *                      it difficult to locate the problem      *
  *                      when a job fails.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  With 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

• CM batch and Object Compare will support a new DD statement,
  ADBMSGS. If this DD name is present. all warning and
  error messages are duplicated to this file.  In addition,
  the messages will continue to be written to the existing
  output file.
  
  Some examples of the DD statement:
  
  //ADBMSGS DD SYSOUT=*
  
  //ADBMSGS DD DISP=(MOD,CATLG),DSN=
  USER1.ADBMSGS.OUTPUT1,
  // SPACE=(CYL,(2,1)),
  // DCB=(LRECL=137,RECFM=VBA,DSORG=PS)
  
  The format of messages in the ADBMSGS data set are in a
  tabular format and include the message number, the
  name of the issuing function, and the message text.
  The message Id, function name, and message text are
  aligned vertically.
  
  The last character of the message number will indicate
  the severity of the message. There are three severity types:
  
  I - Informational messages describe information or status
  for normal conditions and operations.
  
  W - Warning messages alert users to a condition that might
  cause subsequent problems. When a warning message is
  issued, the process will continue.
  
  E - Error messages alert users to a problem that occurred.
  Process will terminate.
  
  Additional changes to existing messages:
  
  The suffix of message ADB7705 is changed
  from an I to a W:
  
  ADB7705W ADBCDTS does not support xxx statement.
  Processing continues.
  
  Some adhoc messages previously written with no message
  number are written to the ADBMSGS output file with
  following message numbers:
  
  ADB7953I >informational text<
  ADB7954W >warning text<
  ADB7955E >error text<
  
  New messages indicating the start and end of various
  CM batch phases will also be written to the ADBMSGS
  output file, for example:
  
  ADB7956I CM Batch: start of Compare phase.
  
  There are minor changes to some messages to improve
  alignment:
  
  ADB9901I Detailed change information
  ADB9945I Names of DB2 Admin data sets and PDS
  members associated with this change:<>
  
  ADB9946I Recover change:<>
  
  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.
  
  Messages indicating empty files are now displayed with
  ADB79543I, for example:
  
  ADB7953I ADB2CMF     Target: No records in target file.
  
  Enhancements delivered.
  

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:

  UI51740 UI51741

Modules/Macros

•    ADBAC2D  ADBALT   ADBASW   ADBCCM   ADBCCME
  ADBCCMM  ADBCDCH  ADBCDTS  ADBCDTW  ADBCIMV  ADBCMPDB ADBCMTP
  ADBCMTU  ADBCP    ADBCPRE  ADBCPRT  ADBCRCA  ADBCRCC  ADBCRCM
  ADBCRCP  ADBCRCR  ADBCRSP  ADBCSRV  ADBCUPC  ADBCVCT  ADBCVEY
  ADBCVIC  ADBCVIM  ADBCVOC  ADBCVSE  ADBDAT   ADBE7ALT ADBH1
  ADBLI    ADBLIOB  ADBMSG   ADBMSGP  ADBPMSG  ADBP7GV0 ADBRPTL
  ADBSR    ADBSRL   ADBTEPI  ADBTEP2  ADBTREL  ADBTTP   ADBVFC
  ADBVFCA  ADBVFCF  ADB0     ADB1000  ADB2CHK  ADB2CID  ADB2CME
  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU
  ADB2CM1  ADB2CM2  ADB2CM3  ADB2FMT  ADB2ISQ  ADB2LCC  ADB2MSK
  ADB2MSQ  ADB2PA   ADB2PRP  ADB2RE   ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY
  ADB2REZ  ADB2RPT  ADB2SQL  ADB2WCL  ADB2WIN  ADB2WVL  ADB2W1
  ADB2ZZ   ADB2ZZAP ADB2ZZMN ADB2ZZVA ADB2ZZVB ADB2ZZV9 ADB27AC
  ADB27C   ADB27CA  ADB27CAA ADB27CR  ADB27C0  ADB28MC  ADB7000
  ADB8000  ADB9000  H0IHB20J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI51740

     UP17/11/11 P F711

• RC10 PSY UI51741

     UP17/11/09 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.