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.
Click
Go
.
The
Database Row Test Output
window displays the generated restart tokens.
To copy the generated restart tokens, right-click in the
Database Row Test Output
window and click
Copy Output
.
You can use the generated restart tokens in the PWXPC restart token file.