cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 Size Limitation

SOLVED
Go to solution
Glenn Joseph Andal
Frequent Advisor

DB2 Size Limitation

Hi There,

Can someone provide me the link/url regarding DB2 limitations when it comes to size (database, datafiles, tablespace)? I want to check if 8TB DB2 database maximum size limitation is really true. How can I address these limitations?

Hope someone can enlighten me on these concerns.

thanks,

Otep
4 REPLIES
VK2COT
Honored Contributor

Re: DB2 Size Limitation

Hello,

You should be able to find these values in the
SQL Limits appendix in the SQL Reference
manual for your version and platform.

And the answers depend on the page size limits, O/S version and so on.

The manuals for all but the oldest versions of DB2 are available on-line on the IBM website.

For example, DB2 v 9.5 is here:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp

Cheers,

VK2COT


VK2COT - Dusan Baljevic
VK2COT
Honored Contributor
Solution

Re: DB2 Size Limitation

I forgot to add:

Go to "Database Fundamentals" and then
expand menu "SQL"...

VK2COT
VK2COT - Dusan Baljevic
Hakki Aydin Ucar
Honored Contributor

Re: DB2 Size Limitation

Glenn Joseph Andal
Frequent Advisor

Re: DB2 Size Limitation

thank you for your prompt support