Can anybody tell why Journalling is compulsary before
Commitment Control?

Answers were Sorted based on User's Feedback



Can anybody tell why Journalling is compulsary before Commitment Control?..

Answer / syam

Yes, journalling is compulsary.
Whatever changes in Physical file it is storing in journal
file. If you Rollback, old data taking from journal file.

Is This Answer Correct ?    12 Yes 0 No

Can anybody tell why Journalling is compulsary before Commitment Control?..

Answer / samul

Commitment ctrl is use to save /rollback the group of
chages and Journalling is use to save the changed records
in Jorunal reciver.



hope you get a proper answer!!

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More DB400 Interview Questions

Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  


how to update physical files using normal logical file

4 Answers  


Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,


I had created one physical file tell me command to enter data in to?

1 Answers  






How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


how to restrict upon adding the data for field reference file in DB400

1 Answers  


one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


How to know the particular record in pf with out reading?

0 Answers  


What is the batch job?

0 Answers  


Categories