How many rows are in your table?
The maximum number of rows a file can have is 4.2 Billion of Records
(4,294,967,288)
A file/table or partition can not have more rows even though the 1.7
TeraBytes are not yet reached.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Jay Vaughn
Sent: Dienstag, 2. Oktober 2018 22:17
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: db2 file size limit
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
midrange.com
