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

Thursday, March 15, 2012: 8:00 AM-9:00 AM
Maple C (Omni Hotel CNN Center)
Speaker: John Iczkovits(IBM Corporation)
Handouts
  • Which Table (Space) Type and Page Size Shall I Choose for DB2 on z/OS? (985.2 kB)
  • 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.

    Share |




    See more of Project: Database
    See more of Program: Information Management