AS/400(iSeries) Journal and Receiver

AS/400 Journal and Receiver is look like Oracle RedoLog, it contains the records details what we inserted/updated/deleted. It is necessary when we are going to mirroring or synchronization replications.

The following steps indicates you How do create a Journal and Receiver.

Step 1: Create a Receiver, Type CRTJRNRCV JRNRCV(QAFP/DBRSJ00001) AUT(*ALL)

Here QAFP is the Library name and DBRSJ00001 is the receiver name and Autherity for ALL.

Step 2: Create a Journal, Type

CRTJRN JRN(QAFP/DBRSJ) JRNRCV(QAFP/DBRSJ00001) AUT(*ALL)

Here QAFP is Library Name and DBRSJ is Journal Name.

Step 3: Change the Journal, Type

CHGJRN JRN(QAFP/DBRSJ) JRNRCV(*GEN)

Step 4: Activating a Journal

Here QAFCTUTDBF is a Physical Table name.

Regards,

Veera,

SystemEngineer,

ClimbInc, Nihombashi,Tokyo,

http://www.climb.co.jp