Baltimore / Washington DB2 Users Group
BWDB2UG z/OS Quarterly Meeting

When? Wednesday, September 11th, 2013, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50

Meeting Schedule:

  8:30 - 9:00 Registration
  9:00 - 10:15 Excelling at DB2 Monitoring and Reporting
  Robert Andresen, Principal Consultant, Presales, CA Technologies
  DB2 performance data can be loaded to DB2 tables by most or all of the DB2 monitoring products, both the subsystem monitors and SQL monitors. This topic shows how to extract performance metrics from these monitor tables, real time statistics tables and system catalog tables in order to generate performance reports and graphs in Excel.
  10:15 - 10:30 Coffee Break
  10:30 - 11:45 DB2 V10 - Temporal Tables
  Gary Furbish, Sr Principal Consultant, Technical Sales, CA Technologies
  This presentation will explore the measurement of time based data in DB2. The concepts of valid time and event time has been handled manually by application programmers since the advent of IT. DB2 programmers have used time, date, and timestamp values to store and manipulate past, present, and future values of data. With the release of DB2 for z/OS 10, IBM had introduced new capability into the DBMS to assist in this important function. This presentation will explore the concepts of temporal data and discuss the implementation, limitations, SQL changes, performance, and utility issues of System Period, Business Period and Bitemporal tables in DB2 10.
  11:45 - 12:45 Lunch
  12:45 - 2:00 Using DB2 9 native SQL stored procedures
  Robert Andresen, Principal Consultant, Presales, CA Technologies
  Native SQL stored procedures are new for DB2 9. They offer less overhead, are zIIP eligible and are easier to write, in short a win/win/win situation. We will cover the writing and definition of native SQL stored procedures and discuss the new capabilities for versioning these procedures. We will also cover the new SQLFORMAT option and new coding support for Extended GOTO and Nested compound statements. Next we will look at testing and debugging capabilities, including a sample Rexx exec to quickly verify the functionality of the new procedures quickly. Measuring and monitoring resource consumption will be covered. We will then cover deployment commands and migration from existing external  SQL procedures to the new native SQL procedures. Finally we will discuss documentation resources that to learn more about native SQL stored procedures.
  2:00 - 2:15 Break
  2:15 - 3:30 DB2 Stored procedure monitoring and analysis
  Charles Lewis, IBM
  Monitoring and tuning stored procedure workloads is now improved using new DB2 engine enhancements and IBM TivoliŽ OMEGAMON XE Performance Expert (OMPE) for DB2 for z/OS Extended Insight functionality. This session will cover end-to-end stored procedure analysis and discuss new OMPE Extended Insight for DB2 stored procedures. Statement-level performance analysis is covered for both stored procedure and non-nested applications. With a core understanding of DB2 engine-generated metrics and new OMPE exploitation, you can enable more granular monitoring and analysis of DB2 stored procedures.

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

Member Registrations
Non-Member Registrations

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240

All pre-registrations must be received by Friday, September 6th, 2013.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
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 in various capacities including being a zOS/CICS/DB2 Systems Programmer.. He is a co-author of the IBM Redbook: Linux on IBM @server zSeries and S/390: System Management. He has presented at IDUG, CMG, the IBM zOS Conference and LinuxWorld as well as many local and regional user groups. He holds a degree in Mathematics from the Illinois Institute of Technology. He is certified as an IBM Certified Database Administrator, DB2 9 for z/OS, an IBM Certified SOA Associate and also is ITIL Foundation Certified. At CA he has been supporting their suite of DB2 for z/OS tools for the past year. His areas of expertise include z/OS, DB2, CICS, UNIX/Linux, Windows, Websphere MQ and Networking.
Gary Furbish has over 30 years in IT experience. Over the years he has worked as a programmer, data analyst, database administrator, and systems programmer. He has supported mainframe database systems, such as DB2, IMS, and IDMS as well as distributed database systems such as Teradata and Oracle. He graduated with a BS degree in Business Administration and IT from Nova University in Ft Lauderdale, Fl.
Gary has supported IMS between 1979 and 1991 as a DBA and Systems Programmer. He has supported DB2 for Z/OS since 1991, as a DBA and Systems programmer at AT&T. He has continued focusing on DB2 as a consultant for CA and Platinum Technology since 1994. He has been a manager for the database field support organization at both companies. He currently supports DB2 and IMS products at CA, a job that includes technical sales, product training, technical consulting, installation and maintenance for clients worldwide.
Charles Lewisis a Sr. Certified DB2 Advisor for System z with IBM's East Region Client Technical team. He has broad experience as an application developer and database consultant with more than 35 years of IBM experience.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.