RRN Max in a DB2 file

5 pts.
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.


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).


Martin Gilbert.


For V5R4 — “Number of records contained in a file member – 4 294 967 294 records”. See Database file sizes. 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?


Discuss This Question: 4  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.
  • Sloopy
  • Cwc
    We ran into the DB2 limit about 6 months ago, but it is far more than 999,999,999. For V5R2, V5R3 and V5R4, the maximum number of records in a physical file member is 4,294,967,288. Since we needed to have more records in that file, we now have a multiple membered version of it, where each member is defined as an SQL partition, along with an SQL index that sees all the members at once. So, having more than a million records should not be a problem, unless you're on an older operating system, as I'm not sure how far back the 4.2 billion limit goes.
    4,290 pointsBadges:
  • bvining
    This is just a wild guess, but when I see a maximum value of 999,999,999 I immediately wonder if there's a RPG program involved with a variable (for instance RRN) defined as '9b 0' (that is, a 9-digit binary field). This definition cannot retain a value exceeding 999999999. If this is the case, then chaning the RPG field to '10i 0' (a 10-digit integer field) will get you past 999999999. As noted by others, 999999999 is not a DB2 limit. Bruce Vining
    7,070 pointsBadges:
  • aceofdelts

    Bruce has a good point - the 999,999,999 limit is likely due to something other than OS400.

    I'm used to OS400 limits being powers of 2, with 2**31-1 (so that 2.1 billion number) being quite common.

    2,550 pointsBadges:

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.

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


Share this item with your network: