Size limit of DB2 table in V6R1 on IBM i

The upper limitation of a dtabase table is 1.7 TB in the V5R4 version. How about the limitation of database table in V6R1?
The limit in V6R1 is unchanged. If you're approaching this maximum limit for a table, you can consider using SQL partitioned tables -- each partition in the table can store up to 1.7 TB. Partitioned tables do require the purchase of the DB2 Multisystem product. They also require planning and testing before moving them into a production environment. IBM has a Table Partitioning white paper to help with the planning process.

This was first published in December 2008

Back to top