Preparing your system to use the bundled IBM DB2 Database
Ensure that the ID of the user account hosting the DB2 database meets the following requirements from IBM. For more information about IBM's requirements for Unix or Linux systems hosting DB2, see the DB2 users and groups (Linux and Unix) in the Database Fundamentals section of the DB2 Solution Information Center at http://www.ibm.com/support .
- Must have a primary group other than guests, admins, users, or local
- Can include only lowercase letters (a-z), numbers (0-9), or the underscore character (_)
- Cannot be longer than eight characters
- Cannot begin with IBM, SYS, SQL, or a number
- 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 existing user IDs are specified instead of creating new user IDs, ensure that the user IDs:
- Are not locked
- Do not have expired passwords
- The primary group of the user must meet the following requirements:
- Cannot be one of guests, admins, users, or local
- Cannot start with sql or ibm
- Cannot start with a number
- Must contain only lowercase letters (a-z), or numbers (0-9).
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*