GSAM file shows more records after abend.

[Shriram]

Hi
Iam running an IMS DB program with check-point restart logic in it. The Job abended after 588th record. Check-point is issued after 100 records. Output file is a GSAM file. I was expecting that my output file to have only 500 records but I don't know why it shows 588 records! Why this happnes? Why all the records are written to the output and not just 500?

[nicc]

Perhaps your coding is wrong.

[Anuj Dhawan]

"It's working as designed"!

With Check-point restart all the records which are processed successfully will be written to the output however, when you restart the program will start processing from 501[sup]st[/sup] record.

[Shriram]

But then how about those 88 records?? What will happen to them?

[Anuj Dhawan]

They are processed again from the input and written to output. In the case of abend you are not sure about the integrity of the data and you restart from the last successful execution even if it means processing some records again, but you know all is working as you intended it to.

[enrico-sorichetti]

GSAM files will be in an unpredictable state until ALL the IMS recovery actions have been done.

[Shriram]

GSAM files will be in an unpredictable state until ALL the IMS recovery actions have been done.

You mean this is the rason that i see those extra records?

[enrico-sorichetti]

You mean this is the rason that i see those extra records?

yes.

[Shriram]

Now because the abend has happened so the GSAM is in unpredictable state. But then such unpredictable state does not come that's why we write check-point restart logic. If it's not being taken care then what's the benefit of the check-point restart in the program?

[enrico-sorichetti]

If it's not being taken care

IMS has all the things in place to provide data integrity and consistency across failures

If You do nothing DBs state will be unpredictable

If, on the other side,
You , Your operations, Your support, Your whatever f****** name You call it do what the IBM manuals tell to do

the data bases will be updated only once, the input GSAM DB records will be processed only once, the output GSAM DB will not contain any duplicate records.


it is almost time to lock the topic

[Shriram]

Thanks!