PK10009: PANEL ADB2GEN DOES NOT GEN A GRANT ACCESS ON VIEW UNLESS THE CREATE VIEW OPTION IS SPECIFIED AS YES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool panel ADB2GEN does not GEN a GRANT
  ACCESS ON VIEW unless the CREATE VIEW option is YES.
  

Local fix

• Use interactive GRANT ACCESS function TA , or specify YES on
  CREATE VIEW option in panel ADB2GEN to obtain both the VIEW and
  associated GRANT ACCESS statements.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2 Administration Tool, who use  *
  *                 ADB2GEN to produce DDL for views and grants  *
  *                 on views, may be affected.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADB2GEN currently will not produce DDL  *
  *                      for a GRANT on a  VIEW  unless the DDL  *
  *                      for the VIEW itself is produced.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• The ADB2REE has been changed so that the  GRANT(s) can be
  produced even when the DDL for the associated view is not
  produced.
  

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

•    ADB2RE   ADB2REE  ADB2REP  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK07436

     UP05/09/27 P F509

• R710 PSY UK07437

     UP05/09/27 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.