Re: db2 file size limit

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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