MVSFORUMS.com

[YSMVS]

All,

In our site we were not executing checkpoints during the GHU calls. I thought that the buffers will be used only by Update calls when they do update and will be released after Checkpoint. But DBAs feel that our Buffer allocation is high and want to do checkpointing during the read calls. Is it necessary to issue Checkpoints during GHU calls also?

Thanks,
YSMVS.
_________________
Thanks,
YSMVS

[dbzTHEdinosauer]

I have no IMS experience, but IBM wrote both IMS and DB2, and there are pretty good about reliability. Some one authoritive will answer, but.... DB2 reads over CUSORs set locks that must be released by commits. I would expect that reads in IMS also do something similar. READ the literature or listen to your DBA, or don't.
_________________
Dick Brenholtz
American living in Varel, Germany

[nileshpalve]

When you do a GHU, its expected that a update/delete will follow. The data is hold (locked and loaded) in buffers.