DELAWARE VALLEY DB2 USERS GROUP

 

 

_____________________________________________________________________________

 

MEETING DATE:       Friday, June 13th 2008

 

LOCATION:                 Dave & Buster’s

STARTING TIME:      9:00 AM

REGISTRATION

and BREAKFAST:    8:30 AM - 9:00 AM

COST:                          ADVANCE REGISTRATION:       MEMBERS $20, NON-MEMBERS $30

                                       WALK IN REGISTRATION:           MEMBERS $50, NON-MEMBERS $60

_____________________________________________________________________________

 

AGENDA

 

09:00 - 09:15                           Opening Remarks

                                                Joe Carola, Chairperson DVDUG

 _____________________________________________________________________________

09:15-10:30                             Excelling at DB2 Monitoring and Reporting

Robert Andresen, CA, Inc.

_____________________________________________________________________________

10:30 - 10:45                           BREAK

_____________________________________________________________________________

10:45 – 12:00                          Exploiting the Log’s Many Possibilities

Steen Rasmussen, CA, Inc.

_____________________________________________________________________________

12:00 – 01:00                          LUNCH: Sponsored by CA

_____________________________________________________________________________

01:00 - 01:30                           Product Demo:

CA, Inc.

Monitoring and Tuning Application SQL in today’s Dynamic World

_____________________________________________________________________________

01:30 - 01:45                           BREAK

_____________________________________________________________________________

01:45 - 03:30                           The Magic of REBIND in V8

Bonnie Baker, Bonnie Baker Corporation

_____________________________________________________________________________

 

The DELAWARE VALLEY DB2 USERS GROUP reserves the right to change the agenda without notice.

 

Visit our Web Site for the latest information @ www.dvdug.org

Mark your calendars for the next meeting:  November 07, 2008

 

Casual Dress

Message from the chair:

 

Our June meeting is being sponsored by CA and Compuware.  CA will be bringing two experienced speakers in Steen Rasmussen and Robert Andresen, in addition to providing a product demo. 

 

Compuware is sponsoring our keynote speaker for this meeting - the always popular Bonnie Baker.  Bonnie always proves to be not only informative and interesting – but also quite entertaining. 

 

Now that we have “gone green” and eliminated hardcopies of our Newsletter, we would like to hear feedback that you, our membership.  This move reduces our expenses by eliminating printing and mailing costs.  How is it working out for you?

 

Please make pans to join us for an informative day, and please pass this information on to co-workers and fellow DBAs.  We are in great need of new members and remember, PRE-REGISTRATION IS HIGHLY ENCOURAGED!!  It helps the board to better plan for handouts and food, so please try to pre-register for our sessions.  See you at Dave & Busters!

 

Joe Carola

 

 

 

 

Meeting Overview

 

Excelling at DB2 Monitoring and Reporting

Robert Andresen, CA, Inc.

 

If you are running DB2 on z/OS you almost certainly have one of the DB2 monitors on the market. That product lets you view, report on and set exception thresholds on performance metrics. Thousands of them.

 

How can we figure out which metrics are important and what values are acceptable? How can we understand the metrics and their values that ought to drive exception notifications? Ideally, we would use an inexpensive ad hoc reporting tool.

 

All or most vendors allow accounting and statistics data to be loaded into DB2 tables. We can pick some of this data out of DB2 and load it into spreadsheets. Spreadsheet software is readily available, easy to use and can create graphs more efficiently than the mainframe.

 

We will discuss identifying periods of peak resource contention and ranking the relative business importance of each application. Once that is done we can extract statistics rows into spreadsheets to show usage of critical resources during peak times. Statistics rows may also be extracted for capacity planning spreadsheets, showing the growth of resources used over time. We will also look at extracting accounting rows to report on which applications are consuming the critical resources.

 

We will look at building an inventory of tables and column names used by your product to store the accounting and statistics data. This way we are not tied to any specific DB2 monitor.

 

Next we will look at a Rexx exec that will generate SELECT statements using an edited copy of this inventory, allowing us to focus only on the columns we want loaded into our spreadsheet. Spreadsheets limit the number of rows and columns, but human comprehension is even more limiting.  Each of our spreadsheets will be focused on a related group of metrics over a meaningful time frame.

 

Finally we will look at loading our SELECT results into the spreadsheet of you choice. From here we will cover summarization, subtotals and graphs. We will also discuss strategies for saving the data and/or the spreadsheets for historical comparisons.

Speaker:

Robert Andresen - A Senior Consultant with CA, Robert started out in data processing in 1976 as a mainframe COBOL and BAL programmer at Continental Bank.  He has been a mainframe systems programmer for several service bureaus and then specialized in systems performance monitoring for Boole & Babbage and several other software vendors.  Robert has presented various computer measurement and tuning topics at the CMG conference, LinuxWorld and the z/OS Technical Conference.  He has also published performance articles for CMG and Network Magazine and wrote several chapters of the IBM Redbook on Linux.  Robert graduated from the Illinois Institute of Technology in 1976. 

 

In his current position, Robert presents the CA DB2 for z/OS solutions to clients and prospects, demonstrating their value both in technical and business terms. He also installs and helps customers implement these solutions as well as providing training on how to be successful with these products.  He writes and presents technical presentations on DB2 topics for user groups and clients.  Robert also works with CA DB2 Product Management, Development and Support to assist clients with product issues.

 

Exploiting the Log’s Many Possibilities Steen Rasmussen, CA, Inc.

 

The log is a vital part of DB2 and DB2 recovery.

However - once you start to exploit the content and what the log holds, many day to day tasks can be changed for the better for everyone. This presentation will look into real life scenarios how DB2 sites are squeezing the most out of the log to manage audit control, application recovery, change propagation, application QA and assisting in disaster scenarios.

 

Speaker:

Steen Rasmussen - is a Principal Technical Specialist currently instrumental in the ongoing development and support of the CA DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 - like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for DB2 GUIDE SHARE Nordic Region.  In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for more than 20 years starting with DB2 Release 1.0 and is currently instrumental in the ongoing development and support of CA DB2 tools and features.  Besides providing support for the teams in the field as well as internal groups working with DB2, Steen also is a frequent speaker at IDUG in North America and Europe as well as local DB2 User Groups around the world. 

The Magic of REBIND in V8            

Bonnie Baker, Bonnie Baker Corporation

 

This session covers optimizer changes in V8 that magically solve performance problems during REBIND.  It also covers coding techniques that are no longer needed to overcome prior problems. This presentation provides a look at the performance impact of DB2 9 for z/OS from the system performance viewpoint, including catalog migration, synergy with new hardware, virtual and real storage, utility, index compression, and general transaction CPU usage trend.

Speaker:

Bonnie Baker is a consultant and educator specializing in applications performance issues on the DB2 OS/390 and z/OS platforms. She is an IBM DB2 Gold Consultant, a five-time winner of the IDUG Overall Best Speaker award, and a member of the IDUG Speakers' Hall of Fame. She is best known for her series of seminars entitled "Things I Wish They'd Told Me 8 Years Ago."