PK38499: ALC PRODUCES MULTIPLE JOBCARDS WHEN USING OPTION 2 USE GENERATED BATCH JOBS ON PANEL ADB27CTC 'ALTER TABLE'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool ALC command produces JCL with
  multiple jobcards when open 2 "use generated batch jobs (For
  Utility options)" is selected on panel ADB27CTC "Alter Table"
  and 'Combine job steps' NO is selected on panel ADB27A
  "DB2 Admin ALTER".
  

Local fix

• Delete additional jobcard
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin Tool attempting an Alter *
  *                 Table to add a comment to a column,selecting *
  *                 option "2 - use generated batch jobs (For    *
  *                 Utility options) " on panel ADB27CTC  "Alter *
  *                 Table" and then selecting "Combine job steps *
  *                 . .  :NO" on panel ADB27A "DB2 Admin ALTER". *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ADB27A exec causes the multiple     *
  *                      job cards to be generated under the     *
  *                      circumstances described above.          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  (1) After an FTINCL of the job  card skeleton, ADB2UJOB, exec
      ADB27A  does an FTINCL of  the options skeleton, ADB27OPT
      without setting variable adbonejb to "Y",causing ADB27OPT
      to imbed ADB2UJOB again; and
  (2) In subroutine  Smart_step_only  an FTINCL ADB2UJOB  is done,
      followed  by a call of   ftstep with  the ftstep incljob the
      parameter set to "Y" causing yet another FTINCL of ADB2UJOB.
  

Problem conclusion

• (1)Variable adbonejb is set to "Y" before doing FTINCL ADB27OPT;
  (2)In subroutine  Smart_step_only if adbonejb is "N",  ftstep is
     called with  ftstep incljob  parameter set to "N", preventing
     yet another FTINCL of ADB2UJOB.
  

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:

  UK29297 UK29298

Modules/Macros

•    ADB27A
  

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.