Db2 user ID restrictions and requirements
You must ensure that the Db2 administrator user ID meets the specific requirements and restrictions.
- Must have a primary group other than
guests
,admins
,users
, andlocal
. - Can include lowercase letters (a-z), numbers (0-9), and the underscore character ( _ ).
- On Windows, the user ID can be up to 20 characters long. On Linux or AIX systems, the user ID can be up to 8 characters long.
- Cannot begin with
IBM
,SYS
,SQL
,_
, or a number. - Cannot end with
$
. - Cannot be a Db2 reserved word
(
USERS
,ADMINS
,GUESTS
,PUBLIC
, orLOCAL
), or an SQL reserved word - Cannot use any User IDs with root privilege for the Db2 instance ID, DAS ID or fenced ID.
- Cannot include accented characters.
- If you are planning to use a domain user, specify the ID in the format:
DomainName\UserName or
UserName@DomainName. Where,
- DomainName is a string with a maximum length of 14 characters.
- UserName is a string with a maximum length of 20 characters on Windows.