Articles & Content

Archives

A Day in the life of a DB2 for z/OS Page (B11)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Randy Ebersole (IBM)

This presentation will show how DB2 page formatting changes during SQL processing. SQL processing that adds, deletes, or updates data impacts how DB2 stores the information. We will walk through various scenarios to understand the detail of DB2 page formatting. With this improved understanding of the DB2 page internals, we'll show how this knowledge will translate into performance analysis and object definition setup. Various scenarios will be used to show how object definition can impact data storage within a tablespace.

EXP. LEVEL: Intermediate

OBJECTIVES:

DB2 Page Details

Adding Data to the Page

Reorg Impact

Impact of PCTFREE And MAXROWS

Impact of Page Size



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.