PH10086: CANNOT GENERATE GRANT UNLOAD TABLE PRIVILEGE PANEL ADB2GT DB2 V12

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR will allow users to generate a GRANT UNLOAD statement
  (new in Db2 v12) for tables on panel ADB2GT ("SSID Grant Table
  Privileges").  Currently this privilege does not appear as an
  option on this panel.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      support new DB2 v12 features and other  *
  *                      fixes as follows:                       *
  *                                                              *
  *                      - UNLOAD table privilege                *
  *                      - Piece-wise deletion of data           *
  *                      - SQL pagination support                *
  *                      - Reduce contention                     *
  *                      - Support utility statements > 32K      *
  *                      - Support running Db2 Utilities         *
  *                        in-line in the CM Batch job           *
  *                      - Online REORG enhancements             *
  ****************************************************************
  This APAR provides enhancements and fixes to support new DB2
  v12 features and customer requirements.
  
  Changes made are as follows:
  1) The UNLOAD privilege on tables is supported as follows:
  
     - Any UNLOAD privileges are displayed on panel ADB2AT
       "Table Authorizations".
     - You can grant the UNLOAD privilege by using panel ADB2GT
       "Grant Table Privileges".
     - You can revoke the UNLOAD privilege by using panel ADB2RT
       "Revoke Table Privileges".
     - You can see the impact of revoking the UNLOAD privilege for
       a table, including the impact on the privileges of other
       users (also known as cascade revokes).
     - If you call the GEN command for a table on which the UNLOAD
       privilege has been granted, the generated SQL includes the
       GRANT UNLOAD statement.
  
  2) Piece-wise deletion of data is supported as follows:
  
     Panel ADB21TDE "Build SQL DELETE Prototype" has a new FETCH
     command that adds the FETCH FIRST n ROWS ONLY clause to a
     DELETE statement. This clause, which is new in Db2 12,
     limits the number of rows that are deleted in a single SQL
     statement.
  
  3) SQL pagination is supported as follows:
  
     The OFFSET, FOR FETCH ONLY, FETCH FIRST/NEXT and LIMIT
     clauses are supported by the parser and formatter.
  
  4) Reduce contention is supported as follows:
  
     TCz jobs are updated to create change management table space
     ADBSCHG with row-level locking isolation level (LOCKSIZE
     ROW).  Also, COMMIT is added after updating a change, to
     avoid Admin execution program ADBTEP2 holding a lock on the
     page with the change.
  
  5) Support utility statements > 32K is supported as follows:
  
     The use of the deprecated procedure SYSPROC.DSNUTILS is
     replaced with DSNUTILV (DSNUTILU if not on Db2 12 FL500).
     When using DSNUTILV Admin will support utility statements
     up to 2MB.
  
  6) Support running Db2 Utilities in-line in the CM Batch job is
     supported as follows:
  
     Added new CM batch parameter 'use_dsnutil_sp', to control
     where Db2 utilities runs.
        Values: YES: run utilties using SYSPROC.DSNUTILx
                 NO: run utilities in the CM Batch job
        Default: YES
  
  7) Online REORG enhancements is supported as follows:
  
     - You can specify the new DROP_PART option for REORG
       TABLESPACE, either on panel ADB2USO 'Specify Utility
       Options - REORG' or by using the CM batch parameter
       util_reorg_drop_part.
         Values: YES: DROP_PART YES is added.
                  NO: DROP_PART NO is added.
               blank: DROP_PART option is not added. The Db2
                      default for this utility option is used.
         Default: blank
     - The new catalog column COMPRESSRATIO is added to
       panel ADB21S 'Table Spaces' and panel ADB21SI1
       'Interpretation of an Object in SYSTABLESPACE'.
  
  8) The APPLCOMPAT bind option value V12R1M505 is supported:
     You can specify V12R1M505 in the APPLCOMPAT field on the
     following panels:
  
     - ADB21KB "Bind Package"
     - ADB21KR "Rebind Package"
     - ADB21KRT "Rebind Trigger Package"
  

Problem conclusion

Temporary fix

Comments

• Enhancements are being delivered.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI65544

Modules/Macros

• ADB$$PRM ADB20    ADB2000  ADB21KB  ADB21KR  ADB21KRT ADB21S
  ADB21TDE ADB221E  ADB25LU  ADB27AC  ADB28MC  ADB2AT   ADB2ATI1
  ADB2CDC  ADB2CID  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP
  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2FMT  ADB2GT   ADB2IGN
  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6
  ADB2PA7  ADB2RALL ADB2RE   ADB2REC  ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2RT
  ADB2UOPS ADB2US   ADB2USO  ADB2USOP ADB2WCL  ADB2WIN  ADB2WVL
  ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCHST  ADBCRCR
  ADBCSPG  ADBCSRV  ADBDAT   ADBDK    ADBEALT  ADBH1TDE ADBHAT
  ADBHUSO  ADBLI    ADBNSPB  ADBPA    ADBPA1   ADBRIP9  ADBSETUP
  ADBTEP2  ADBTEPI  ADBTEPR  ADBTEPU  ADBV99   ADBVFC   ADBVFCA
  ADBVFCF
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI65544

     UP19/10/01 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.