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 a the db2rfe command.

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.
   An example of a configuration file is:

   INSTANCENAME=db2inst2
   SET_ULIMIT=NO
   ENABLE_HA=NO
   ENABLE_OS_AUTHENTICATION=NO
   RESERVE_REMOTE_CONNECTION=NO
      **SVCENAME=db2c_db2inst2
    	**SVCEPORT=48000 
   RESERVE_TEXT_SEARCH_CONNECTION=NO
    	**SVCENAME_TEXT_SEARCH=db2j_db2inst2
    	**SVCEPORT_TEXT_SEARCH=55000

   Note:

   • The value for the INSTANCENAME parameter is filled in 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, it is recommended that you uncomment the child parameters and provide appropriate values. Any port values that are provided are examples. Ensure the port values you assign are free.
   The following example is provided to show an edited configuration file that will enable the features and abilities 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:

   INSTANCENAME=db2inst2
   SET_ULIMIT=NO
   ENABLE_HA=YES
   ENABLE_OS_AUTHENTICATION=YES
   RESERVE_REMOTE_CONNECTION=NO
      **SVCENAME=db2c_db2inst2
    	**SVCEPORT=48000 
   RESERVE_TEXT_SEARCH_CONNECTION=YES
    	  SVCENAME_TEXT_SEARCH=db2j_db2inst2
    	  SVCEPORT_TEXT_SEARCH=55000

4. Log in with root user authority.
5. Navigate to the $HOME/sqllib/instance directory, where $HOME represent's the non-root user's home directory.
6. Run the db2rfe command using the following syntax:

   db2rfe -f config_file

   where config_file is the configuration file created in Step 3.