News
Abstract
With IBM i 7.5, database binary radix indexes are enhanced to be able to grow to a much larger maximum size.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Maximum Binary Radix Index size increased to 16TB
Prior to IBM i 7.5, the maximum size of a binary radix index is 1.7 TB.
With IBM i 7.5, the maximum size of a binary radix index is extended, up to 16 TB.
The page size of the index determines whether the new maximum size is 4 TB, 8 TB, or 16 TB.
The enhancement applies to both SQL Indexes and DDS-created Keyed Logical Files.
![Page size to Index size](/support/pages/system/files/inline-images/larger%20indexes%20table.jpg)
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
03 May 2022
UID
ibm16579151