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:
- 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
- Copy one of the sample configuration files to a different location so the original file remains unaltered.
- Update the copied configuration file as
needed. This configuration file is input to the db2rfe command.Here is a sample configuration file:
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=55000Note:
The following example is provided to show an edited configuration file that enables the features and abilities that are mentioned in the following list:
- 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.
- High availability
- Operating system-based authentication
- Db2 Text Search, with a service name of
db2j_db2inst2and a port value of
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
- Log in with root user authority.
- Go to the $HOME/sqllib/instance directory, where $HOME represents the non-root user's home directory.
Run the db2rfe command by using the following syntax:
where config_file is the configuration file that was created in Step 3.
db2rfe -f config_file
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.