June 19, 2014

Publick House, 277 Main St, Strubridge, MA 01566
Sponsored By: 
Opening Remarks
IBM DB2 Analytics Accelerator for z/OS
DB2 10 and 11 for z/OS - Implementing and Using Autonomic Statistics
Top Missteps in DB2 for z/OS High Availability
Data Studio for the DBA and Programmer
Wrap Up
Abstracts and Biographies: 

IBM DB2 Analytics Accelerator for z/OS

Jim Brogan - IBM


IBM DB2 Analytics Accelerator for z/OS is a high-performance appliance that integrates IBM Netezza and zEnterprise technologies.

The solution delivers extremely fast results for complex and data-intensive DB2 queries on data warehousing, business intelligence

and analytic workloads.

This presentation is a Technology Exploration of the Accelerator including the past, present and future of data warehousing in general

and the Analytics Accelerator specifically.


Jim Brogan is an IBM Certified Consulting IT Specialist. Throughout his 40+ year career, Jim has had many roles in the IT industry

including those of DBA, DBA Manager, and Database Consultant at many large corporations including United Technologies Corp,

General Electric, and Westinghouse. Jim's Database experience includes IMS, DB2 z/OS, DB2 for LUW, and Oracle. His current

responsibilities are as an IBM DB2 Advisor providing technical support to the IBM sales team and customers for IBM DB2 z/OS in the

Northeastern United States and technical responsibility of selling and supporting IBM’s Infosphere z/OS portfolio of Replication Products.




DB2 10 and 11 for z/OS - Implementing and Using Autonomic Statistics

John Iczkovits - IBM


DB2 10 and 11 have a neat feature, automatically executing RUNSTATS on required objects. By the way, you get to choose when and how to

execute RUNSTATS. The actual implementation however is not straight forward. Come to this presentation and learn how to successfully

implement and review the output for this new feature.


IT Specialist with IBM Advanced Technical Support. He provides DB2 for z/OS technical support and consulting services. His areas of

expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer,

Database Administrator, IT Specialist, Consultant, and project lead. He has 33 years of IT experience, ranging from database products

such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers,

trade magazine articles, and presented at SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference,

IBM System z Technical Symposium, CMG, IDUG, and at local DB2 users groups.




Top Missteps in DB2 for z/OS High Availability

Jay Yothers - IBM


DB2 for z/OS is the platform for high volume OLTP workloads running mission critical applications. DB2 for z/OS is designed to help

achieve continuous 24/7 availability. However experience has shown that there are pitfalls that can reduce your availability profile.

In this presentation, we will discuss the most common situations that can cause availability problems and what to do about them.


Jay Yothers is a DB2 for z/OS architect. He has been part of the DB2 Development organization since the very first release of DB2 and has

designed and developed many key features of DB2 for z/OS. He has been awarded over 20 patents for his work in DB2 for z/OS. He is a

frequent speaker at conferences such as IDUG, SHARE, and IOD, seminars, webcasts, user group meetings, and executive briefings, bringing a

wealth of knowledge and experience to such events.




Data Studio for the DBA and Programmer

Saghi Amirsoleymani - IBM


Access plan changes occur in many different scenarios, like database server migration and maintenance, application deployment from a test

system to a production system, database design or environment changes etc. These changes may often lead to unexpected and severe

performance regression. As such, it is critical to find out the changes in advance, and understand their potential impact. Furthermore,

it is important to manage the changes and gain plan stability in the database application life cycle. SQL performance tuning for any

database applications typically involves iterative processes: monitor the subsystem, identify the problematic queries, analyze the

performance issue, and tune the queries. In this session, we describe how with Data Studio/Query Workload Tuner one can easily carry

these tasks and streamline processes.


Amirsoleymani is a Solutions Architect in the Optim Enablement team at IBM's Silicon Valley Lab in San Jose, CA, where she enables

customers and partners on IBM Data Studio technologies. Prior to joining this team, Saghi was part of the DB2 z/OS L2 team. She joined IBM

in 1999, after finishing her degree at University Southern California She has presented on various topics related to Data Studio,

Analytics, and performance at the Information on Demand and IDUG conferences, various user groups, and events.