Articles & Content
Topic: 2010 EMEA
Subtopic: DB2 for LUW
DATE: 2010-11-9 (14:15 - 15:15)
SPEAKERS: Martin Hubel (MHC Inc.)
While DB2 for LUW has been fairly easy to administer in the past, it became much easier as table functions were introduced in DB2 V8. With DB2 9, administrative views have improved the ease of use even further. Some of the most useful management information is only an SQL statement away.The new administrative views in DB2 9.7 are things that no DBA should miss. This presentation will show examples of how these features can save you and your organization time and money.
EXP. LEVEL: Beginner,Intermediate
Simplification of administration - Writing SQL for most administration and Performance queries
Types of administrative views - Performance - administration - many others
Performance - Snapshots - Application Information - Top dynamic SQL - activity Monitoring
administration Information - Configuration and environment - table and index Information - environment Information
Best practices - Getting What you want - using views and table functions in programs - creating a historical database - using ODBC To put Data into a spreadsheet
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.