Seminar Program

Date: August 17, 2016 - Seminar Agenda

Location: The Crowne Plaza Hotel , Novi Michigan

8:15am - 9:00am Check In / Continental Breakfast
9:00 am - 9:05 am Meeting kickoff and Opening comments
9:05 am - 10:20 am "FEEDBACK tables and PROFILES – is it a dream?"
Speaker: Speaker: Steen Rasmussen (CA)
Download "Too Many Fights in Your Marriage with Runstats: Try Profiles and Feedback Tables"
10:20 am - 10:40 am Break
10:40 am - 12:00 pm "What’s hidden in the ARCHIVES – DB2’s answer to American Pickers?"
Speaker: Steen Rasmussen (CA)
Download "What’s hidden in the ARCHIVES – DB2’s answer to American Pickers?"
12:00 pm - 1:00 pm Lunch - included as part of the seminar
1:00 pm - 2:15 pm "DB2 for z/OS Distributed Access – In the Mobile Age”
Speaker: Adrian Burke (IBM)
Download "DB2 for z/OS Distributed Access – In the Mobile Age"
2:15 pm - 2:30 pm Break
2:30 pm - 3:45 pm "Avoiding L2 Performance PMRs"
Speaker: Adrian Burke (IBM)
Download "Avoiding L2 Performance PMRs"


Presentation Abstracts

Presentation #1:

Steen Rasmussen (CA) - “FEEDBACK tables and PROFILES – is it a dream?”


A lot of DB2 sites are using pretty basic RUNSTATS syntax, but they might be missing some hidden gems and not providing the optimizer with adequate statistics resulting in non-optimal performance. Runstats has always been a challenge in terms of how to code the best possible syntax based on the SQL hitting the table and this task has not become any easier between each release of DB2. DB2 11 provides some great tools to assist with this task and the future looks even more promising.

Presentation #2:

Steen Rasmussen (CA) – “What’s hidden in the ARCHIVES – DB2’s answer to American Pickers?”


The attendee will get a detailed overview of what’s needed in terms of DDL to enable data archiving automatically as well as the changes needed from the SQL/application view. There’s no perfect world (Utopia doesn’t exist) so we will also look into the limitations and restrictions when Archive tables are exploited in DB2 11 NFM. Next topic is to go over what needs to be considered in terms of backup and recovery as well as other DB2 utilities which are impacted. The entire presentation will be done based on a real DB2 11 subsystem to see how all the moving parts work together.

Presentation #3:

Adrian Burke (IBM) – “DB2 for z/OS Distributed Access – In the Mobile Age”


Come and learn the best practices and updates to Distributed Access on DB2 for z/OS 10 and DB2 11. As distributed environments become more complicated and important your organization needs a methodology for adjusting timeouts and other thresholds for high availability. We will go over the recommended driver and server configurations for workload balancing, high availability, and client reroute in a Data Sharing or non-Data Sharing environment. You will be exposed to recent customer incidents that could have been avoided with the correct proactive driver/server settings We will also discuss improvements to DDF cancel thread, location stats, and how to positively identifying these distributed threads for problem determination.

Presentation #4:

Adrian Burke (IBM) – “Avoiding L2 Performance PMRs”


Root cause analysis of presumed, or actual DB2 performance issues can be quite tricky in today’s diverse environments. Everything from CEC capacity, LPAR utilization, real/virtual storage, WLM settings, PARMLIB members, and DB2 parameters can play a part in performance degradation. Wouldn’t it be nice if there were some tools (no-charge ones at that) which could quickly guide you in the direction of the root cause? Not just in text format but with graphs and trending lines that can visually depict the bottle neck and help educate management and colleagues. Many man hours have been wasted studying the effects of a system slowdown. This presentation will walk through a methodology for avoiding these issues.


Speaker Biographies

Steen Rasmussen (CA)

Steen Rasmussen is a Sr. Engineering Services Architect currently instrumental in the ongoing development and support of the CA Technologies 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. 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 z/OS Release 1.0 since 1985 and is always looking for new opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at CA technologies working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Steen is honored to be an IBM Champion for three years.

Adrian Burke (IBM)
Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab, led by John Campbell. In this role as a technical advocate for DB2 for z/OS Adrian conducts consulting and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Previously, as a DB2 Advisor, Adrian supported hundreds of DB2 for z/OS customers from a technical sales perspective delivering consultative and educational workshops. Adrian has spoken at numerous DB2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 performance.