madhuroyus Beginner
Joined: 09 Jan 2006 Posts: 45 Topics: 14 Location: Bangalore
|
Posted: Fri Nov 24, 2006 1:32 am Post subject: Why CICS not provided file opening and close options? |
|
|
Hi All,
I have two interview questions. Please share your views on this.
1) Why CICS is not provided file opening and closing?
I explained that when the CICS region ups, it will open all the files and by using the CEMT I FILE can change the status of the file. More than one transaction may be using the same file, so if one program is closed a file which is using by another program in the other transaction will cause a seviour problem.
But still that guy is not satisfied with my explanation.
2)Suppose I have 5 million records in a file and thru a batch program I am updating them in to a db2 table. Can you tell me for how many records you will put a commit. Suppose you are doing a commit after 10000 records or may be after 1L records, ofcourse may be at some X number of records. How you will decide this commit? Based on what are all the constraints?
I explained may be it depends on the buffer pool(how much memory it can hold maximum) available to decide the commit point.
Here also he is not satisfied.
Can any one share your views on this?
Thanks
Madhu _________________ Self confidence is something that says U will do it, when the rest of the world has exactly opposite view. |
|