SETJRNPOS - Set journal position

Use this command to position CDC Replication to start mirroring at a specific journal entry.

You can enter the specific journal entry directly or it can be determined by the command if you enter a date and time.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword	Description	Choices	Notes
JOURNAL	Journal name	`Qualified object name`	Required
	Qualifier 1: Journal name	`Name`
	Qualifier 2: Library	`Name`
TARGET	Subscription name	`Name`	Required
JRNRCVNME	Journal receiver name	`Qualified object name`	Required
	Qualifier 1: Journal name	`Name`
	Qualifier 2: Library	`Name`
STRDTE	Start date	`Date`	Required
STRTIM	Start time	`Time`	Required
STRSEQNBR	Sequence number	`Number`	Required
OPEN	Open transaction	NO, YES	Required

Journal name (JOURNAL)

The name of the journal associated with the journal receiver that has its position changed by this command.

This is a required parameter.

Qualifier 1: Journal name

Name: Specifies the name of the journal associated with the journal receiver that has its position changed by this command.

Qualifier 2: Library

Name: The name of the library where the journal resides

Subscription name (TARGET)

Specifies the name of the subscription.

This is a required parameter.

Name: Specify the name of a subscription. This must be the same name defined in Management Console.

Journal receiver name (JRNRCVNME)

The name of the first or starting journal receiver to be searched for the specified sequence number or date and time. The library where the journal receiver resides must be identified. Prefix the journal receiver with the name of the library where the journal receiver is located.

This is a required parameter.

Qualifier 1: Journal name

Name: Specifies the name of the journal receiver.

Qualifier 2: Library

Name: Specifies the name of the library where the journal receiver resides

Start date (STRDTE)

The date of the journal entry that CDC Replication processes first when mirroring is started.

This is a required parameter.

Date: Specifies the date.; The date must be specified in the format 'MMDDYYYY'. For example, '09302012'.

Start time (STRTIM)

The time of the journal entry that CDC Replication processes first when mirroring is started.

This is a required parameter.

Time: Specifies the time of the journal entry.; The time must be specified in the format 'HHMMSS'. For example, '184304'.

Sequence number (STRSEQNBR)

The sequence number that CDC Replication processes first when mirroring is started.

This is a required parameter.

Number: Species the sequence number

Open transaction (OPEN)

Specifies if the last open transaction in the product bookmarks will be preserved.

This is a required parameter.

*NO: Does not preserve the last open transaction sequence number; overwrites it with the position specified in this command.; This is the default setting.
*YES: Preserves the last open transaction sequence number in the product bookmarks.

Result

Relevant messages are produced to the job log.

Examples

SETJRNPOS JOURNAL(D_MIRROR/DMCJRN)
TARGET(SUB1) JRNRCVNME(D_MIRROR/DMCRCV004) STRDTE('07052012') STRTIM('141200')
OPEN(*NO)

The search for the specified entry starts with journal receiver D_MIRROR/DMCRCV004 associated with journal D_MIRROR/DMCJRN. Positions CDC Replication to start mirroring at the entry in a journal receiver that was time-stamped on July 5, 2012 at 2:12 PM. All the bookmarks are reset.

SETJRNPOS
JOURNAL(D_MIRROR/DMCJRN) TARGET(SUB2) JRNRCVNME(D_MIRROR/DMCRCV006)
STRSEQNBR(127855)

The search for the specified entry starts with journal receiver D_MIRROR/DMCRCV006 associated with journal D_MIRROR/DMCJRN. Positions CDC Replication to start mirroring at the entry that has a sequence number of 127855.