Maximum number of records that can be stored

1,160 pts.
Tags:
AS/400 Data File
AS/400 database
AS/400 Records
AS/400 tables
What is the Maximum number of records that can be stored on an as400 data file.
ASKED: March 30, 2009  12:19 PM
UPDATED: March 30, 2009  5:58 PM

Answer Wiki

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

Hi,

<a href=”http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/index.jsp?topic=/dbp/rbafoappmax.htm&tocNode=toc:rzahg/i5os/4/6/0/2/5/”>Database file sizes.</a>

Regards,

Martin Gilbert.

//////////////////////////
Gilly’s link has it all —
When you create a Physical File the defaults are shown below. If you are expecting more you should create the file or change the file member initial size to a large number or perhapts to *NoMax.
Member size:
Initial number of records . . 10000 1-2147483646
Increment number of records . 1000 Number
Maximum increments . . . . . . 3 Number

Phil

Discuss This Question: 1  Reply

 
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
  • DanD
    The other file size limit is the access path limit of 1.8 TB. We actually have a file that sometimes runs up against this limit. I can only imagine this happening with a file created with SQL, probably in a data warehouse where the SQLPKG has created a view for most of the columns. For a DDS file with a physical key for a large number of columns, the query optimizer would probably choke trying to determine an access path. The only way to open the file is to limit the number of records or only open a range.
    2,865 pointsBadges:
    report

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