Quick Beginnings

Logging on to the System

To use DB2, log on with a valid user ID that has the appropriate authority level for the commands you want to execute. If the SYSADM_GROUP parameter is defined in the database manager configuration file, the user performing administration tasks (such as cataloging, starting the database manger, or creating the sample database) must belong to the System Administrative group. The SYSADM_GROUP parameter is not set when DB2 is first installed; therefore, the following criteria are used to determine SYSADM authority:

OS/2

A valid DB2 user ID which belongs to the UPM Administrator or Local Administrator group.

UNIX

A valid DB2 username that belongs to the primary group of the instance owner's user ID.

Windows 95

Any Windows 95 user.

Windows NT

A valid DB2 username which belongs to Administrators group.

You can override this default case by explicitly providing a group name for the SYSADM_GROUP parameter. If you do this, the only way to assign SYSADM authority is by membership to this group. See "Changing Default Privileges for Users" for more information

See Appendix D. "Naming Rules" for a list of restrictions on valid username or user IDs.

As well as using the local operating system security to authenticate users, there is also the option of using DCE security. Refer to the Administration Guide for information on DCE security.

[ DB2 List of Books | Search the DB2 Books ]