34 IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
3.4.1 Customizing the recex.properties file
DB2 RE has a configuration file where you can customize certain properties that
control how DB2 RE behaves. The DB2 RE configuration file is called
recex.properties and is laid out in a key=value format. This section describes the
keys and value options, how to decide what values to use (if any), and the effect
of making changes to this file.
We strongly recommend that you customize the recex.properties file before you
start working with DB2 RE and that you re-examine your choices after you are
more comfortable with how the file works and what kind of recovery activities you
perform.
In a UNIX environment, the default permissions on the recex.properties file are
set to be owned by root. The readme file suggests that you should not change
the write permissions on this file. However, we found that development has lifted
this restriction somewhat in DB2 Recovery Expert V2.1. Therefore, we
recommend that after installation the root user change the ownership and
permissions of the recex.properties file to allow write access by the group that
contains the DB2 instance owners.
In our lab environment, all the instance owners were members of one group. So,
we gave that group permissions to modify the recex.properties file. If your
environment is different, you need to find suitable ownership and permissions
that allow the appropriate personnel to modify the file. Alternatively, you can
leave the file as owned by root and have the root administrator change the file as
necessary. In some cases, DB2 RE continues to check the permissions on the
file, which prevents you from starting DB2 RE. If that happens, DB2 RE displays
an error message, and you need to modify the permissions appropriately at that
point.
You can have one global properties file that affects all users and all instances, or
you can create a separate properties file per instance. We describe both
approaches here.
Global properties file
Example 3-2 shows the recex.properties file that we used on one of our ITSO lab
systems, a Linux server named LEAD. We refer to this example in the following
discussions of each of the properties.
Example 3-2 The recex.properties file from LEAD
# DB2 Recovery Expert configuration file
#
# define various product working directories in terms of
Chapter 3. Installing and configuring DB2 Recovery Expert 35
# the base DATA_DIR location:
DATA_DIR=/REassets
CONF_DIR={INSTALL_DIR}/conf
sysstorage.path={DATA_DIR}/sysstorage
minilogs.path={DATA_DIR}/minilogs
work.path={DATA_DIR}/work
# directives to configure the size and location of the
# logcache.path=<cache_directory_pathname>
# logcache.size=<size_in_megabytes>
logcache.path={DATA_DIR}/logcache
logcache.size=200
# directives to configure the starting log number for processing
# for each partition of each database:
# startlog.<database_name>.<partition_number>=<log_number>
#startlog.RECART.0=29
#startlog.TRADEDB.0=5
startlog.TRADSIMP.0=4
# enable this directive to prevent SQL files generated during the
# recovery process from being deleted:
recoverytask.keep_sql=true
# enable this directive to activate detailed event logging into
# the db2recex.log file (independently from DB2 DIAGLEVEL setting):
log.level=4
# to define the product data directory and instance-specific
# configuration directory, use the DATA_DIR and CONF_DIR variables.
# Examples for Unix/Linux platforms are shown below:
# DATA_DIR={/}var{INSTALL_DIR}
# CONF_DIR={/}etc{INSTALL_DIR}
Configuration settings
The following describe the configuration settings in the recex.properties file and
how to use these configuration settings:
򐂰 Comments
Any line whose first character is a hash mark (#) is treated as a comment.
򐂰 Curly braces
The default properties file shows all occurrences of the forward slash mark (/)
to be enclosed in curly braces, for example {/}. This is not required for UNIX
systems, but you can include them if you like. It is required for Windows

Get IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.