IDUG DB2 Tech Conference in Dublin, Ireland 2015
Complimentary Workshops (Sponsored by IBM)
Sunday, Nov 15th
Certification Preparation Courses:
Pre-Certification Workshop: IBM DB2 11 DBA for z/OS & DB2 10.1 Fundamentals (Exam 610 & Exam 312)
Pre-Certification Workshop: DB2 10.1 DBA for LUW (exam 611) and DB2 10.5 DBA for LUW Upgrade (exam 311)
Thursday, Nov 19th
COMPLIMENTARY: DB2 11 Migration Planning Workshop
Gareth Jones and Michael Dewert [IBM]
- Versioning of information expands beyond temporal management into archiving of data.
- Online schema evolution continues to provide more ways to enhance database designs while maintaining information availability.
- The DB2 11 optimizer provides insights into the statistics it needs to make the best decisions.
- The DPSI is back with enhanced optimization and parallelism.
- The Native SQL Procedures Language keeps getting better. Have you been looking for an array? Look at DB2 11.
- DB2 for z/OS SQL, aided by industry leading optimization, continues to push transactional performance and expands native analytical capability with new Group By options and integration with Big Data via Hadoop.
- Distributed communications are a blast. Literally. Learn about this new communication protocol.
- Do you use external security? It now communicates with DB2.
- DB2 11 provides flexible paths to expand RBA / LRSNs, assisting Data Sharing high volume insert processing and eliminating logging restrictions.
What is the Migration Planning Workshop (MPW)?
- One-day, comprehensive review of the capabilities, considerations, preparations, and project planning for DB2 11.
- This offering enables customers to understand the breadth of features delivered in DB2 for z/OS versions.
- The enhanced migration process is explained.
- Leave the session with materials that you can use to start your installation / migration immediately, or in the future.
For more information download the DB2 11 Migration Planning Workshop trifold.
COMPLIMENTARY: Fast Start! DB2 for z/OS Application Development Topics
Gareth Jones [IBM]
This session examines the use of triggers and instead of triggers, and looks at the benefits and coding techniques for exploiting multi-row operations.
Archive Transparency and TIMESTAMP with TIMEZONE
This session explores the DB2 11 feature which allows applications to transparently access data in an archive table, and optionally to move non-active data into an archive table. It also looks at the use of time zone information with TIMESTAMP columns.
SQL Features including Intersect/Except/Merge and other SQL coding techniques
This session looks at a variety of SQL features introduced over several DB2 releases, and how they can be used to provide improved functionality, performance, and to provide alternative coding techniques for your applications.
Dynamic SQL best practices
This session discusses dynamic SQL best practices in terms of exploiting and managing the Dynamic Statement Cache (DSC). Guidance is given on analysing dynamic query performance using performance data available in the DSC and the session concludes with a brief look at protecting the production environment by using production modelling to ensure consistent access path selection across development, test and production..
Managing Query Performance
This session briefly introduces the EXPLAIN tables , which are used to assist in access path analysis. It then looks at some typical access path problems, how they are affected by filter factors and the statistics in the DB2 catalog, how to identify them and some strategies for handling them. Once access path problems have been addressed, PLAN_TABLE and the DB2 Access Path Repository can be used to provide optimisation hints, to stabilise access paths, and ultimately to ensure that preferred access paths are used for critical queries.
COMPLIMENTARY: DB2 for z/OS and Cloud Computing
Maryela Weihrauch and Kewei Wei [IBM]
Being ready for Cloud computing is important for any software product. Maryela and Ke Wei will position DB2 for z/OS role in cloud computing, introduce z/OSMF workflows. They than will share how DB2 exploits them for automated DB2 migration and installation to simplify DB2 system programmers as well as infrastructure for cloud provisioning use cases.
DB2 for z/OS and Cloud Computing - Part 2: Self-Service Database Provisioning in Private Cloud
With the distributed databases making big steps in cloud support, it is critical for DB2 for z/OS to provide similar capabilities for easy database consumption.
COMPLIMENTARY: DB2 in the Cloud Hands on Workshop
Chris Eaton [IBM]
As you may be aware, IBM has a huge investment in Cloud Data Services with several billion dollars invested in acquiring and growing the IBM Cloud. At the core of cloud data services are the database management systems you know and love ... namely DB2. For the cloud we have renamed it dashDB as it is really more than just DB2. It's DB2 BLU Acceleration infused with Netezza in database analytics and offered in a pay as you go cloud model which provides a very low starting point (free) and allows you to grow and shrink with changing business demands. In this 2 hour hands on workshop we will take you through provisioning and working with dashDB (the working part you will be familiar with since it's DB2). We will also work on getting your data into the cloud and show you how we can integrate data from mobile applications that leverage a NoSQL JSON data store (like Cloudant) to provide analytics on top of these new data sources. We will also work through moving data into, out of and around the cloud using the dataWorks service on IBM Bluemix (another free service). We will then wrap up with an exploration of Watson Analytics which allows you to perform predictive analytics on your DB2 data in the cloud without having to have a PhD in statistical analysis.
All you need to bring to the workshop is a network connected device (laptop, iPad, etc) to work with DB2 in the Cloud and the IBM Cloud provides the rest.
- Understand bluemix and creating data services
- Provisioning and working with a dashDB instance
- Working with JSON data in Cloudant and doing analytics on that data with dashDB
- Moving data around the cloud and getting data in using dataWorks
- Watson Analytics - exploration and prediction for your business users
COMPLIMENTARY: DB2 LUW Basic Administration
Saeid Mohseni [ Folksam Insurance Co.]
- The concept of the Database Manager (Instance)
- Database tpyes: Single database, Database partitioning Features (DPF) and PureScale
- Database and its physical components such as Storage Group and Transaction log
- Table space definition and types of tablespaces
- Table definition, types of tables and other database objects such as Index, Viewes and Alias.
- The concept of IBM DB2 with BLU Acceleration • Data propagation such as Load, Import, Ingest
- The Transaction log processing in DB2 LUW
- Types of Backup and Recovery
- Existing utilities in DB2
- Database Shared Memory Review and retated parameters
- Monitoring Tools
Presenter: Saeid Mohseni [Folksam Insurance Co. ]
COMPLIMENTARY: IBM DB2 Analytics Accelerator Architecture Workshop
Patric Becker and Peter Bendel [IBM]
Conducted at IDUG 2013 and 2014 conferences, the DB2 Analytics Accelerator Architecture Workshop is a half-day, interactive session that will help you understand this new technology up to the latest available version and how this can help you in improving your performance and cost of your DB2 for z/OS based Data Warehouse and related analytical business processes.
This workshop is for everybody who wants to get up to speed with the latest version of IBM DB2 Analytics Accelerator and understand the technical processes that happen 'under the covers'.
- Technical deep dive into the latest version and enhancements of IBM DB2 Analytics Accelerator in 2015
- Obtain latest news from IBM DB2 Analytics Accelerator development
- Customer experiences of latest enhancements
- Understand use cases and technical details of in-database-transformation (IDT) with an accelerator
- Incremental update enhancements
- Gain insight into more efficient ways to feed data to IBM DB2 Analytics Accelerator
- Presentation materials
- Networking and Contacts