Re: db2 file size limit

Thanks for the info Sue. Looks very interesting.

I tried one of the examples - get the top 50 IFS files. Instead of names, I got *POINTER as a result. Any thoughts on this?

SELECT IFS_PATH_NAME, MAX(CURRENT_VALUE) AS MAX_BYTE_SIZE
FROM QSYS2.SYSLIMITS
WHERE LIMIT_ID = 18409
GROUP BY IFS_PATH_NAME
ORDER BY MAX_BYTE_SIZE DESC LIMIT 50

IFS_PATH_NAME MAX_BYTE_SIZE
*POINTER 53,261,196,461
*POINTER 15,178,272,440
*POINTER 345,339,247
*POINTER 220,200,960
*POINTER 219,152,384
*POINTER 123,210,992
*POINTER 28,003,522
*POINTER 27,165,027

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power


 

 


From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Sue Romano <slromano@xxxxxxxxxx>
Sent: Wednesday, October 3, 2018 9:43 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: db2 file size limit
 
This isn't necessarily an answer to the question, but I'd like to point
out some system limit information, including database limits, that is
available on every system.  Most users are not aware this exists. As the
system observes certain levels of limits being reached, the information is
logged into database tables.  All you need to do is query them to get
insight into the health of your system.  There are also certain critical
limits that send messages to qsysopr.  Read the details starting here:

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqserviceshealth.htm

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

Sue Romano
Db2 for IBM i Development