Navigator User Guide

10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

CAPX Advanced Parameters Dialog Box - General Tab

On the

General

tab of the

CAPX Advanced Parameters

dialog box, define any optional overrides that you want to use for the database row test of batch access to change data.

The CAPX access method is restricted to reading files produced by the PowerExchange Condense system on z/OS and i5/OS. Use the CAPXRT access method for Linux, UNIX, and Windows database types, and for direct access to captured data on z/OS and i5/OS. The considerations for CAPXRT also apply to CAPX. Informatica recommends that you capture data using the PowerExchange Logger and only use PowerExchange Condense on z/OS and i5/OS if you set the

Full Condense

option in capture registrations.

Extract Type: The extraction type. Select one of the following options:

CC
. Starts the extraction from the point that is identified by the token values in the
Restart Token 1
and
Restart Token 2
fields on this tab. If you select this option, you must specify valid token values.
For z/OS sources, if you use the default value of Y for the FUZZYRSTART parameter in the LRAP CAPI_CONNECTION statement, you can enter a
Restart Token 2
position other than a begin-uow position from which to start extraction processing in the PowerExchange Logger for z/OS logs. In the following example, the
Restart Token 2
value points to a RBA position that does not coincide with a begin-uow record and the
Restart Token 1
value points to a position before the
Restart Token 2
position:

In the
Restart 1
field, specify
000000000001000000000000000000000000000000000000
. This value consists of 48 zeroes with a "1" in the twelfth position. With this value, the Restart Token 2 value will determine the records to be returned by the row test.
In the
Restart 2
field, specify a value that consists of a 6-byte Logger ID in EBCDIC format (padded with spaces) + a 6-byte RBA position + 8 zeroes. The RBA position can be any RBA in the logs near where you want to restart extraction processing. For example:
E2C2F2D340400000000AEF4000000000

With these restart token settings, PowerExchange begins extraction processing at the first record that is at or past the Restart 1 position and in the first UOW that is returned based on the Restart 2 position.

RS
. Restarts the extraction from the start point of the last extraction. This option enables you to run the same extraction multiple times.

SL
. Starts the extraction from the point at which the last extraction ended. This extraction uses restart tokens for z/OS or checkpoint timestamps for i5/OS.

Default is
RS
.
Image Type: The capture image type. Select one of the following options:

AI
. Captures the after-image data.

BA
. Captures the before-image data as it existed before the latest change. Also, captures the after-image data as it existed after the latest change.

The before-image data is shipped with an action character that forces the deletion of the record. The after image data, which includes the change data, is delivered as an insert operation.

TU
. Captures the before- and after-image data, as it occurs. The application uses the before-image data to verify that no changes occurred in the record since the request. The after-image data appears as an update operation. The update is a full image, but the application that captures this update can change the target record instead of deleting the record and then inserting a new record, as occurs with BA. The TU option is used with ODBC connections.

Default is
AI
.
Timeout: The maximum amount of time, in seconds, to wait for data before returning an end-of-file (EOF).

Valid values are:

0. Returns the EOF when the end of the current log is reached. The end of the log is determined at the start of the extraction process, because the actual end point constantly changes.

2 to 86399. Waits the specified number of seconds for data before returning the EOF.

86400. Waits continually for an unlimited amount of time, without returning the EOF.

Default is 15.
No Progress Update: Indicates whether to add database row test output to the PowerExchange CDC audit trail for the application.

Select this check box to omit database row test output from the PowerExchange CDC audit trail.

Clear this check box to include database row test output in the PowerExchange CDC audit trail.

By default, the check box is selected.
Restart Token 1: This field is available only if you selected
CC
in the
Extract Type
field. If you want the database row test to start fetching data from a specific point in the change stream, enter a valid sequence token value in this field. The sequence token in combination with the restart token value in the
Restart Token 2
field identify a specific change record in the change stream from which the database row test will begin retrieving data. You can use these fields to bypass old records that have been archived off disk or to bypass records that are not consistent with an updated extraction map.
The sequence token is a binary value with a length that varies by data source type. You can generate a sequence token and restart token for the current end of the change stream in the following ways:

In the PowerExchange Navigator, perform a CAPXRT database row test that specifies the SELECT CURRENT_RESTART statement in the
SQL Statement
box. The
Database Row Test Output
window displays the generated token values.
Use the DTLUAPPL utility to generate the sequence token and restart token values. In the ADD or MOD APPL statement, include the RSTTKEN GENERATE parameter. Then use the PRINT APPL statement to print the generated token values.
The generated sequence token is in the format that is used by ODBC extractions. To use the token value for a database row test, add eight zeroes to the end of the value.

Alternatively, if you have run PWXPC CDC sessions recently, you can copy the token values from the following messages:

In the PowerExchange message log, the PWX-04565 and PWX-09959 messages show the sequence token in the
Sequence
field and the restart token in the
PowerExchange Logger
field
In the PowerCenter workflow session log, the PWXPC_12060 and PWXPC_12068 messages show the sequence token in the
Restart Token 1
field and the restart token in the
Restart Token 2
field. Also, the PWXPC_10081, PWXPC_10082, and PWXPC_12128 messages show the sequence token as the first token value and the restart token as the second token value.

If you need assistance with creating valid token values, contact Informatica Global Customer Support.
Restart Token 2: This field is available only if you selected
CC
in the
Extract Type
field. If you want the database row test to start fetching data from a specific point in the change stream, enter a valid restart token value in this field. The restart token value in combination with the sequence token value in the
Restart Token 1
field identify a specific change record in the change stream from which the database row test will begin retrieving data. You can use these fields to bypass old records that have been archived off disk or bypass records that are not consistent with an updated extraction map.
The restart token is a binary value with a length that usually varies by data source type. On z/OS, restart tokens for all data source types have the same length, except for change data extracted from full condense files. You can generate restart token and sequence token values that indicate the current end of the change stream from the PowerExchange Navigator or with the DTLUAPPL utility. Alternatively, if you have run PWXPC CDC sessions recently, you can copy the token values from messages in the session log or the PowerExchange message log. If you need assistance with creating valid token values, contact Informatica Global Customer Support.
Extraction Schema: Overrides the schema that is specified in the extraction map.

Click

to save changes. The source database connection closes. In the

Database Row Test

dialog box, click

to establish the database connection again and perform the database row test with the updated advanced properties.

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

CAPX Advanced Parameters Dialog Box - General Tab

CAPX Advanced Parameters Dialog Box - General Tab