|
Dimitri, I must disagree with your comment on Rollback and images. While it is true that before and after images are needed to perform a rollback, it is NOT necessary to specify *both in the strjrnpf command. You can specify *AFTER and any non-commitment updates will only record the after images. When you open a file for commitment control the before images are journaled regardless of the images parameter. The system protects itself. -Walden -----Original Message----- From: Dimitri Efimov [mailto:defimov@wiese.com.pe] Sent: Tuesday, March 20, 2001 11:20 AM To: MIDRANGE-L@midrange.com; RPG AS/400 UserGroup Subject: RE: Commitment Control & Journalling As far as I know: Do I need to start journalling for a physical file If a program that uses the file is coded for commitment control?[Dimitri Efimov] Yes Do I need to use commitment control within a program for a physical file that has been started for journalling?[Dimitri Efimov] 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?[Dimitri Efimov] U can't do this (the comand "endjrn" will failed) When using interactive SQL, do you need to start journal for the file used to start commitment control?[Dimitri Efimov] Yes Thanks, Dare [Dimitri Efimov] Pay attention to the parameter IMAGES, (U can't make ROLLBACK if IMAGES = *AFTER) +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.