Topic: 2011 NA
Subtopic: DB2 for LUW
DATE: 2011-5-4 (11:00 AM - 12:00 PM)
SPEAKERS: Matt Huras (CA Technologies)
We all would agree that the DB2 logging facility is a vital part of DB2 andDB2 recovery. It produces information rich data which can also be exploited in many functions other than that hoped "Never" for recovery. In this Technical presentation I intend to cover the Features and functions of the CA LOG ANALYZER product and their many uses in working with DB2 Logging Datain Recovery to Replication Auditing to AnalysisTopics Covered1) The Analysis and management of DB2 active and archive log data sets, image copies, and bootstrap data sets (BSDS).2) Generating complete DB2 recovery information in an easy-to-read format using detailed audit and exception reports.3) Generating SQL UNDO/REDO DataThe UNDO feature can generate SQL to undo unacceptable changes to data.The REDO feature lets you redo changes on multiple subsystems.This is a fast and easy way to propagate changes from one DB2 subsystem to another DB2 subsystem or to another relational database management system or Datawarehouse system.4) The comprehensive reporting facilities to make log analysis easy. 5) Review the Data wizards available for generating reports easily. 6) look indepth at using CA LOG ANALYZER as a tool to aid with your Auditing requirements using the The SMF Audit Trace Reporting facility
EXP. LEVEL: Beginner
How to quickly and easily Generate Indepth Reports on DB2 Logging Activity from Database down to a Single Table, with the full Flexibilitiy of Masking and Filtering
How to Replicate DB2 Data easily between Systems to provide Data for Testing and Development needs, including providing Data for External Data Warehousing Systems
Recovering Lost Objects and Data after that Fateful cry "Oops i dropped the wrong object"
Using DB2 Logging Data to produce detailed Auditing Information on the various Activies and Tasks running on the DB2 system
Understanding how DB2 Logging Data can provide an invaluable additional source of performance information when looking to fine tune your systems.
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.