Create DB2 Universal Database users

When installing DB2, there is a limitation on what user names you can use. A common user name is db2admin, but you can assign any user name as long as it has administrative access and follows the limitations set out here. It is recommended that you do not change the user name after creating it. User names can contain the following characters A-Z, a-z, and 0-9.

The limitations are as follows:

• User names on AIX can contain one to eight characters.
• User names on Windows can contain one to 30 characters. The Windows 2000 operating systems currently have a limit of 20 characters.
• Passwords can contain one to 14 characters.
• Group and instance names can contain one to eight characters.

• Names cannot be any of the following examples:

  users
  admins
  guests
  public
  local
  

• Names cannot begin with:

  IBM
  SQL
  SYS
  

• Names cannot include accented characters, diacritics (such as umlauts), and spaces.

 

AIX is a trademark of the IBM Corporation in the United States, other countries, or both.