Ask the Expert

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: