Float Your Data to the Cloud: A Primer on Load and Data Movement Options for dashDB and DB2 on Cloud

Session ID: DMT-1435 (link) | 2016-10-24 | 02:00 PM - 02:45 PM

dashDB is a fully-managed, self-service data warehouse in the cloud that puts powerful analytics at your fingertips. DB2 on Cloud is a flexible, hosted offering that keeps management of the database environment in the hands of the DBA. Regardless of the service being used, one of the first tasks you?ll have is getting your data into the database, and there are various options available to do that. In this session, you?ll learn about the different options for data loading and movement, when to use them, and best practices. Staging your data in a cloud-based storage like SoftLayer Object Storage (Swift) or Amazon S3 will also be covered.

Program

Sessions

Track

Data management

Level

Introductory

Speakers

Jennifer Chen, IBM
Miran Badzak, IBM

DB2 High Availability and Disaster Recovery with Single or Multiple Standby Databases

Session ID: DMT-1766 (link) | 2016-10-27 | 09:00 AM - 11:30 AM

This online lab allows you to configure and manage a production database with single or multiple standby databases using DB2 HA/DR facilities. At the end of the exercise, you should be able to: Set up single or multiple standby databases for using the HA/DR recovery techniques, including configuring the Database Configuration options; use the START HADR, STOP HADR and TAKEOVER commands to manage the primary and standby databases of an HA/DR system; enable a HA/DR standby database for read-only access by applications, when in standby status; and monitor the status of a HA/DR primary database and single or multiple standby databases after an emergency takeover is initiated after a failure on the HA/DR primary database.

Program

Sessions

Track

Data management

Level

Intermediate

Speakers

Melanie Stopfer, IBM
Sharyn Richard, IBM

Secrets of the Pros: Using Data Server Manager to Monitor, manage and Mitigate Performance Problems

Session ID: DMT-3141 (link) | 2016-10-27 | 09:00 AM - 11:30 AM

This hands-on-lab will teach you how to use the latest version of IBM Data Server Manager for Linux, Unix and Windows to diagnose and resolve performance problems. You will work on four use cases where a query is not performing as manifested in the CPU, I/O, Memory and Locking information. A fifth use case will go beyond the monitoring diagnosis to show how you can mitigate the current problem by tuning a single query or the entire workload the query belongs to.

Program

Sessions

Track

Data management

Level

Introductory

Speakers

Marichu Scanlon, IBM
Chi-Man J. Sizto, IBM