PI05441: TOOLS CUSTOMIZER INSTALL PATH NOT PROVIDED FOR CUSTOMERS EFFECTE D BY APAR PM96499/ ADBMCMA IS MISSING GRAN 13/11/04 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' Tool Customizer install
  process does not provide a path for customers effected by APAR
  PM96499 (template ADBMCMA is missing GRANTEE column) and who
  have already added columns COLNAME, CONSTRAINTNAME, AUTHLEVEL
  to table ADBCVERSCOPES.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Column GRANTEE to table ADBCVERSCOPES   *
  *                      was missing from the DB2 Administration *
  *                      Tool for z/OS UPGRADE Change Management *
  *                      database job template ADBMCMA since the *
  *                      release of DB2 Administration Tool      *
  *                      Version 10, Release 2.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Column GRANTEE for table ADBCVERSCOPES was missing from the DB2
  Administration Tool for z/OS UPGRADE Change Management database
  job template ADBMCMA since the release of DB2 Administration
  Tool Version 10, Release 2.
  

Problem conclusion

• Problem has been resolved.
  
  Instructions on how to resolve missing column GRANTEE from table
  ADBCVERSCOPES:
  
  1.  Ensure PTF UK98550 or later PTF has been applied.  This step
  is important as it has an update to TCz UPGRADE job template
  ADBMCMA to ensure that column GRANTEE for table ADBCVERSCOPES is
  in the proper order.
  
  2.  Invoke TCz for DB2 Administration Tool, navigate to
  'Product Parameters' panel CCQPPRD and select the
  UPGRADE option.
  
  3.  END/F3 to navigate back to 'Customizer Workplace' panel
  CCQPWRK and use line command 'G' to regenerate the jobs.
  
  4.  On 'Finish Product Customization' panel CCQPCST, use line
  command 'E' to select the UPGRADE job template ADBMCMA
  (Upgrade CM database from Version 10, Release 1 to Version 10,
  Release 2).  Inspect the job and ensure the 6 ALTER TABLE
  ADBCVERSCOPES ADD...statements are present and in the order
  highlighted below.  If so, submit the job.
  
  ALTER TABLE ADBCVERSCOPES ADD GRANTEE VARCHAR(128) NOT NULL
   WITH DEFAULT;
  ALTER TABLE ADBCVERSCOPES ADD COLNAME VARCHAR(128);
  ALTER TABLE ADBCVERSCOPES ADD CONSTRAINTNAME VARCHAR(128);
  ALTER TABLE ADBCVERSCOPES ADD AUTHLEVEL VARCHAR(256);
  ALTER TABLE ADBCVERSCOPES ADD ESLTIME TIMESTAMP  NOT NULL
   WITH DEFAULT;
  ALTER TABLE ADBCVERSCOPES ADD VERSION VARCHAR(128) NOT NULL
   WITH DEFAULT;
  
  5.  END/F3 back to 'Finish Product Customization' panel
  CCQPCST, use line command 'E' to select the job template
  ADBBIND (BIND DB2 Administration Tool), and submit the
  job.
  
  Note:
  With PTF UK98550 or later PTF applied, Version 10, Release 2
  SADBSAMP(ADBCHG03) is obsolete and should not be submitted.
  If TCz UPGRADE job template ADBMCMA was submitted before PTF
  UK98550 was applied, then consider using DB2 Object Comparison
  Tool (if available) or the DB2 Administration Tool ALT option
  to correct the column order for table ADBCVERSCOPES.  Step #4
  above highlights the correct order for the Alter statements.
  

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:

  UI13007

Modules/Macros

•    ADBCHG03
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI13007

     UP13/11/30 P F311

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.