Articles & Content

Archives

What About Structure? DB2 V9 Universal Table Spaces, Tables, Indexes Compression and Row Formats. (C09)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Judy H. Nall (Computer Business International, Inc.)

Changes to DDL syntax that effect our physical data definitions can be misunderstood as to there effects on our day-to-day data base environment.We will discuss the DDL changes, the physical effects of those changes in our structures and the implications in DB2 V9.

EXP. LEVEL: Advanced

OBJECTIVES:

Universal Table Spaces, a physical look and how they function. Just what are the differences, how will I benefit and is there anything I should I worry about?

No more Simple Tables, so now what?Getting to the physical details of what tables look like now.

Indexes, compression and changes we need to know.Understand the physical look and the implications of compression on the system.

Row formats, what changed and how will that benefit me? Structure is the key here, a look at physical row formats and effects.

Structure suggestions, rules of thumb for use and summary of the physical changes we talked about in V9.



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.