RE: How do I set up journaling

Tom -

Here is how I do it on my system.....

Note: Steps to enable remote Journaling are included too....

Kenneth

Journaling - Setup

1.) Create a message queue to receive journal messages:

CRTMSGQ MSGQ(QGPL/LAWJRN) TEXT('Lawson journal messages')

2.) Create a journal receiver in the proper journal receiver library:
 CRTJRNRCV  JRNRCV(JRNRCVLAW/LAW2JR0001) THRESHOLD(500000)

3.) Create a journal referencing the receiver just created:

CRTJRN JRN(LAWP1FILES/LAWP1JRN) JRNRCV(JRNRCVLAW/LAW2JR0001)
MSGQ(QGPL/LAWJRN) MNGRCV(*SYSTEM) DLTRCV(*YES) RCVSIZOPT(*RMVINTENT
*MAXOPT1)

4.) Create a remote journal:

ADDRMTJRN RDB(S17) SRCJRN(LAWP1FILES/LAWP1JRN) TGTJRN(S02RMTJRN/LAWP1JRN)
 RMTRCVLIB(S02RMTJRN) TEXT('Remote journal for LAWP1FILES')

5.) Start journaling for all files in the library (Note: This command is a
TAATOOL command):

STRJRNLIB LIB(LAWP1FILES) JRN(LAWP1FILES/LAWP1JRN) STRJRNAP(*NO)
IMAGES(*AFTER) OMTJRNE(*OPNCLO)

Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist
AS/400e Professional System Administrator
NW Natural (Gas Services)
keg@nwnatural.com
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************

-----Original Message-----
From: tomh@simas.com [mailto:tomh@simas.com]
Sent: Wednesday, November 28, 2001 12:57 PM
To: midrange-l@midrange.com
Subject: How do I set up journaling


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I need to set up journaling on a couple of databases.  I've never dealt
with that before, so could someone give me a step-by-step on how to start
journaling on them?

Tom Hightower
Solutions, Inc
http://www.simas.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.