The next meeting of the LAADB2UG will be on Thursday, Sept 4th, 2008.

Robert Andresen will be our featured speaker.

We will be meeting at the CA offices, 6100 Center Dr. Suite 700 Los
Angeles 90045. The CA Office is just off the 405 and Howard Hughes
drive by the Bridges Mall in the Pepperdine building.

Park in the parking lot near the building and CA will pay for parking.

Meeting Schedule

08:30 - Doors open for coffee and refreshments.
08:45 - IBM comments and announcements.
09:00 - Robert Andresen on "Excelling at DB2 Monitoring and Reporting"

Robert Andresen is a Technology Specialist with CA. He has been
working in performance management and monitoring for several software
companies since 1997 and has been supporting mainframe systems since
1976. He is a co-author of the IBM Redbook: Linux on IBM @server
zSeries and S/390: System Management. He holds a degree in Mathematics
from the Illinois Institute of Technology. At CA he supports their
suite of DB2 for z/OS tools. His areas of expertise include z/OS, DB2,
Oracle, CICS, UNIX/Linux, Windows, Websphere MQ and Networking...


Excelling at DB2 Monitoring and Reporting

Most DB2 monitors can load accounting and statistics data into DB2
tables. We can use spreadsheets as an adhoc reporting against this
data. Statistics rows show usage of critical resources during peak
times and accounting rows show which applications are consuming the
critical resources.

We will build an inventory of tables and column names and generate
SELECT statements from a Rexx exec. Each of our spreadsheets will be
focused on a related group of metrics over a meaningful time frame. We
will then subtotal, summarize and graph the data, building DB2
performance dashboards.