IBM DB2 Analytics Accelerator for z/OS
Jim Brogan - IBM
Abstract:
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.
Bio:
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
Abstract:
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.
Bio:
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
Abstract:
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.
Bio:
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
Abstract:
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.
Bio:
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.