CHECKPOINT 
  [CHKPTINTERVAL=
minutes]
  [COMPLETEDEVENTSAGE=
minutes]
  [COMPLETEDEVENTSDIR=
directory]
  [MAXCHKPTSIZE=
kilobytes]
  [RETENTIONPERIOD=
minutes]
  [MINCHKPTSTOKEEP=
number_of_checkpoints]
  [EXCEPTIONS=(
REJECT|TOLERATE}]
  ;

CHKPTINTERVAL

The interval, in minutes, that must elapse between taking checkpoints. Valid values are 1 through 1440. The default value is 5 minutes.

COMPLETEDEVENTSAGE

The interval, in minutes, that must elapse before a transaction with active operations can be forced to spill to disk. Only transactions that are spilled to disk can be checkpointed.

Valid values are 0 through 1440. A value of 0 means never force a transaction with active operations to spill to disk for checkpointing. The default value is 30.

COMPLETEDEVENTSDIR

The file system directory to which spilled active transaction data is copied during checkpoint processing.

If the COMPLETEDEVENTSAGE parameter value is greater than 0, you must specify either this COMPLETEDEVENTSDIR parameter or the BASEDIRECTORY parameter in the STATESTORAGE statement. The default value is the BASEDIRECTORY value.

EXCEPTIONS

Controls whether to tolerate missing spill file data or to reject this type of exception. Tolerate this exception only if you can allow some data loss rather than regress the restart point. Options are REJECT and TOLERATE. Default is REJECT.

MAXCHKPTSIZE

The maximum amount of data, in kilobytes, that can be forced to spill to disk during a single checkpoint. You can use this parameter to block very large transactions from forcibly spilling to disk, which might improve performance during large batch processing. Valid values are 1 through 1024*1024 (or 1 GB). The default value is 50*1024 (or 50 MB).

MINCHKPTSTOKEEP

The minimum number of checkpoints to keep. The default value is 3.

RETENTIONPERIOD

The period, in minutes, for which checkpoint data is retained. Valid values are 0 through 44640. The default value is 10080 (1 week).

TDEKEYSTORE

New

. If the Oracle source uses Transparent Data Encryption (TDE) to encrypt source tablespaces, provide the location of the keystore that contains the encryption key required for the encryption and decryption of data. The keystore can be located in Automatic Storage Management (ASM), a file, or a hardware security module (HSM). Depending on the type of store, enter this parameter in one of the following ways:

For an ASM store, the syntax is:
TDEKEYSTORE=(TYPE=(ASM, WALLETDIR=
path/directory,{PWD|EPWD}=
wallet_password, [ASM_CONNECT_STRING=
string,ASM_PASSWORD=
asm_password,ASM_USERID=
asm_userid,ASM_ASSYSASM=Y]))
Where:
TYPE must be the store type of ASM.
WALLETDIR is the fully qualified path to the ASM wallet.
{PWD|EPWD} is the password or encrypted password that is required to access the ASM wallet.
ASM_CONNECT_STRING is the Oracle connection string, defined in TNS, that the PowerExchange Express CDC log reader uses to connect to the ASM instance.
ASM_PASSWORD is a password for the user specified in the ASM_USERID parameter, which is used to connect to the ASM instance.
ASM_USERID is an Oracle user ID that the PowerExchange Express CDC log reader uses to connect to the ASM instance, which has SYSDBA or SYSASM authority.
ASM_ASSYSASM must be set to Y to have the PowerExchange Express CDC log reader to use a user ID that has SYSASM authority to connect to the ASM instance.
If you do not define ASM_CONNECT_STRING in the TDEKEYSTORE parameter, you must define the ASM connection parameters in the READER statement.
For a file store, the syntax is:
TDEKEYSTORE=(TYPE=(FILE,WALLETDIR=
path/directory,[PWD|EPWD]=
password))
Where:
TYPE must be the store type of FILE.
WALLETDIR is the fully qualified path to the file system wallet. PowerExchange Express CDC will not attempt to extract the path from the database.
{PWD|EPWD} is the password or encrypted password that is required to access the wallet.
For an HSM store, the syntax is:
TDEKEYSTORE=(TYPE=(HSM,HSMCLIENTLIB=
path\module,[PWD|EPWD]=
password))
Where:
HSMCLIENTLIB is the fully qualified path and module name of the HSM client library. For information about setting up access to an HSM device or server, see the HSM vendor documentation. PowerExchange Express CDC uses the standard PKCS #11 interface to access HSM keys.
{PWD|EPWD} is the password or encrypted password that is required to access the HSM device.

If you define multiple TDEKEYSTORE parameters, PowerExchange Express CDC searches them for the master key in the order in which they are defined.

The TDEWALLETDIR, TDEWALLETPWD, and TDEWALLETEPWD parameters are deprecated.

BCE_SUBSTITUTE_YEAR=

year

New

. Specifies the substitute year value to use when the BCE_YEAR_HANDLING parameter is set to SUBSTITUTE. Valid values are 1 to 9999.

BCE_YEAR_HANDLING ={

IGNORESIGN

|SUBSTITUTE|PRE1040|FAIL}

New

. Indicates how to handle a negative year in Before the Common Era (BCE) dates. Options:

IGNORESIGN. Capture the year as a positive value.
SUBSTITUTE. Substitute the year with the value specified in the BCE_SUBSTITUTE_YEAR parameter. If you specify BCE_YEAR_HANDLING=SUBSTITUTE you must specify a value for BCE_SUBSTITUTE_YEAR.
PRE1040. Revert to the old behavior of reporting a negative value (-CCYY) as a positive value (YY00).
FAIL. Report BCE dates as errors in message PWX-36200 and shut down the PowerExchange Logger for Linux, UNIX, and Windows.

Default is IGNORESIGN.

SPILLENCRYPTEPASS=

encrypted_passphrase

New

. An encrypted passphrase that enables spill file encryption. PowerExchange writes transactions to spill files when it does not have sufficient memory to store them. You can optionally encrypt the spill files to protect sensitive data by setting either this parameter or the SPILLENCRYPTPASS parameter. The maximum passphrase length is 1024 bytes. No default value is provided.

SPILLENCRYPTPASS=

passphrase

New

. A passphrase that enables spill file encryption. PowerExchange writes transactions to spill files when it does not have sufficient memory to store them. You can optionally encrypt the spill files to protect sensitive data by setting either this parameter or the SPILLENCRYPTEPASS parameter. The maximum passphrase length is 1024 bytes. No default value is provided.

STATESTORAGE
   STORETYPE={Directory|Table}
   BASEDIRECTORY="
path\\
directory"
  [CONNECT_STRING=
connect_string]
  [PREFIX=
collection_id]
  [TABLEOWNER=
userid]
  [USERID=
user_ID]
  [PASSWORD=
password]
  [EPWD=
encrypted_password]
;

STORETYPE

Required. The type of storage for state information. You can use a relational table or a file system directory. Options are Directory or Table. No default value is provided.

BASEDIRECTORY

Required. The base directory under which subdirectories that contain files or tables with state information are generated. Specify this parameter if the STORETYPE parameter is set to

Directory

or if you plan to enable checkpointing.

For table-based checkpoint storage, you must specify either this BASEDIRECTORY parameter or the COMPLETEDEVENTSDIR parameter in the CHECKPOINT statement. Express CDC will copy the checkpointed spill files to this directory.

CONNECT_STRING

A connect string that is used to connect to the Oracle database where the state tables are created. The default value is the CONNECT_STRING value in the DATABASE statement.

PREFIX

A unique prefix for the names of the files or tables where state information is stored. Specify this prefix only if you want to override the default value, which is the collection ID specified in the ORACOLL parameter in the ORAD CAPI_CONNECTION statement. The ORACOLL parameter supplies a unique value for each Express CDC instance that is running. If you use the optional PREFIX parameter, ensure that it also provides a unique value for the Oracle instance.

TABLEOWNER

The owner of the state tables. The default value is the USERID value in this statement, if specified, or the USERID value in the DATABASE statement.

USERID

A database user ID for accessing the state tables. The default value is the USERID value in the DATABASE statement.

PASSWORD

A password, which is used in conjunction with the user ID, to provide credentials for accessing the state tables. The default value is the PASSWORD value in the DATABASE statement.

EPWD

An encrypted password, which is used in conjunction with the user ID, to provide credentials for accessing the state tables. The default value is the EPWD value in the DATABASE statement.