What levels of authority are needed to create a storage group? (Choose two.)
What levels of authority are needed to create a storage group? (Choose two.)
To create a storage group in a DB2 database, the required levels of authority are SYSADM and SYSCTRL. SYSADM is the highest level of administrative authority and allows the holder to perform any administrative task, including creating storage groups. SYSCTRL, while more limited, still provides sufficient authority to manage storage groups along with other system-level tasks.
The privileges that are held by the authorization ID of the statement must include SYSCTRL or SYSADM authority. https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0058606.html