IBM Support

Maximum Binary Radix Index size increased to 16TB

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

[{"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"}}]

Document Information

Modified date:
03 May 2022

UID

ibm16579151