PM51449: DOCUMENTATION UPDATE AND ++HOLD(DOC) NEEDED FOR NEW FUNCTION INTRODUCED IN APAR PM22869 FOR ADBCHANU TO UPDATE CM

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DOCUMENTATION UPDATE AND ++HOLD(DOC) NEEDED FOR NEW FUNCTION
  INTRODUCED IN APAR PM22869 FOR ADBCHANU TO UPDATE CM
  The manual says torun job ADBCHANG to use Change Managment.
  Change Management objects in V7.2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS Version 7.2 who are installing DB2      *
  *                 Administration Tool for z/OS Version 10.1.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Version 10 Release 1 User's Guide       *
  *                      and Reference says to run job           *
  *                      ADBCHANG to create the Change           *
  *                      Management database objects before      *
  *                      using the Admin Tool, but it does not   *
  *                      state how to deal with Change           *
  *                      Management database objects when        *
  *                      users of DB2 Administration Tool        *
  *                      for z/OS Version 7.2 are installing     *
  *                      DB2 Administration Tool for z/OS        *
  *                      Version 10.1.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Documentation is needed to clarify how to deal with Change
  Management database objects when users of the DB2 Administration
  Tool for z/OS Version 7.2 install DB2 Administration Tool for
  z/OS Version 10.1.
  

Problem conclusion

Temporary fix

Comments

• If you were previously using DB2 Administration Tool for z/OS
  Version 7.2 and you are installing DB2 Administration Tool for
  z/OS Version 10.1, you must run the following sample jobs in
  the sequence listed after you install DB2 Administration Tool
  for z/OS Version 10.1.  This updates the Change Management
  Database.
  
  1.Run ADBCHANU to add columns RAUTHSWID, RSECADMID,
  EAUTHSWID, ESECADMID, ENEWVER, ESCPSCH, ESCPNAM,
  EVERSCH, EVERNAM to ADBCHG.
  2.Run ADBCHG01 to add columns RIDGENA, TMSGENA to
  ADBCHG.
  3.Run ADBCHG02 to add column APPCONT to ADBCHG.
  4.Run ADBCHG03 to add column IDENTSVL to ADBCHG.
  
  If any of the job's return code are greater than or equal
  to 8, you can check out the job log. If you find a SQLCODEN612
  message:
  
  DSNT408I SQLCODE = -612, ERROR:  <column_name> IS
  A DUPLICATE NAME
  
  in the job log, please ignore it, as it indicated that your
  ADBCHG table already has the column.
  

APAR Information

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

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

  UK74595

Modules/Macros

•    ADBCHANG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK74595

     UP11/12/17 P F112

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.