Consultor Eletrônico



Kbase 18232: How to Implement Journaling on AS/400 files
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/16/2008
Status: Unverified

GOAL:

How to implement journaling on AS/400 files

FIX:

Using Progress/400 DataServer it is advisable to journal all or the most important files from your database. Not doing so may prevent Progress of rolling back uncommited transactions (for example, UNDO might not work).

1. Create a journal receiver object:

CRTJRNRCV JRNRCV(library/journal-rcv-name)

2. Create a journal object:

CRTJRN JRN(library/journal-name) JRNRCV(library/journal-rcv-name)

3. Start journaling a file:

STRJRNPF FILE(library/physical-file) JRN(library/journal-name)

This step has to be repeated for each physical file in the database, or use one command to add several files to the journal:

STRJRNPF FILE(library/physical-file1 library/physical-file2 library/physical-file3 ...) JRN(library/journal-name)