Question:
I am having an issue with full journals. I believe there was a program that may have been looping and not doing commits. The transaction was cancelled and rolled out, but my journals are still about 80% full. How can I free up the space in the journals?
Answer:
What happens is that the long running job rolled out. The images for a finished or recovered transaction remain on the disk journals until the next Archive Journal is run. During the condense phase of the Archive, IDMS determines which transactions have completed, or recovered, and removes those transaction from the disk journal file, since they are no longer needed for automatic recovery. So, until the next Archive Journal is run, those images will still be on the disk journals. Once the Archive Journal is run after that, the condense phase of the Archive Journal utility will remove the images automatic recovery no longer needs, and will free up that space in the disk journal.