Articles & Content

Archives

Advanced Design Considerations

Topic: DB2 for z/OS

Subtopic: 2014



During the design of a DB2 application, there is now a lot more to consider than just “what should the tables
look like”. We need to take into consideration where we should create indexes, and why. We might think
about partitioning for performance or for manageability. What about partitioned and non partitioned
indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option
to create Materialized Query Tables, but when would these be good to use?
This presentation steps through some of the new (and not so new) elements of DB2 database design and
highlights pros and cons of each
Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in
your case will always “depend” on circumstances, but hopefully this presentation will give you the
information you need to make informed choices



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.