SQL Error: table space is too big

Asked By Ali Ahamad 310 points N/A Posted on - 04/23/2011

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

• Status: Open
• Question Views: 1069
• Answer Count: 3
• Vote Up 31 Vote Down

• Answer Accepted: Yes
• Question Category: DB2

Best Answer by Faisal Usman

Go To Solution

Answered By Asad Raheem 0 points N/A #87729

SQL Error: table space is too big

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!

About Asad Raheem

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/23/2011
• Question Category: DB2

Best Answer

Best Answer

Answered By Faisal Usman 0 points N/A #87730

SQL Error: table space is too big

 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)
 

About Faisal Usman

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/24/2011
• Question Category: DB2

Answered By Asad Raheem 0 points N/A #87731

SQL Error: table space is too big

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

About Asad Raheem

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/25/2011
• Question Category: DB2