Articles & Content


Managing DB2 With The New Administrative Views and Functions (D06)

Topic: DB2 for LUW

Subtopic: 2010

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

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.