IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...

nbalajibe · Joined: 28 Nov 2006 Posts: 57 Location: India

Hi,

In one of our applications we are loading a DB from a flat file using COBOL program. As per the design one of the fields of a record is updated depending upon the value of the other, for example if the contents of the input file are

Code: 111 ABC N N
222 CDE N N
333 ABC Y N

As per the design while inserting the third record the first record should be updated as below

Code: 111 ABC N Y

But we are giving checkpoints for every 1000 records. Our doubt is whether we would be able to update the first record if the checkpoint is not issued (i.e. if it lies within the 1000 records)

Thanks in advance,
Balaji

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 410 Location: Wilmington, DE

How long have you estimated your "load" process will run? If this is truly a load process, then perhaps you should consider loading with the databases offline - not as a BMP.

Mahendran3784 · Joined: 04 May 2007 Posts: 10 Location: INDIA

Sandy- how does this helps in his case? actually his requirement is to update the uncommitted record.

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 410 Location: Wilmington, DE

Quite some time ago we spent quite a lot of time trying to help someone with a problem only to find out that we misunderstood the problem. Please read the following link and provide us with more info on the problem.

http://ibmmainframes.com/viewtopic.php?t=26538

nbalajibe · Joined: 28 Nov 2006 Posts: 57 Location: India

Approximately the load process is expected to run for around 3 hours. As Mahendran has said my question is regarding reading uncommitted data.

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 410 Location: Wilmington, DE

Let's take a step back - to the beginning of your posts. You are reading an IMS database - I think - not a DB2 table. In IMS, before you "update" - which is what I THINK you are doing - you must get and hold the record before issuing the REPL command. If the database is in existence, then you are not LOADING it - you are either insterting (ISRT) - if the segment on your flat file does not exist - or if it does exist, you are updating it. So, what is your definition of "uncommitted data"?

nbalajibe · Joined: 28 Nov 2006 Posts: 57 Location: India

Yes Sandy, it is a IMS database. We are inserting records and giving a checkpoint after 1000 records.
As you have said for updating a record we have to hold it. My doubt is whether we can hold a record (for updating) if no checkpoint was given after the insert call (this insert call is also given from the same job).

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 410 Location: Wilmington, DE

As I understand it, you are concerned that you get-hold a segment - add to your checkpoint counter - then issue your checkpoint before you update the segment? You could adjust your logic to NEVER issue a checkpoint until AFTER your update.