IBM GC09-2830-00 manual Username, User ID, Group Name, and Instance Name Rules

Using delimited identi®ers, it is possible to create an object that violates these naming rules; however, subsequent use of the object could result in errors.

For example, if you create a column with a + or − sign included in the name and you subsequently use that column in an index, you will experience problems when you attempt to reorganize the table. To avoid potential problems with the use and operation of your database, do not violate these rules.

Username, User ID, Group Name, and Instance Name Rules

Usernames or User IDs are the identi®ers assigned to individual users. When naming users, groups, or instances, see ªGeneral Naming Rulesº on page 165.

In addition, the name you specify:

vCan contain 1 to 8 characters

vCannot be any of the following:

±USERS

±ADMINS

±GUESTS

±PUBLIC

±LOCAL

vCannot begin with:

±IBM

±SQL

±SYS

vCannot include accented characters

vIn general, when naming users, groups, or instances: OS/2 Use uppercase names.

Windows 32-bit operating systems Use any case.

Workstation Name (nname) Rules

A workstation name speci®es the NetBIOS name for a database server or client that resides on the local workstation. This name is stored in the database manager con®guration ®le. The workstation name is known as the workstation nname. When naming workstations, see ªGeneral Naming Rulesº on page 165.

In addition, the name you specify:

Appendix F. Naming Rules 167