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, and local.
  • 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, or LOCAL), 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.