PM15370: GRANT ISSUED TT LEVEL BIG NUMBER OF TABLES RESULT. FFA10 PM24212 IN JCL GRANTS TO GRANTEE FOR A PORTION OF TABLES IN RESULTSET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, when a resultset for
  tables being queried is huge ( > 1000 )
  then GRANT is issued from the command line,
  grant table(s) is less than resultset
  and less than Max Chars in an SQL Stmt found by issuing
  PARMS command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS using the primary command           *
  *                 GRANT for a large number of objects          *
  *                 with PROMPT ON.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When executing the DB2                  *
  *                      Administration Tool primary             *
  *                      command GRANT, processing               *
  *                      for a large number of objects with      *
  *                      PROMPT ON may result in                 *
  *                      multiple blocks of GRANT                *
  *                      statements. This may occur for          *
  *                      DATABASES, Table Spaces,                *
  *                      Tables, Distinct Types, Functions,      *
  *                      Sequences or Stored Procedures.         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  During the processing of the primary command GRANT,
  a 32k buffer is used to construct an SQL GRANT
  statement. For a large number of objects and with
  PROMPT ON the user is presented with multiple batches
  of GRANT statements. This is confusing for the user.
  

Problem conclusion

• The DB2 Administration Tool primary command GRANT
  has been changed to use a 2 megabyte buffer. If the
  GRANT statement is larger than 2 megabytes, then it
  will be split into multiple GRANT statements.  When
  multiple GRANT statements are used with PROMPT ON,
  the CANCEL command will cancel the current block
  and all subsequent blocks of GRANT statements.
  

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:

  UK63572

Modules/Macros

•    ADBGRANT ADBMAIN  ADB2GD   ADB2GE   ADB2GF
  ADB2GGEN ADB2GO   ADB2GQ   ADB2GS   ADB2GT   ADB21D   ADB21E
  ADB21S   ADB21SGM ADB21T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK63572

     UP11/01/07 P F101

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.