Articles & Content

Archives

B01 - Eenie Meenie Miney Mo, With Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS?

Topic: 2013 NA

Subtopic: DB2 for z/OS



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.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.