RRN Max

5 pts.
Tags:
DB2
DB2 capacity
RRN
Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Is this on an AS/400? If so which version of the OS are you using? We have V5R4 and that seems to allow 2.1 billion records (2,147,483,646).

Regards,

Martin Gilbert.

===============================================================

For V5R4 — “Number of records contained in a file member – 4 294 967 294 records”. See <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/dbp/rbafoappmax.htm”>Database file sizes</a>. But a PF may have 32767 members and total number of bytes in a file is approx 1.8 TB.

If any system is reaching a limit at 999,999,999 records, it may be from other limits. Is the size limited by the file description? Is the file indexed? If so, what are the key characteristics? What is the record size? Is the owner maxed out on space?

Most importantly, what message ID is sent when the limit is passed?

Tom

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following