PM48045: DB2 10 IN COMPATABILITY MODE / CM SQLCODEN199 GRANT PUBLIC AT ALL LOCATIONS GEN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function created
  GRANT syntax with PUBLIC AT ALL LOCATIONS when running under
  DB2 10 in Compatability Mode.
  The GRANT statements fail with:
  DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD AT.
  TOKEN WITH <END-OF-STATEMENT> , WAS EXPECTED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN (Generate) function to  *
  *                 generate DDL statements for a TABLE or VIEW  *
  *                 from the catalog, with the 'GRANT access on  *
  *                 TABLE or VIEW' on panel ADB2GEN 'Generate    *
  *                 SQL from DB2 catalog' option specified to    *
  *                 either 'Y', 'A' or 'R' in DB2 10 Conversion  *
  *                 Mode.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      GEN function created the GRANT syntax   *
  *                      with 'PUBLIC AT ALL LOCATIONS' when     *
  *                      running under DB2 10 Conversion Mode.   *
  *                      While running the generated             *
  *                      statements, the GRANT fails with        *
  *                      SQLCODE=-199/SQLCODEN199:               *
  *                                                              *
  *                      DSNT408I SQLCODE = -199,                *
  *                      ERROR:  ILLEGAL USE OF KEYWORD AT.      *
  *                      TOKEN WITH <END-OF-STATEMENT> , WAS     *
  *                      EXPECTED                                *
  *                                                              *
  *                      The problem happens when running on a   *
  *                      DB2 10 Conversion Mode subsystem that   *
  *                      has been migrated from a previous DB2   *
  *                      release. The 'PUBLIC AT ALL LOCATIONS'  *
  *                      clause is no longer allowed in the      *
  *                      GRANT statement on DB2 10 Conversion    *
  *                      Mode. However, in catalog table         *
  *                      SYSTABAUTH, GRANTEE 'PUBLIC*' which     *
  *                      stands for 'PUBLIC AT ALL LOCATIONS'    *
  *                      is still stored in DB2 10 Conversion    *
  *                      Mode. The DB2 Administration Tool       *
  *                      for z/OS generates 'PUBLIC AT ALL       *
  *                      LOCATIONS' when 'PUBLIC*' is found,     *
  *                      which is incorrect.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS GEN function created the
  GRANT syntax with 'PUBLIC AT ALL LOCATIONS' when running under
  DB2 10 Conversion Mode.  While running the generated statements,
  the GRANT fails with SQLCODE-199/SQLCODEN199:
  
  DSNT408I SQLCODE = -199, ERROR:  ILLEGAL USE OF KEYWORD AT.
  TOKEN WITH <END-OF-STATEMENT> , WAS EXPECTED
  
  The problem happens when running on a DB2 10 Conversion Mode
  subsystem that has been migrated from a previous DB2 release.
  The 'PUBLIC AT ALL LOCATIONS' clause is no longer allowed in
  the GRANT statement on DB2 10 Conversion Mode.  However, in
  the catalog table SYSTABAUTH, GRANTEE 'PUBLIC*', which
  stands for 'PUBLIC AT ALL LOCATIONS' is still stored in DB2 10
  Conversion Mode. The DB2 Administration Tool for z/OS
  generates 'PUBLIC AT ALL LOCATIONS' when 'PUBLIC*' is found,
  which is incorrect.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK73727

Modules/Macros

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK73727

     UP11/11/12 P F111

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.