By David Kuang and Ariana Bibiano.

Starting in function level 507 of Db2 13 for z/OS, Db2 for z/OS database administrators (DBAs) can specify greater than 64 GB primary and secondary allocation quantities in the CREATE TABLESPACE and ALTER TABLESPACE statements. The primary space allocation quantity (PRIQTY) is increased to support up to 1 TB, and the secondary space allocation quantity (SECQTY) is increased to support up to 200 GB.

Before the availability of this new capability, the primary space allocation quantity was capped at 64 GB, and the secondary space allocation quantity was capped at 4GB for table spaces. When Db2 allocates extents frequently to process large amounts of data it can suffer from possible performance degradation and potentially run out of extents altogether. With Db2 13 function level 507, this enhancement reduces the need to allocate extents frequently by allowing DBAs to take advantage of larger data set sizes and increased space allocation quantities for table spaces.

For more information about this new capability, see:

• Secondary space allocation for Db2 table spaces and indexes
• CREATE TABLESPACE
• ALTER TABLESPACE