Re: db2 file size limit

On Oct 2, 2018, at 5:35 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Did you look at the notes? I assume you have a primary key...how big is
the key?
3 This size will vary based on the field types of the file. Both the number
of bytes in a file member and the number of bytes in an access path must be
looked at when message CPF5272 is sent indicating that the maximum system
object size has been reached.

Number of records per access path:
When ACCPTHSIZ(*MAX1TB) is specified, use the following formula:

*1,356,416,600,000 *
12 + (.8 x key length)


Charles

On Tue, Oct 2, 2018 at 3:31 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

So just ran into the CPF5272 - Reason Code 3

The file in question has a size of 14814396416 but the file size limit is
supposed to be 1.7TB.

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/dbp/rbafoappmax.htm


So wondering what could have triggered this cpf5272 since we are not at
that size limit yet with this file?

any suggestions on what to consider?

Thanks

Jay
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD