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

When? Wednesday, September 10th, 2014, 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 DB2 11 Expanded RBA/LRSN – Does this bit make my tail look big?
  Jim Dee, BMC Software
 
 

DB2 has had a 6 byte RBA since the beginning and a 6 byte LRSN since DB2 Version 4. IBM is introducing the ability to optionally expand the RBA and LRSN to 10 bytes in DB2 11. This change will have fairly far reaching implications on many DB2 structures that have carried a 6 byte RBA since the beginning over 30 years ago. This presentation will raise some of those implications by discussing where RBA values currently reside in the DB2 universe. Given a DB2 11 GA announcement, more details of new formats will be provided. The source of the presentation title? Every page on a DB2 object, both table and index spaces, ends in a structure called PGTAIL. In the expanded world, this becomes PGBIGTAIL.

 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 DB2 V10 Questions: To Include or Not Include? Where did all the LOBs go?
  Chad Reiber, BMC Software
 
  Is it time to look at implementing DB2 V10 features. Most times we have great plans when we put together the business case to upgrade to the new release of DB2. So much effort is put into the conversion and validation – those new features fall off the project plan and soon become forgotten. This presentation will look at two new features of DB2 V10 which can provide improved performance to your SQL Queries.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 BMC Workbench for DB2 – Secure self-service tooling for DB2 for z/OS
  Jim Kurtz, BMC Software
 
 

As our typical mainframe workforce starts to look towards retirement, there is becoming a need for more functionally rich interfaces than the historical ISPF screens. BMC Workbench for DB2 brings the power of a graphical interface to the world of DB2 tools. Running in a web browser, thus obviating the need for ANY local installation of software, BMC Workbench for DB2 provides secure self service access to both DB2 and to the BMC DB2 toolset. Initially targeting application developers, Workbench delivers catalog browsing, access path analysis, statement tuning, job submission and many more activities in a familiar graphical environment.

 
  2:00 - 2:15 Break
 
  2:15 - 3:30 Analytics and the Mainframe
  Jonathan Sloan, IBM
 
  In this session you will hear about trends impacting analytics and the mainframe. This session will cover topics such as data warehousing, the logical data warehouse, business critical analytics, Big Data and the latest trend in analytics. We will also discuss System z strengths and gaps and how IBM is responding to these opportunities.
 

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:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, September 5th, 2014.

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
Jim Dee is a Corporate Architect in the Data Management organization in R&D at BMC Software. He is responsible for the technical content and integration of the DB2 for z/OS product lines. He has worked at BMC since 1990, mostly in DB2 Backup and Recovery, as a developer, product author, and architect, and has held his current position as Corporate Architect since 2007. Prior to joining BMC Software, Jim worked at various employers in the IT industry for 16 years as an application developer, systems programmer, DBA, and vendor developer. Jim has a B.A in Mathematics with a minor in Computer Science from Queen’s University in Kingston, Ontario.
Chad Reiber started in IT in 1983 with AT&T as a developer of data generator software. From there he moved into the database arena as a DBA for IMS, IDMS, and DB2. Chad has been working with DB2 since 1987 and began working for BMC Software in 1997 as a Software Consultant. He supports all aspects of BMC’s Mainframe products for the Northeast DB2 community.
Jim Kurtz has worked in IT since 1978 starting as an IMS application developer and DBA at large steel and manufacturing companies in Baltimore, MD. He began working with DB2 in 1987 as a DBA and a DBA manager at two large property casualty insurance companies also in Baltimore, MD. He also worked at a major credit card company in Newark, DE as the DBA responsible for development and implementation of DB2 data architectures to support the Finance Sector Data Warehouse. Jim joined BMC Software in 1995 as a Software Consultant and continues in the same role today responsible for providing pre- and post-sales support for BMC’s DB2 products to commercial and government accounts in the Mid-Atlantic region from Pennsylvania to North Carolina.
Jonathan Sloan is a Senior Certified Executive Software IT Specialist, with more than two decades of business intelligence experience with multi-dimensional and relational database systems. He has a bachelor's of science degree in business management and finance from the City University of New York and a masters degree in Business Administration from Rutgers University. He joined IBM in 2000 and specializes in helping customers understand the application of IBM Information Management technology to business problems. Jonathan has experience in the health care, financial services and consumer packaged goods industries. He is currently the business intelligence subject matter expert and team lead for data warehousing on System z.
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.