Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS?

Project and Program: Information Management, Database

Tags: Proceedings, 2012, 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