Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Size limit of DB2 table in V6R1 on IBM i

The upper limit of a DB2 table on V6R1 remains unchanged from V5R4 at 1.7 TB. However, SQL can be used to create larger partitioned tables with IBM's DB2 Multisystem product. Each partition in this arrangement can store 1.7 TB.

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 last published in December 2008

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.