Articles & Content

Archives

Ooooooey GUI! (Or, Take a Break From the Greenscreen) (G13)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2009



DATE: 2009-5-15 (09:15 AM - 10:15 AM)
SPEAKERS: Sally Mir (Wachovia Bank)

DBAs who work with DB2 for z/OS are generally very comfortable with and know their way around VTAM- and/or ISPF-based tools. 'Greenscreen' applications such as Omegamon and DB2PM/DB2PE are essential for monitoring performance and producing batch performance reports. EXPLAIN is an important tool for analyzing and predicting access paths for SQL. But wait! -- There is a new generation of desktop-based tools that can provide all of that information and more in multi-colored splendor! This presentation will discuss Wachovia's experience with implementing and using IBM's GUI tools in our environment, focusing mostly on the DB2PE Client. Once you see this, you will never go monochromatic again! (Well, almost never.)

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS -- What kind of name is that?- A bit about the pedigree of IBM's performance monitor and why it has "multiple personalities". When should I use which interface?

Why should I bother to install and use the DB2 PE Client? What's in it for me?- Let's walk through the many ways it can make the DBA's life a little easier. (And more colorful.)

What can the DB2PE Client show me about DB2Connect?- Some things you can only get from the client!

Never query the PLAN_TABLE again! Visual Explain is the answer!- Whether launched from within the DB2PE client, or run on its own, this is the future of EXPLAIN!

This is great! What other GUI tools are there out there for me?



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.