Re: DB2 table space too big problem

Bing Wu wrote:

> Hi Folks,
>
> I have a problem while creating a big table space. It reports error:
>
>
> SQL1139N The total size of the table space is too big
>
> Explanation: The size of the current table space is too big. The size of 
> a REGULAR table space is limited to 0xFFFFFF (16777215) pages while the 
> size of a TEMPORARY/LONG table space is limited to 2 tera bytes (2 TB).
>
> User Response: Check the diagnostic log file db2diag.log for details. 
> Reduce the size of the table space and correct the SQL statement.
>
> The table space is REGULAR with 4KB page. And I tried to create a 67GB 
> table space. It seems this already exceeds the size limit. I can use the 
> 32KB buffer pool but there is still a limit which is far below my 
> expected a few TB (while a TEMPORARY/LONG table space has a 2TB limit as 
> well). Is this the DB2 limit? Please advice.

This is documented in the SQL Reference, Volume 1, Appendix A - "SQL
Limits".

                                    4k      8k    16k    32k
                                  ----    ----   ----   ----
Maximum size of a regular DMS
table space (in gigabytes)          64     128    256    512

Maximum size of a long DMS table space (in terabytes):  2


The limits are *per partition*, so if you need to exceed these limits
you will need to add the data partitioning feature.


Good luck,






-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 100,000 Newsgroups - 19 Different Servers! =-----