DB2 Version 9.7 for Linux, UNIX, and Windows

Installing a DB2 product as a non-root user

Before you install any DB2 product as a non-root user, be aware of the differences between root installations and non-root installations, and the limitations of non-root installations. Refer to the Related Links at the end of this topic for details.

Prerequisites for installing a DB2 product as a non-root user are:

• You must be able to mount the installation DVD, or have it mounted for you.
• You must have a valid user ID that can be used as the owner of a DB2 instance.

  User IDs have the following restrictions and requirements:

  • 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 ( _ )
  • 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, make sure that the user IDs:
    • Are not locked
    • Do not have expired passwords
• The hardware and software prerequisites that exist for the product you are installing apply to the non-root user just as they do for root users.
• On AIX® Version 5.3, Asynchronous I/O (AIO) must be enabled.
• Your home directory must be a valid DB2 path.

  DB2 installation paths have the following rules:

  • Can include lowercase letters (a-z), uppercase letters (A-Z), and the underscore character ( _ )
  • Cannot exceed 128 characters
  • Cannot contain spaces
  • Cannot contain non-English characters

Installing DB2 products as a non-root user is transparent to the non-root user. In other words, there is nothing special a non-root user needs to do to install a DB2 product, other than being logged in as a non-root user. To perform a non-root installation:

1. Log in as a non-root user
2. Install your DB2 product using any of the methods available to you. Options include:
   • The DB2 Setup wizard (GUI install)
   • The db2_install command
   • The db2setup command with a response file (silent install)
     Note:
     Since non-root users cannot choose the directory where DB2 products are installed, any FILE keyword in your response file is ignored.
   Refer to the Related Links at the end of this topic for details.
3. After the DB2 product is installed, you must open a new login session to use the non-root DB2 instance. Alternatively, you can use the same login session if you source the DB2 instance environment with $HOME/sqllib/db2profile (for Bourne shell and Korn shell users) or $HOME/sqllib/db2chsrc (for C shell users), where $HOME is the non-root user's home directory.

After the DB2 product is installed, verify your operating system user process resource limits (ulimits). If the minimum ulimit values are not met, the DB2 engine can encounter unexpected operating resource shortage errors. These errors can lead to a DB2 outage.