Free CA DB2 Tools Technical Update

Mark Labby

Free CA DB2 Tools Technical Update
CA (Platinum) DB2 Tools Technical Update

Time: October 7th and 8th
Place: Camp Hill Corporate Center, Building 300, Large Auditorium
Cost: FREE

Reservations: [login to unmask email]
More details and directions will be posted at: http://www.db2parug.org

For those who are wondering what a "Technical Update" is, let me first say
what it is not:
IT IS NOT TO BE A SALES PITCH

For those who do not know me, I am a mainframe DBA with AES/PHEAA in
Harrisburg. I've been working with our CA Customer Advocate to try to get
more information and help in better utilizing the various mainframe DB2
Tools that AES/PHEAA already owns. This is being presented by CA Tech
Support people, not salesmen. I have specifically asked them to assume
that we have the tools and are familiar with them, but to show us how to
take advantage of some of the newer or more advanced functions that we may
not know or use everyday. We decided to open this to the Central PA DB2
user community so that other users of these tools can take advantage of
having a CA technician available and get some free training too.

The sessions will be split over 2 days so that one day concentrates on the
automation capabilities of the Database Analyzer and the second day on
performance monitoring tools. This gives you the opportunity to attend the
day(s) that most closely ties to the tools you use most often.

Some of the questions and topics I asked them to go over on day 1 are :

Database Analyzer -
Discuss models and symbolics usage
What are reasonable thresholds to be used for Large vs Medium systems to
determine when maintenance is required?
Can CA support provide Rules of Thumb to be used, or download a default
set of conditions based on the size of the system being supported?
Are the values in the defaults updated or current with newer releases of
DB2? Defaults that make sense for a small system running DB2v5 are not
necessarily reasonable for a large system running DB2v7 or v8. Would
this cause the tools to generate unnecessary maintenance tasks?
Show us what the tools can do using these models and thresholds to
eliminate manual intervention. This is opportunity to show where the
tools are earning their keep and saving the companies money.


For the second day, I asked them to concentrate on the CA performance
monitoring tools and general CA tool maintenance. Some items I asked for
are:

Plan Analyzer ?
Setting up Rules and how to maintain them.
What are reasonable thresholds to be used for Large vs Medium systems to
determine if a statement is a problem?
How do we setup the history capability and be able to compare an explain
against what the last bind was and is in the production explain table?
Can we flag major changes to the access paths?

Detector ?
Can the tool initiate alerts or easily identify problems?
What are the typical problems that people use the tool to look for?
What are the costs associated with some of the different collection
options?
How do we set the collection start and stop times so we can initiate
collecting with the beginning of batch cycle rather than a fixed time?

Subsystem Analyzer -
Can the tool initiate alerts or easily identify problems?
What are the typical problems that people use the tool to look for?

CA Tool maintenance
Best practices for retaining histories and other information that are in
the PTI tables.
What are the actual tables required by the tools? We have old versions
of some of the tables that were never dropped as part of the tool
upgrade but do not know which we can drop.
Is there an automatic way to clean-up compare strategy information kept
for objects that no longer exist?

---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Central Pennsylvania list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Central-PA.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Central PA List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm