Enabling root-based features in non-root installations with db2rfe

There are several features and abilities in non-root installations that are initially unavailable but can be enabled by running the db2rfe command.

Before you begin

This task requires root user authority.


To enable the features and abilities that are initially unavailable in non-root installations:

  1. Locate the sample configuration files.
    Two sample configuration files are provided:
    • $HOME/sqllib/instance/db2rfe.cfg is pre-configured with default values for the non-root Db2® instance
    • $HOME/sqllib/cfg/db2rfe.cfg.sample is not configured
    where $HOME is the non-root user's home directory.
  2. Copy one of the sample configuration files to a different location so the original file remains unaltered.
  3. Update the copied configuration file as needed.
    This configuration file is input to the db2rfe command.
    Here is a sample configuration file:
    • The value for the INSTANCENAME parameter is provided automatically by Db2 installer
    • The SET_ULIMIT parameter is available only on AIX®. On other operating systems, a user with root authority needs to set ULIMIT values manually.
    • The default value for the other keywords is NO
    • Child parameters (such as SVCENAME) are commented out by default. Comments are denoted with **
    • If you set a parameter to YES, and if it has any child parameters, uncomment the child parameters and provide appropriate values. Any port values that are provided are examples. Ensure the port values that you assign are free.
    The following example is provided to show an edited configuration file that enables the features and abilities that are mentioned in the following list:
    • High availability
    • Operating system-based authentication
    • Db2 Text Search, with a service name of db2j_db2inst2 and a port value of 55000
    To enable these features and abilities, edit the configuration file as follows:
  4. Log in with root user authority.
  5. Go to the $HOME/sqllib/instance directory, where $HOME represents the non-root user's home directory.
  6. Run the db2rfe command by using the following syntax:
    db2rfe -f config_file
    where config_file is the configuration file that was created in Step 3.

What to do next

To keep root-based features enabled on non-root installations, rerun the db2rfe command after you apply fix packs or upgrade to a new version.