Quick Beginnings

User IDs, Group Names, and Instance Names

User IDs are the identifiers assigned to individual users. When naming users, groups, or instances, see "General Naming Rules".

In addition, the name you specify:

Can contain 1 to 8 characters
Cannot be any of the following:
- USERS
- ADMINS
- GUESTS
- PUBLIC
- LOCAL
Cannot begin with:
- IBM
- SQL
- SYS
Cannot include accented characters
In general, when naming users, groups, or instances:
- On OS/2, use uppercase names
- On Windows 95 and Windows NT, use any case
- On UNIX, use lowercase names

If you are using DB2 for Windows NT, see "Additional Considerations for Usernames in Windows NT" for additional considerations for user ID names.

Additional Considerations for Usernames in Windows NT

To use DB2 for Windows NT, you need to create a special username that meets DB2's naming requirements. You must use this username to install and perform DB2 administration tasks.

When you name a username in Windows NT, the name you specify:

Must be a member of the Administrators group on the local machine
Must be acceptable to DB2 as described previously.

Whenever an instance is created for DB2 servers or DB2 Connect servers, a Windows NT service is also created using the instance name. In addition, an instance directory is created in the sqllib using the instance name. For example, if DB2 is installed in the e:\sqllib directory, the default instance creates the following directory path: e:\sqllib\db2. Therefore two additional restrictions apply when you are naming DB2 instances:

DB2 instance names cannot conflict with other Windows NT service names.
DB2 instance names cannot be the same as the names of existing directories or files under sqllib.

Note:

Do not attempt to install or administer DB2 from Windows NT's default "Administrator" username. Because that username has more than eight characters, DB2 will not accept the request.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]