User name and group name restrictions (Windows)

There are a few limitations that are specific to the Windows environment. Be aware that general Db2® object naming rules also apply.

  • User names under Windows are not case sensitive; however, passwords are case sensitive.
  • User names and group names can be a combination of upper- and lowercase characters. However, they are usually converted to uppercase when used within the Db2 database. For example, if you connect to the database and create the table schema1.table1, this table is stored as SCHEMA1.TABLE1 within the database. (If you want to use lowercase object names, issue commands from the command line processor, enclosing the object names in quotation marks, or use third-party ODBC front-end tools.)
  • The Db2 database manager supports a single namespace. That is, when running in a trusted domains environment, you should not have a user account of the same name that exists in multiple domains, or that exists in the local SAM of the server machine and in another domain.
  • A user name should not be the same name as a group name.
  • A local group should not have the same name as a domain level group.