Articles & Content

Archives

A Row's Life (B11)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-15 (14:45 - 15:45)
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

OBJECTIVES:

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.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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