Navigator User Guide

10.4.0 HotFix 1
- 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

Back Next

Generating Restart Tokens for Change Data Capture

You can run a database row test to generate restart tokens for data sources.

Use these generated restart tokens to populate the PWXPC restart token file for a PowerCenter session. PowerExchange generates restart tokens using the location and source type that you specify. These restart tokens represent the current end of the change stream at the time when you ran the database row test. The PowerExchange Navigator displays the generated restart tokens in the

Database Row Test Output

window. Copy the output from this window to populate the PWXPC restart token file.

Alternatively, use one of the following methods to generate restart tokens:

Include the special override statement with CURRENT_RESTART in the PWXPC restart token file. PWXPC and PowerExchange generate restart tokens that represent the current end of the change stream at the time the PowerCenter session runs.

Use the DTLUAPPL utility with the GENERATE RSTTKN parameters and a valid capture registration. DTLUAPPL generates restart tokens that represent the current end of the change stream at the time that the utility runs.

Open the extraction map for the capture registration for which you want to generate restart tokens.

On the

Extraction Map

tab in the

Resource Explorer

, click the extraction map and click

File > Database Row Test

The

Database Row Test

dialog box appears.

In the

DB Type

list, select

CAPXRT

In the

Location

list, select the node name that represents the location of the data source.

The locations displayed in the

Location

list are defined by NODE statements in the dbmover.cfg configuration file on the PowerExchange Navigator system.

In the

Application

box, enter an application name from 1 to 20 characters in length.

To generate current restart tokens, enter the following PowerExchange SQL statement in the

SQL Statement

box:

SELECT CURRENT_RESTART [WHERE [{CONNAME=capi_connection_name|CONTYPE=connection_type}] [[AND] INSTANCE=db2_database_name]]

This SELECT CURRENT_RESTART statement has the following parameters:

CONNAME=capi_connection_name: Specifies the name of a CAPI_CONNECTION statement in the DBMOVER file at the source location that PowerExchange uses to determine the data source type. PowerExchange requires this information because restart token formats vary by source type. Enter this parameter if multiple CAPI_CONNECTION statements are defined at the source location. Otherwise, this parameter is optional, and you can specify CONTYPE instead. Do not specify both CONNAME and CONTYPE.
CONTYPE=connection_type: Specifies the connection type that PowerExchange uses to determine the data source type. PowerExchange requires this information because restart token formats vary by source type.

Specify one of the following values for the conn_type variable:

ADA
for Adabas sources (z/OS).

AS4
for DB2 for i5/OS sources.

DCM
for CA Datacom/DB sources (z/OS).

DB2
. DB2 for z/OS sources (z/OS).

IDL
for CA IDMS/DB log-based sources (z/OS).

IML
for IMS log-based sources (z/OS).

IMS
for IMS synchronous sources (z/OS).

ORA
for Oracle sources.

MSS
for Microsoft SQL Server sources.

MYSQL
for MySQL sources.

PGS
for PostgreSQL sources.

UDB
for DB2 for Linux, UNIX, and Windows sources.

VSAM
or
VSM
. VSAM sources (z/OS).

For z/OS sources, all z/OS connection types result in restart tokens of the same format because PowerExchange records all change data from z/OS sources in the PowerExchange Logger for z/OS log files. Restart tokens for z/OS sources represent locations within the PowerExchange Logger logs.
INSTANCE=db2_database_name: For a DB2 for Linux, UNIX, and Windows source, specifies the DB2 database name. This parameter value is required unless you enter the DB2 database name in the
Override File Name
field. In the WHERE clause of the SELECT CURRENT_RESTART statement, you can specify this parameter only, or use the optional AND keyword to specify this parameter with the CONNAME or CONTYPE parameter.