FASTSWITCH YES database privilege requirements workaround (DBADM )

Products

• Rapid Reorg for DB2 for z/OS

Issue/Introduction

What is the DB2 Authorizations required to run Reorg with Fastswitch?

Environment

Release : 20.0

Resolution

Standard Authorizations:

RAPID REORG® FOR DB2 FOR Z/OS 20

REQUIRED AUTHORIZATIONS:

STARTDB, STOPDB, and DISPLAYDB on the database containing the objects to be reorganized 

• DBADM on the database containing the objects to be reorganized

DBCTRL on the database containing the objects to be reorganized

 

However the Minimum will work too:

The Minimum authorizations will work:

So the DBADM is not required. 

 

The Xmanager authorization ID must have all of the following minimum DB2 authorizations:

 

Select on SYSIBM.SYSINDEXPART  OR SYSCTRL
Select on SYSIBM.SYSTABLEPART  OR SQLADM

Alter TABLESPACE and Alter INDEX

 OR  [SYSCTRL BDADM on the Database containing the objects being Reorged. Ownership of the object being Reorged.]

 

If you specify FASTSWITCH YES The Xmanager ID used by Utility Process Manager (UPM) must have Update authority on the IPREFIX Column for the following SYSIBM Tables: 

SYSIBM.SYSINDEXPART

SYSIBM.SYSTABLEPART

 

The IPREFIX column in the SYSIBM.SYSINDEXPART and SYSIBM.SYSTABLEPART tables are not updated. However UPM can update these columns.