PK05106: ADMIN TOOL ALLOCATES PART LEVEL DATA SETS WHEN PARALLELISM NOT ACTIVE OR DISABLED AND USES WRONG SQLID IN A CREATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool uses multiple data sets for a parallel unload when
  utility parallelism is not used or is disabled and also uses
  the ownerid or qualifier in a SET CURRENT SQLID when the id has
  no authority to create.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who have   *
  *                 "ALTER using parallelism for unload",  may   *
  *                 be affected.                                 *
  *                 .* Note: fixing parts of this APAR are in    *
  *                 PK07878. Both  APARs  will be in the same    *
  *                 PTF.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool uses multiple   *
  *                      data sets for a parallel  unload when   *
  *                      utility parallelism is not used or is   *
  *                      disabled. It also uses the ownerid or   *
  *                      qualifier in a SET CURRENT SQLID when   *
  *                      the id has no authority to create.      *
  *                      .*                                      *
  *                      Messages  issued  for   datasets  and   *
  *                      templates  used  for  non-partitioned   *
  *                      tables are misleading.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Messages, in ADB27AC ALC  process  for dynamically deleted and
  allocated datasets for parallel processing, have been modified.
  

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

•    ADB21TAB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK07267

     UP05/09/17 P F509

• R710 PSY UK07268

     UP05/09/17 P F509

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.