PH25920: INCLUDE DB2 PENDING CHGS OPTION FOR MIG/GEN;TCz DISCOVER to use ISPF BROWSE IF VIEW FAILS;ADBSETUP REMOVE 20/07/16 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  
  1) The MIG/GEN panel ADBP8MG requires the following input field
  option:
  
  Include Db2 pending chgs . . . . . _____ (Yes,No,Alter)
  
  2) The TCz DISCOVER option cannot display a TCz DISCOVER Report
  if the ISPF VIEW service is disabled and will issue the
  following error message:
  
  Subroutine RC=12: SERVICE=ISPEXEC VIEW DATAID(ISR00212): THE
  VIEW FUNCTION HAS BEEN DISABLED VIA THE CONFIGURATION TABLE.
  
  If this error occurs, ISPF BROWSE will be used instead
  
  3) SET CURRENT SCHEMA is not honored due to hard coded qualifier
   "SYSIBM" on CREATE INDEX RESAUTHX in TCz generated job
  ADBSETUP.
  

Local fix

• Work around
  
  For issue
  
  1)  Edit the migration job, and within the
      GNSQL1 step, the pending changes flag can be set
      by changing the following within IN DD:
  
      PENDCHGS = 'N'  or 'Y'
  
  2) none
  3) ADBSETUP can be edited to change
     CREATE INDEX "SYSIBM"."RESAUTHX"
     to
     CREATE INDEX RESAUTHX
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS       *
  *                 (TCz).                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue 1:                                *
  *                      The migration (MIG) function has no     *
  *                      provision to enable and disable Db2     *
  *                      pending changes.                        *
  *                                                              *
  *                      Issue 2:                                *
  *                      The TCz DISCOVER option cannot display  *
  *                      the TCz DISCOVER report.                *
  *                                                              *
  *                      Issue 3:                                *
  *                      SET CURRENT SCHEMA is not honored       *
  *                      when creating index RESAUTHX from the   *
  *                      TCz generated job ADBSETUP.             *
  ****************************************************************
  Issue 1:
  When the GEN command is entered on MIG panel ADB28M
  'Migrate Parameters', panel ADBP8MG 'Generate SQL from Db2
  catalog' now has the following option to enable and disable
  Db2 pending changes:
  
  Include Db2 pending chgs . . . . . _____ (Yes,No,Alter)
  
  Issue 2:
  If the ISPF VIEW service is disabled, the TCz DISCOVER option
  cannot display the TCz DISCOVER report and issues the following
  error message:
  
  Subroutine RC=12: SERVICE=ISPEXEC VIEW DATAID(ISR00212): THE
  VIEW FUNCTION HAS BEEN DISABLED VIA THE CONFIGURATION TABLE.
  
  Issue 3:
  When the TCz Product Parameter "*Indexes" is enabled,
  SET CURRENT SCHEMA is not honored due to the hard-coded
  qualifier "SYSIBM" in CREATE INDEX RESAUTHX in the TCz generated
  job ADBSETUP.
  

Problem conclusion

• Issues have been resolved.
  

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:

  UI70493

Modules/Macros

• ADB28M   ADB2CUST ADBH8M   ADBH8MG  ADBP8MG  ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI70493

     UP20/07/14 P F007 {

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.