SYSADM—Installation SYSADM IDs
Use the Modify Install SYSADM IDs panel or the SYSADM command to specify new installation SYSADM1, SYSADM2, or both IDs. This action allows you to shift install SYSADM responsibilities from one DBA or systems programmer to another dynamically without cycling Db2. The new value takes effect immediately.
Modify Install SYSADM IDs panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : INSTALL SYSADM IDS
Type the new values for the SYSADM id parameters you wish to change. Then press Enter.
SYSADM ID Parameters
Install SYSADM ID-1 . . . . ________
Install SYSADM ID-2 . . . . ________
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
authID1 | An authorization ID with installation SYSADM authority.1 |
authID2 | An second authorization ID with installation SYSADM authority.1 |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
1 For Db2 Version 7, authorization IDs must be 1–8 characters. For Db2 Version 8 and later, authorization IDs must be 1–128 characters. The first character must be a letter of the alphabet or a national character ($, # , or @). The remaining characters can be alphanumeric or national.
OPERTUNE panels display only the first 8 characters of authorization IDs. If you want to change the auth ID to a longer name, type the first 8 characters in the Install SYSADM ID field and press Enter. When the Command Confirmation panel is displayed, you can use the EDIT command to modify the authorization ID to a longer value before submitting the command.
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Install SYSADM ID-1 | DSNTIPP | PROTADMN | DSN6SPRM | SYSADM |
Install SYSADM ID-2 | DSNTIPP | PROTADM2 | DSN6SPRM | SYSADM2 |