Journal segment or sequence number overflow potential

Products

• IDMS
• IDMS - Database

Issue/Introduction

Can either the journal segment or sequence numbers overflow and cause problems?

Environment

Release: All supported releases.

Resolution

It is theoretically possible that problems could occur from journal segment or sequence numbers overflowing, but they are so large it is highly unlikely to ever happen.

The journal segment number is a full word with a maximum value of 2,147,483,648. Even if the journal was offloaded once every five minutes, this would amount to 288 per day, or 105,192 per year. It would take over 20,000 years to overflow.

The journal sequence number is a double-word. The maximum possible value is 18,446,744,073,709,551,615. It would be impossible for the journal sequence number to reach this value.

Additional Information

Journaling Procedures