Installation SYSADM
Installation SYSADM authority is assigned to one or two IDs when Db2 is installed; it cannot be assigned to a role. These IDs have all the privileges of the SYSADM authority.
No other IDs can revoke the installation SYSADM authority;
you can remove the authority only by changing the module that contains
the subsystem initialization parameters (typically DSNZPARM).
In addition, Db2 does not record the installation SYSADM authority in the catalog. Therefore, the catalog does not need to be available to check installation SYSADM authority. The authority outside of the catalog is crucial. For example, if the directory table space DBD01 is stopped, Db2 might not be able to check the authority to start it again. In this case, only an installation SYSADM can start it.
IDs with the installation SYSADM authority can also perform the following actions:
- Run the CATMAINT utility
- Access Db2 when the subsystem is started with ACCESS(MAINT)
- Start databases DSNDB01 and DSNDB06 when they are stopped or in restricted status
- Run the DIAGNOSE utility with the WAIT statement
- Start and stop the database that contains the application registration table (ART) and the object registration table (ORT).
- Grant, revoke, and manage security-related
objects regardless of the setting of the SEPARATE_SECURITY system
parameter.