Maximum rows a table can occupy

suma_infy · New User Joined: 03 Oct 2008 Posts: 25 Location: chennai

Hi All,

I need to find out the maximum rows a table can occupy/maximum size of the table. please provide your suggestions to find out the same.

Thanks,
Suma

dbzTHEdinosauer · Posted: Fri Nov 19, 2010 3:24 pm

look in the DB2 SQL reference for your version of db2.
there is a 'DB2 LIMITS' section, which you can find with the search engine for the html or pdf.

Rahul Agrawal · New User Joined: 19 Jul 2010 Posts: 9 Location: Noida

Please refer to the link below:

www.ibmmainframes.com/about39361.html

Hope this helps.

enrico-sorichetti · Posted: Sat Nov 20, 2010 2:11 pm

just being picky

the link would have been perfect if the TS had wanted to know how many rows could a table contain
related to the allocation specifications

but really the question as posed is just a chatting issue with no practical use
or a technically correct but useless answer could be... depends on how much dasd space You have available

for a deeper insight ( for example ) an interesting reading could be
www.redbooks.ibm.com/abstracts/sg247674.html?Open
( about managing 50 tb databases )