Articles & Content

Archives

Administering Your Database Using SQL (D08)

Topic: 2007 EU

Subtopic: DB2 for LUW



DATE: 2007-11-6 (16:45 - 17:45)
SPEAKERS: Jessica Escott (IBM Toronto Laboratory)

Prior to DB2 9, it was difficult to administer DB2 through anything but the command line which restricted administration in an SOA environment. Come learn about the new DB2 9 SQL administrative API (procedures, UDFs, views, etc). See how easy it is to build portable applications designed to operate under a single database connection to administer DB2.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Learn new monitoring views and functions to ease multi-partition monitoring

Learn new stored procedure capabilities to allow for most administrative function currently run from CLP

Learn SQL Admin API-only capabilities, function not available from CLP or other C APIs

Review application examples using the SQL Admin API

Review web services examples using SQL Admin API



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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.