SYSTEM OPERATOR 1 field (SYSOPR1 subsystem parameter)
The SYSOPR1 subsystem parameter specifies the first of two authorization IDs that are to have installation SYSOPR authority.
| Acceptable values: | 1–8 characters, the first of which must be an alphabetic character |
|---|---|
| Default: | SYSOPR |
| Update: | option 39 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM SYSOPR1 |
| Security parameter: | Yes |
The two users with installation SYSOPR authority are permitted access to Db2 even if the Db2 catalog is unavailable.
The value of the SYSTEM OPERATOR 1 field or the SYSTEM OPERATOR 2 field is used for authorization during installation or migration if you install or migrate your Db2 subsystem without SYSADM authority.
If you leave this field blank, the value is set to the value of the SYSTEM ADMIN 1 field.
Recommendation: Set the value of this field
or the value of the SYSTEM OPERATOR 2 field to SYSOPR. Doing so ensures
that Db2 commands
that are issued from the console can be processed correctly when the Db2 catalog
is unavailable.
Note: This is a security-related parameter. The authorization
ID that is specified for this parameter can issue most of the Db2 commands
such as BIND QUERY, CANCEL THREAD, and STOP DB2. This ability might
provide the authorization ID with information about user data. Also,
the authorization ID can run the DSN1SDMP utility and terminate any
utility job.