Articles & Content


A Row's Life (B04)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-12 (02:45 PM - 03:45 PM)
SPEAKERS: Ken McDonald (BMC Software)

Rows in a DB2 z/OS database get mauled and moved and wholly and partially duplicated. There are different ways to find them and different surroundings. And most DBAs find they need to understand these transformations thoroughly to manage performance and recovery and even security. In this presentation, we take a lighthearted view of one row’s life to emphasize some of the internals of DB2 on the z/Os platform including impact of basic DML, Utility implications, and how various DB2 features (e.g. compression) impact the appearance of the row.

EXP. LEVEL: Beginner,Intermediate


Have a high level understanding of the physical incarnation of data within a DB2 tablespace, log, and other resources.

See the impact of some data definition choices on the physical structure of a row.

See some differences DB2 Version 9 will introduce to row format and versioning.

Understand how the artifacts discussed can be used for recovery and other purposes.

Piqued interest in learning more details about physical page layout and logging within DB2.

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.