RE: Commitment Control & Journalling

["McCallion, Martin" <MccalliM@xxxxxxxxxxxxxxxx>]

Sorry, I hit send before I was quite finished.

oludare said:

> 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?

Not necessarily, but your transactions will be much more secure if you
do.
 
> 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?

You'll get an exception message.
 
> What are the storage issues with journalling?

Objects take up space.  Disk is cheap.  The benefits vastly outweigh the
costs.
 
> When using interactive SQL, do you need to start journal for the file
used to start commitment control?

If you create an SQL collection and create tables with SQL, the
Journalling and CC is handled automatically.  Otherwise, I don't think
you have to start journalling to use interactive SQL; but again, you do
if you want to use commitment control.

Cheers,

Martin.

-                                                                     
Martin McCallion                 
Midas-Kapiti International
Work:  mccallim@midas-kapiti.com
Home: martin.mccallion@ukonline.co.uk

Apologies for the length of this sig, but company policy says:
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, 1 St George's Road, Wimbledon, London,
SW19 4DR, UK
Email: Postmaster@midas-kapiti.com Tel: +44 (0)208 879 1188 Fax: +44
(0)208 947 3373
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
+---