IBM Db2 11.1 Certification Guide

The system administrative authority (SYSADM) 

This is the highest level of administrative authority available within Db2 and it allows the user to perform the following tasks:

• Update database manager configuration parameters
• Grant and revoke table space privileges
• Upgrade and restore databases
• All of the tasks listed in the SYSCTRL, SYSMAINT and SYSMON authorities

You can assign SYSADM authority by updating the database manager configuration parameter, SYSADM_GROUP.

To add an operating system group SYSADMIN to the SYSADM_GROUP use the following command:

UPDATE DBM CFG USING SYSADM_GROUP SYSADMIN;

To revert to the default setting, execute the following command:

UPDATE DBM CFG USING SYSADM_GROUP NULL;