PM43167: WRONG VIEW CREATOR WHEN USING IMPORT USING BATCH FOR PREREQ RESOLUTION MODE AND EXECUTION MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, when IMPORT of .CHG file
  is performed and options used are:
  Prereq resolution mode  . BATCH     (TSO/Batch)
  Execution mode  . . . . . BATCH     (TSO/Batch)
  .
  can result in prefill of owner/creator with current user ID.
  

Local fix

• use TSO until solution is available
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who import a change data set including  *
  *                 one or more unqualified views and specify a  *
  *                 mask for the change, specify BATCH or TSO    *
  *                 for option 'Prereq resolution mode' and      *
  *                 BATCH for option 'Execution mode' on panel   *
  *                 ADB2C14M 'CM Import changes - Select         *
  *                 process modes'.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS     *
  *                      when importing a change data set        *
  *                      including one or more unqualified       *
  *                      views, and using a mask for the change, *
  *                      if the BATCH options 'Prereq            *
  *                      resolution mode' and 'Execution mode'   *
  *                      on panel ADB2C14M are specified, the    *
  *                      wrong qualifier is generated for        *
  *                      unqualified views.  When using the      *
  *                      TSO option 'Prereq resolution mode'     *
  *                      and BATCH option 'Execution mode'       *
  *                      on panel ADB2C14M, DB2 Administration   *
  *                      Tool fails to register the change       *
  *                      due to an ONCODE670 / ONCODE=670.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS when importing a change
  data set including one or more unqualified views, and using
  a mask for the change, if the BATCH options 'Prereq resolution
  mode' and 'Execution mode' on panel ADB2C14M are specified, the
  wrong qualifier is generated for unqualified views. When using
  the TSO option 'Prereq resolution mode' and BATCH option
  'Execution mode' on panel ADB2C14M, DB2 Administration Tool
  fails to register the change due to an ONCODE670 / ONCODE=670.
  

Problem conclusion

• Problem has 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:

  UK74145 UK74146

Modules/Macros

•    ADB2CID  ADB2CIMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK74145

     UP11/11/29 P F111

• R720 PSY UK74146

     UP11/11/29 P F111

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.