Db2 Logging Basics & Exploitation Beyond Recovery

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 Logging Basics & Exploitation Beyond Recovery

Session abstract: Explore why the LOG is one of the crucial components of Db2. Without the log there would be no way to recover corrupted objects, no way to “recover” failed SQL (delete, insert and update) among other tasks.

This presentation will cover some log basics and what the log holds in order to backout work as well as what’s in and NOT in the log. Finally, once you have an understanding of what’s in the log, we will go over some use cases how you can exploit the log beyond what it is really intended for.

Speaker bio: Steen Rasmussen is a Customer Services Consultant currently instrumental in the ongoing development and support of the Broadcom Db2 solutions. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 – like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.  Steen has been working with Db2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the Broadcom Db2 solutions which can help customers manage Db2 more efficiently. Besides providing support to the teams in the field as well as internal groups at Broadcom working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Since 2014 Steen has been an IBM Champion. Steen has also been the Broadcom liaison for IDUG NA since 2013.