System Maintenance Authority Group Name (sysmaint_group)

Configuration Type
Database manager

Applies to

Parameter Type
Configurable

Default
Null

Related Parameters

This parameter defines the group name with system maintenance (SYSMAINT) authority. SYSMAINT has privileges to perform maintenance operations on all databases associated with an instance without having direct access to data.

Attention: This parameter must be NULL for Windows 95 clients when system security is used (that is, authorization is CLIENT, SERVER, or DCS). This is because Windows 95 does not store group information, thereby providing no way of determining if a user is a member of a designated SYSMAINT group. When a group name is specified, no user is considered to be a member of it and no user is considered to have system control authority. This is not true when DCE authentication is used. In this situation, group names can be specified.

To restore the parameter to its default (NULL) value, use UPDATE DBM CFG USING SYSMAINT_GROUP NULL. You must specify the keyword "NULL" in uppercase. You can also use the Configure Instance notebook in the DB2 Control Center.