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:
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:
The IPREFIX column in the SYSIBM.SYSINDEXPART and SYSIBM.SYSTABLEPART tables are not updated. However UPM can update these columns.