PK42202: ALC ALTER OF COLUMN AND DELETE AND RESTORE MEMBER NAMES ARE INCORRECTLY GENERATED WITH THE WRONG NAME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While in Admin doing a ALC on a table to alter a column the
  user inputs member names in panelid ADB27A as follows:
        Member name of single job : TTVIO05
        Member name of Delete job : DTTVIO05
  and in panelid ADB27AJ they enter:
        Data Set Name  ===> pm36607.restore
           Member Name  ===> rttvio05
  But Admin processing creates the wrong member names for Delete
  and Restore.
  ISREPO01 panel shows:
  
   Name     Prompt
  . DTTVIO01 - incorrect - should have been DTTVIO05
  . TTVIO05 - correct
  and
    RESTORE(RTTVIO00) - incorrect - should have been RTTVIO05
  

Local fix

• Please apply PTF when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Admin Tool attempting an alter  *
  *                 specifying  a Delete  and/or Restore member  *
  *                 names.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: If an  8-characeter  Delete  or Restore *
  *                      member name  is specified with "Combine *
  *                      job steps"  set to No, and "Add to work *
  *                      stmt list" set to Yes on the "DB2 Admin *
  *                      ALTER"  panel (ADB27A),  the right-most *
  *                      character of that name is overlaid with *
  *                      a sequence number.                      *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Since Delete and Restore members consist of JCL,they must not
  contain more steps than the maximum number of steps allowable
  in a single job. Consequently  provision must be made for the
  possibility that more than one  Delete or Restore job must be
  created, hence the need for a name modification algorithm.
  

Problem conclusion

• Although the modification of Delete and Restore member names is
  "working as designed", panels ADB27A and ADB27AJ are changed to
  allow a 5 character member name prefix to which is appended the
  three-digit sequence numbers,  instead of an 8 character member
  name.The respective help panels,ADBH7A and ADBH7AJ,are modified
  to explain this new behavior.
  

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:

Modules/Macros

•    ADBH7A   ADBH7AJ  ADB27A   ADB27AJ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK29297

     UP07/10/17 P F710

• R720 PSY UK29298

     UP07/10/17 P F710

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.