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.
Procedure
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
where
$HOME is the non-root user's home
directory.
- 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=55000
Note:
- 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:
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:
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.