Standard 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
Here's a link to the Doc for more reading:
https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-rapid-reorg-for-db2-for-z-os/20-0/getting-started/required-authorizations.html
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.