//////////////////////////
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

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

Processing your response...

Discuss This Question: 1 &nbspReply

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

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

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.

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

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