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 light-hearted view of one row’s life to emphasize some of the internals of DB2 on the z/OS platform.

Explaining the lifecycle of a row in a Db2 table, from insertion to deletion, via updates, alters and reorgs.