PK94470: GEN AND MIG OMIT SET CURRENT SQLID FOLLOWING GRANT WHEN GENERATE CATALOG STATS IS YES AND RUNSQLID IS USED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool the GEN and MIG functions produce DDL
  that uses correct SET CURRENT SQLID for CREATE TABLE. However,
  if that statement is followed by a SET CURRENT SQLID to issue a
  GRANT, the original SET CURRENT SQLID is not re-set for
  subsequent CREATE statements, when running with RUN SQLID and
  when GENERATE CATALOG STATS is YES.
  

Local fix

• Set GENERATE CATALOG STATS to NO
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool who         *
  *                 generate catalog statistics and specify      *
  *                 an override value for the "Run SQLID"        *
  *                 field on panel ADB2GEN.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DDL produced was such that an       *
  *                      object would not be created using the   *
  *                      override value for the "Run SQLID"      *
  *                      field on panel ADB2GEN.                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The following conditions are required for the problem to
  occur:
  - DDL and catalog statistics requested from GEN
  - Run SQLID override specified
  - Either a or b:
   a) Grantee override specified and the value is different
      from Run SQLID
   b) Grantee override not specified and the authorization
      needed for the grant is different from Run SQLID
  - GRANT statements requested and there are GRANT statements
    that will be generated
  - A CREATE statement must follow a GRANT statement
    (e.g. CREATE INDEX in CREATE TABLE ... ;
                          GRANT SELECT ON TABLE ....;
                          CREATE INDEX  ....;  )
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB2RES
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK50262

     UP09/09/26 P F909

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.