SQL Error: table space is too big

Asked By 310 points N/A Posted on -
qa-featured

I have an issue when creating a huge table space. Reports this 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).

Thank you

SHARE
Best Answer by Faisal Usman
Answered By 0 points N/A #87729

SQL Error: table space is too big

qa-featured

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!

Best Answer
Best Answer
Answered By 0 points N/A #87730

SQL Error: table space is too big

qa-featured

 You have a table, this table resides on some table space, the table space needs to have container to handle space, the table space needs to handle memory.

If you expect the table will be small and a lot of simple queries will be run on it, use the big number of small pages.
If you expect the table will be huge or very complex queries will be running on it, use big pages and relatively small number
The standard page size is 32 (can be 8, 16, 32, 64 depends on your system and on table space definition)
 

Answered By 0 points N/A #87731

SQL Error: table space is too big

qa-featured

Size of table is 16384. If you are using 32k page. Create a fat file table and put values in it.

Login/Register to Answer

Related Questions