This day is an overview of the system: What it is, how to administrate and monitor.
- Kick off
- Overview/Architecture
- Admin Overview
- Lab: Console exploration Assumes live system access
- Data Warehouse Admin Overview
- Lab: Administration as part of IIAS (VM)
- Lab: Command line processor (VM)
- Monitoring
- Overall System
- Individual Query (explain plans)
This day is migration of tools, methods and understand of activities during a proof of concept.
- Understanding the IIAS data engine - BLU
- Data structures (what happens when data is updated/deleted)
- Groom/Compression/Stats/Reclaim
- Understanding Data Layout
- Tools to move Data
- ETL, Loading Methods and Utils, load rate and Best Practices
- Lab: Data Loading (VM)
- Performance tuning
- Migration Gotchas/best practices
- Lab: Migration using tooling (VM)
- Harmony Profiler migrating a Netezza/PDA DDL
- Set up Tables and Run db_migrate
This day is about an introduction to Data Science.
- Spark, Livey/Spark/ Data Science Experience
- Access to IIAS - Data Science
https://10.50.88.240:8444 username : admin00 password: password00
* Lab 1: [Creating and managing users](Labs/AdvAnalytics/CreateUser.md) ***Assumes live system access***
* Lab 2: [DSX : User experience](Labs/AdvAnalytics/AnalyticsAdmin.md) ***Assumes live system access***
* Lab 3: [DSX Advance Labs: Jupyter Notebook](Labs/AdvAnalytics/jupyterNotebookPredictive.md) ***Assumes live system access***
* Lab 4: [DSX Advance Labs: Machine Learning Builder](Labs/AdvAnalytics/machineBuilder.md) ***Assumes live system access***
***Modifications to Lab 3*** [Click here for Modifications](Labs/AdvAnalytics/lab3mods.md)
# Class Prerequisites
In preparation for the class we have created a VM image what contains Harmony Profiler, Db2 Client, Db2 Warehouse. This is preconfigure to connection to a Netezza machine.
There are desktop icons on this Ubuntu image that will Start/Stop and exec Db2 Warehouse, Db2 Client and Harmony Profile. All of these launchers are bash scripts located in ~/scripts directory.
In the Db2Wh container are all the ddl and sql scripts needed to execute the labs.
# Lab systems and presentations used during class
Here is a [link to a Box folder](https://ibm.box.com/v/IIASWorkshop) with presentations for you to follow along. For further education, please look at the [Channel Technical Enablememt Guide](https://www.onlinedigitallearning.com/course/view.php?id=3716)
Based on availability, we will have access to and IBM Integrated Analytics System for you to review for the administration labs and DSX lab. Complete the needful in the [Partner access document](./PartnerAccess.md)
[IIAS Console](https://10.50.88.240:8443/console) 10.50.88.240
Db2 Warehouse VM: Guest VM requirements. Virtual Box: 3 Cores and 10GB RAM
* The VM image login ***username:*** sailfish ***password:*** passw0rd.
* The Local Db2 Warehouse database:
* ***username:*** bluadmin ***password:*** bluadmin
* ***username:*** root ***password:*** sailfish
[DSX Console](https://10.50.88.240:8444/console) 10.50.88.240
* ***username:*** admin ***password:*** password
# Lab Instructions
Lab instructions are included in the vm as well an here on git.
* [Migration Lab](Labs/MigrationTooling/Readme.md) (VM)
* [Administration as part of IIAS](Labs/db2Console/Db2W_IIAS_Web_Console.md) (VM)
* [Command line processor](Labs/db2cmd/Db2W_Cmd_Line.md) (VM)
* [Create DB Objects Lab](Labs/CreateDBObjects/Readme.md) (VM)
* [Data Load Lab](Labs/DataLoading/Readme.md) (VM)
* [Administration Lab](Labs/Admin/Admin.md) (IIAS system)
* [DSX User Experience Lab](Labs/AdvAnalytics/AnalyticsAdmin.md) (IIAS system)