PowerExchange Interfaces for PowerCenter

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

Back Next

Example of Generating Restart Tokens with DTLUAPPL

The registration on the ADD RSTTKN statement must exist. This registration must be associated with the instance name specified on the MOD APPL statement. You can use either ADD APPL or MOD APPL for a new application name. DTLUAPPL creates the application name if it does not exist when MOD APPL is used.

Select an application name and use it only with DTLUAPPL when generating restart tokens.

The following example generates restart tokens for source registration DB2DEMO1 with an application name of tokens
and then prints those restart tokens:

MOD APPL tokens DSN7 RSTTKN GENERATE
   ADD RSTTKN db2demo1
END APPL tokens
PRINT APPL tokens

The DTLUAPPL prints the generated tokens because the PRINT APPL statement is specified:

Application name=<tokens> Rsttkn=<1> Ainseq=<0> Preconfig=<N>
            FirstTkn =<>
            LastTkn   =<>
            CurrentTkn=<>
     Registration name=<db2demo1.1> tag=<DB2DSN7db2demo11>
                  Sequence=<000007248B9600000000000007248B9600000000>
                  Restart =<D2D1D4D34040000007248B0E00000000>

DTLUAPPL does not generate the complete restart1_token
value which is shown in the SEQUENCE token. You must be add the trailing four bytes (eight digits) of zeros manually when you update the restart token file. DTLUAPPL does generate the complete restart_token2
value in the Restart= token. You can copy this value to the restart token file.

You can use same restart tokens for multiple source tables in the restart token file to start extracting changes from the same point in the change stream. You only need to run DTLUAPPL multiple times if you want to start extracting changes from different locations in the change stream for different sources.

By using the tokens in this example, the restart token file looks as follows:

D1DSN7.db2demo1=000007248B9600000000000007248B960000000000000000
D1DSN7.db2demo1=D2D1D4D34040000007248B0E00000000

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Example of Generating Restart Tokens with DTLUAPPL

Example of Generating Restart Tokens with DTLUAPPL