Free CA (Platinum) DB2 Tools Training - FINAL CALL...

Mark Labby

Free CA (Platinum) DB2 Tools Training - FINAL CALL...
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]
Please get reservation requests in by Monday, October 4th.

More details and directions at: http://www.db2parug.org

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. Please
mention whether you want to attend one or both days.


*************************** AGENDA
******************************

Thursday, October 7, 2004
8:30 Introductions
Agenda
9:00 Unicenter Database Analyzer: The Big Picture

9:30 Unicenter Database Analyzer: Action Procedures. ?
Setting Thresholds

10:15 Break

10:30 Unicenter Database Analyzer: Action Procedures ? Generating JCL
?
Using model services and symbolic variables.

11:45-1:15 Lunch
Networking
Q/A with Gary

1:15 Automating Typical Tasks ? Action Procedures: Generating JCL ?
(continued from Morning Session)

2:30 Break

2:45 Unicenter Log Analyzer: log analysis tasks using on-line
screens

4:00 End day one

Friday, October 8, 2004
9:00 Unicenter Plan Analyzer: The "explain process". This session
will explore how to set up and use Plan Analyzer effectively. Topics will
include historical reporting and customizing Rules and Thresholds

10:15 Break

10:30 Unicenter Detector: Identifying Problem Plans and drilling down to
the root cause

11:45-1:15 Lunch
Networking
Q/A with Gary

1:15 Subsystem Analyzer

2:30 Break

2:45 CA Unicenter Database Management tool maintenance: Best Practices
and Q&A. This will be your opportunity to ask questions on any of the CA
Unicenter DB2 tools.

4:00 End day two.

Points of discussion the customer would like to address during the two
days:

Database Analyzer
* 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 models and thresholds to eliminate
manual intervention. This is the opportunity to show where the tools are
earning their keep and saving the companies money.

Log Analyzer
* Case study 1. The users come and say that something changed the data on
Table A, and the best they can determine is that the change occurred 3 days
ago, between noon and 6pm. Tablespaces are compressed, backed up as
shrlevel reference nightly at 5pm, and the object still exists without
change.
* Case study 2 ? Exactly the same situation as #1, except that Table A has
had new columns added to it the day before.
* Case study 3 - Exactly the same situation as #1, except that Table A has
had columns dropped the day before. How does it handle the table drop this
required?


Plan Analyzer
* Setting up Rules and how to maintain them.
* What are reasonable thresholds to be used for Large vs Medium systems to
determine when maintenance is required?
* 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 typical problems that people use the tool to look for?
* What are the costs associated with some of the different collection
options?
* How to 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 (to e-mail for example) for easily identify
problems?
* What are the typical problems that people use the tool to look for? (best
practices)


Unicenter RC Compare, RC Migrator, RC Update
* Best practices for retaining histories and other information that are in
the PTI tables.
* What are the actual tables required by the tools? Why are old versions
of tables never dropped as part of the tool upgrade? It is unknown what
tables can be eliminated.
* 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