3 Collector Parameters

Collector Parameters

Most Collector parameters are entered in the Extract parameter file, using the PARAMS collector_params option of the RMTHOST parameter. The Manager automatically sends some of these parameters when it starts the Collector, such as -k and ENCRYPT key and KEYNAME options entered by the user.

The Collector parameters discussed here are for a Collector running on a remote NonStop system. For Collector parameters that run on other platforms, see the Oracle GoldenGate for Windows and UNIX Reference Guide.

-PROCESS process_name

The name of the NonStop TCP/IP process.

-BULKIO

Results in Collector writing data in 28K blocks, rather than 4K. Setting -BULKIO can increase total throughput of the Collector and reduce overhead significantly.

-BULKIOLEN

Use BULKIOLEN to customize the block size Collector should use when writing data. Increasing the block size used by Collector can contribute a net performance gain by increasing total throughput. Block sizes may be indicated in bytes or kilobytes, but the Collector only recognize sizes that are multiples of 2. If you choose a block size between 2 and the next multiple, BULKIOLEN automatically rounds your specification down.

-b backup_cpu

Runs the Collector backup process started in backup_cpu. This option is only for static servers. It is not valid for dynamic servers, which are persistent processes that will be restarted if the process has a failure.

-B

Directs the Collector to buffer files.

-DEBUG

Starts the Collector in DEBUG mode to allow the user to analyze the actions of the program code.

-EMSEMPHASIS type

Controls whether or not emphasis will be turned on for certain types of messages coming from EMSCLNT on open systems.

type can be one of the following:

CRITICAL

Turns emphasis on for CRITICAL or WARNING messages as well as FATAL messages.

FATAL or ERROR

Turns emphasis on only for FATAL messages.

The default is CRITICAL.

-ENCRYPT encrypt_type

The type of encryption being passed from the Extract process, as specified with the RMTHOST parameter in the Extract parameter file.

Valid values:

• GGS

• BLOWFISH

If using BLOWFISH, also specify the -KEYNAME option. For more information about Oracle GoldenGate security, see the Administering Oracle GoldenGate for HP NonStop (Guardian).

-f

Always forces file writes to be flushed to disk before returning a success status to the Extract process.

By default, the file system buffers the I/O because it is more efficient than flushing to disk with every operation. Generally, the performance benefits outweigh the small risk that data could be lost if the system fails after an I/O is confirmed successful, but before the buffer actually is flushed to disk. Use -f if this risk is unacceptable, with the understanding that it can compromise the performance of Oracle GoldenGate.

-HOMETERM terminal

Identifies the home terminal for the Collector.

-k

Directs Collector to terminate when the Extract process that it is serving disconnects. This option is used by the Manager process when starting the Collector process.

-KEYNAME name

Specifies a key name defined in the local ENCKEYS lookup file. name is the name of a key in a lookup file on the target system. For more information about Oracle GoldenGate security, see the Administering Oracle GoldenGate for HP NonStop (Guardian).

-l file_name

Directs the Collector to log to file_name. The name should be fully qualified.

-m number

Specifies the maximum number of files to allocate.

-NOFLUSHCACHE | FLUSHCACHE

Turns on or off the flushing of the disk cache.

-p port_number

A TCP/IP port number on which the Collector listens for connections from the Extract process. The default is port 7819.

-t

Turns on TCP tracing to write detail to EMS on socket operations. It is recommended that you use this parameter only when requested by Oracle GoldenGate Support.

-TCPSTATS

Specifies that TCP statistics should be printed at file rollover.

-v

Specifies that NonStop Collector processes use EMS logging.

QSAM Configuration Parameters

For OS/390 QSAM files, both fixed-length and variable-length, you can specify a configuration file on the OS/390 platform to set certain file creation characteristics. Indicate the location of this file with the -P collector parameter.

You can also specify QSAM file creation characteristics using the RMTBATCH Extract program parameter. The syntax is:

RMTBATCH file_spec, option [, option, ...];

file_spec

A file name or wildcard for the incoming file. Any files that match file_spec are assigned the file creation rules you specify with option. If a file name is satisfied by more than one RMTBATCH entry in the configuration file, the last entry is used.

option

One of the following.

CLOSEACTION "system_command"

Submits a shell script or system command to the system upon file close, when close was a result of completed processing of the corresponding source file (indicated by a "file close on source" message).

The Collector waits for the command to complete. To return control to the Collector immediately, specify a "nowait" type operation in the script or command (as with the & in UNIX).

COMMENT

Lets you insert comments. Anything on the same line after COMMENT is ignored. Comments can also begin with two hyphens (--).

SPACE (primary_quantity, secondary_quantity, unit)

Mandatory parameter. Requests space for a new data set.

primary_quantity

The number of tracks, cylinders, or blocks to be allocated for a new data set.

secondary_quantity

The number of additional units to allocate if more space is needed.

unit

The units in which space is requested. Use TRK for tracks, CYL for cylinders, or BLK for blocks.

TARGETFTYPE {QSAMV | QSAMF}

Mandatory parameter for QSAM files. Specify QSAMV for variable-length MVS QSAM files or QSAMF for fixed-length MVS QSAM files.

TARGETRECLEN record_length

Mandatory parameter for QSAM files. Specify the length in bytes of a fixed-length record or the maximum length in bytes for variable-length records. record_length can be from 1 to 32760.

TARGETBLKSIZE block_length

Parameter for QSAM files. Specify a multiple of the record length for fixed-length records, or the maximum record length +4 for variable-length records. block_length can be from 1 to 32760.

VOLUME serial_number

Mandatory parameter. Identifies the serial number of the volume on which the target data set will reside. Specify only one volume serial number.

Example

The following example matches all source file names. It creates fixed length records of 100 bytes, in blocks of 1000 bytes (10 records per block), with a volume serial number for the new data set of 123456, and allocates an initial space of 20 tracks. If more space is needed, it is allocated in increments of 10 tracks.

RMTBATCH *,
TARGETFTYPE QSAMF,
TARGETRECLEN 100, TARGETBLKSIZE 1000,
VOLUME 123456, SPACE (20,10,TRK),
CLOSEACTION "type * %";