Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS?
Project and Program: Information Management
, SHARE in Atlanta 2012
Choosing the correct DB2 table (Space) type is very confusing. Should I go with a segmented table space, a UTS (if so, a PBG or PBR), HASH, or maybe good old classic partitioned? How about the page size? I now have a choice of 4K, 8K, 16K, or 32K for my table space and/or index. Should I choose a multi or single table option? Should I compress the object? Choosing the data's correct type and size the first time is essential to avoid costly outages. Come learn about best practices in choosing the correct types and settings for your data.
John Iczkovits, IBM Corporation
Back to Proceedings File Library