RE: Commitment Control & Journalling

 
-----Original Message-----
From: oludare [mailto:oludare@ix.netcom.com]
Sent: Tuesday, March 20, 2001 2:49 PM
To: AS/400 Midrange Usergroup; RPG AS/400 UserGroup
Subject: Commitment Control & Journalling


Hi Guys,
 
I need a full understanding of Commitment control and Journalling.
 
I know that you need journal receivers before you can create journals.  I
also know that you need journals created in a library before you can start
Journalling physical files.
 
Here are my questions:
 
 
Do I need to start journalling for a physical file If a program that uses
the file is coded for commitment control?   YES 
 
Do I need to use commitment control within a program for a physical file
that has been started for journalling?   NO 
 
What are the consequences when a program that does commitment control on a
physical file is executed and the physical file journalling was ended prior
to running the program?   The file open will fail. 
 
What are the storage issues with journalling?   The journal receivers
require maintenance, they can grow large; this can easily be automated. J on
files will increase the activity of your disk arms too.
 
When using interactive SQL, do you need to start journal for the file used
to start commitment control?  ??? 
 
Thanks,
 
Dare 
 
Files can be journalled quite independently of CC; but CC NEEDS journalling.

 
Kind regards, 
Jeff Bull. 
Senior Support Consultant 
Certified IBM AS/400 System Administrator 
Midas Kapiti International Ltd 

Tel:    44 (0) 175 370 8224 
Fax:    44 (0) 175 357 0233 
Mailto:Jeff.Bull@Midas-Kapiti.Com <mailto:Jeff.Bull@Midas-Kapiti.Com>   <<
== Replies to 
The views and opinions expressed in this e-mail are the senders own and do
not necessarily represent the views and opinions of Misys Plc.

This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named recipient
of this email then you should not copy it or use it for any purpose, nor
disclose its contents to any other person.  You should contact Midas-Kapiti
International as shown below so that we can take appropriate action at no
cost to yourself.

Midas-Kapiti International Ltd, Key West, 53-61 Windsor Road, Slough,
Berkshire, SL1 2DW, England 
Email: Postmaster@midas-kapiti.com Tel: (44) 1753 573244 Fax: (44) 1753
570233 
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479 



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---