Gunning Technology Solutions to Sponsor March 6, 2013 Central Pa DB2 User Group Meeting

We will be sponsoring this meeting http://www.idug.org/p/cm/ld/fid=185&ic11=12&commid=126 and I will be doing two presentations as follows:

1^st – Time Travel with DB2 Temporal Tables

Learn what types of temporal tables are available for DB2 LUW and when to use what type. See examples of how to define and use system period, application period and bi-temporal tables. Insert, update and delete rules will be discussed. New special registers and keywords will be presented.

2^nd – DB2 LUW Monitoring Essentials

Learn how to transition from snapshot based monitoring to the new monitoring infrastructure introduced in DB2 9.7 and DB2 10. Database Manager Configuration settings along with best practice settings will be discussed. Learn how to use the new table functions based on the new infrastructure. Use cases for the use of the MONREPORT reporting module will be presented. Understand the importance of interval based monitoring and identifying and tuning the Top 10 SQL using the new procedures.