New

. This statement specifies the directory that stores temporary file-mapped memory files for PowerExchange Listener statistics on AIX PPC64, i5/OS (IBM i), and Solaris SP64 systems. If you set the STATS statement to MONITOR in the DBMOVER configuration file, the memory statistics are generated when either the optional monitoring interval in the MONITOR parameter elapses or when you issue the DISPLAYSTATS or pwxcmd displaystats command.

By default, temporary file-mapped memory statistics files are written to the current directory of the user, or if the current directory is not available, to the top-most root directory of the file system.

Informatica recommends that you specify a directory that is dedicated to storing file-mapped memory statistics files and that is on a locally mounted disk.

New

. Identifies the high-level qualifier of the IMS bootstrap data set, which is required to retrieve database descriptor (DBD) information in DBDLIB (DBGEN) format from the IMS catalog. This statement also indicates the order in which PowerExchange searches the IMS DBDLIB library or IMS catalog for DBD information for source objects. Specify this statement if you want PowerExchange to retrieve DBD information from the IMS catalog for creating data maps or for the run-time extraction of data during CDC or IMS unload processing.

In this statement, the

search_preference

is one of the following options:

If you do not specify an option, PowerExchange searches only the DBDLIB library by default and does not use the IMS catalog.

Changed

. The optional LOCKAVOIDANCE parameter has been renamed to SQLNOLOCK. The original LOCKAVOIDANCE name exceeded the maximum name length of 12 characters, which could cause multiple types of errors. The purpose and behavior of the parameter remain the same. Syntax is:

If you currently use the LOCKAVOIDANCE parameter, edit the dbmover.cfg file to change the parameter name to SQLNOLOCK to avoid potential errors.

Changed

. The optional MYSQLBINLOG parameter can now include any of the options that the mysqlbinlog utility supports, such as the --ssl- options. Syntax is:

PowerExchange passes the options to the utility when the CDC session runs. For information about the utility options, see the

MySQL Reference Manual

.

If any part of the MYSQLBINLOG value includes spaces, you must enclose the entire MYSQLBINLOG value in double-quotation marks ("). Furthermore, if any part of the

path/binlog_file_name

value or an option includes a space, escape the value with the backslash (\) character and also enclose the value in double-quotation marks, for example:

If the

path\binlog_file_name

value begins with the hyphen (-) character, the entire value is treated as a utility option, as if no

path/file_name

value was specified.