DB2 for Domino 7 Administrators and Developers Course

One of the most dramatic features of Domino 7 is its ability to use DB2 as an alternate data store. While this opens up expansive vistas for both Domino and DB2 shops, it requires Domino administrators and developers not only to learn how to work with DB2 but how it works with Domino 7.

During this course participants will learn the essentials of DB2 installation, configuration, and security. Attendees will learn how to interact with the DB2 server using the DB2 Control Center and query DB2 tables using the Command Editor and SQL Assist. The course then turns to implementing DB2 as the Domino 7 data store. Participants will create DB2 Access Views that give external SQL applications access to Domino data and create Query Views that give Notes 7 access to DB2 data.
 
This is a lecture/lab course that follows a task-oriented approach. During the many exercises attendees will create a working test/development environment where they will work with the all aspects of the Domino 7/DB2 integration.

This course is designed for individuals who are new to DB2, relational databases, and SQL but who have experience programming Notes applications using Domino Designer 7 and experience administering Domino using Domino Administrator 7.

This course provides enough DB2, relational database, and SQL knowledge to set up a test/development environment in which users can begin to work with DB2 databases and Domino 7. This course does not, however, fully prepare one to become a DB2 administrator.

Upon completion of this course, the participant will be able to:
> Build a test/development environment that demonstrates the full capabilities of Domino 7 and DB2 integration
> Install the DB2 server and monitor its status and health using various administration tools
> Use the DB2 Control Center to configure the server and the License Center to apply a license file
> Create a sample DB2 database and use graphical tools to open and query the database using SQL
> Configure Domino 7 to use DB2 as its data store
> Install and configure the DB2 Access Server and create several DB2 Access Views to make Domino data available to external SQL applications
> Create Query Views to give Notes 7 access to DB2 data

Topic 1: Domino and DB2 Overview
A history of Domino data storage
A thumbnail perspective of DB2
The present and future of Domino data storage
How Domino data is stored in DB2
Notes and DB2
Local or remote connection
Benefits to Domino shops
Benefits to DB2 shops
Build a test/development environment
DB2 resources
 
Topic 2: Install DB2 Server
Server platform requirements
External authentication directory requirement
Obtain DB2 software
Extract DB2 server installation package
Instructor Demonstration: Install DB2 server product
DB2 Control Center
Object View tab
Instructor Demonstration: Add/Confirm license
Instructor Demonstration: Create SAMPLE database
Command Line Tools
Instructor Demonstration: Command Line Tools

Topic 3: Administer DB2
Administration Client platform requirements
Exercise: Install DB2 Administration Client
DB2 Security
Assign system administrators
DB2 security and NSFDB2s
Database object right-click actions
Database status
Database backup and recovery
Health Center
Configuration files
Send alerts to administrative contact(s)
Activity Monitor
Journal

Topic 4: Define Table
Table columns
Alter table
Columns tab
Add predefined column
DB2 limits
Keys tab
Check Constraints tab
Table tab

Topic 5: Open Table
View table data
Open Table window actions
Modify table data
Exercise: Add a row
Filter rows
WHERE clause operators
Logical expressions
Exercise: Apply a filter

Topic 6: Query from the Command Editor
Open Table window versus the Command Editor
SQL queries
SQL language rules and conventions
SQL built-in functions
Qualified and correlation names
Execute SQL query from the Command Editor
Exercise: Execute SQL query
Build a query using the SQL Assist
Exercise: SQL Assist
GROUP BY
Multiple table queries
Three table join
Alternate join syntax
Join tables using SQL Assist
Outer join types
Optional exercise: Perform additional queries

Topic 7: Install DB2 Run-Time Client
Procedure 1\Instructor: Create Domino accounts on DB2 server
Procedure 2\Instructor: Give DB2DOM group SYSCTRL rights in DB2
Procedure 3\Everyone: Install Run-Time client on Domino computer
Procedure 4\Instructor: Display DB2 communication parameters
Connect to DB2
Procedure 5\Everyone: Catalog the TCPIP node from the DB2 client
Procedure 6\Everyone: Attach to the TCP/IP node from the DB2 client
Procedure 7\Everyone: Catalog the database from the DB2 client
Procedure 8\Everyone: Connect to a database from the DB2 client
Procedure 9\Everyone: Issue SQL command from the DB2 client

Topic 8: Configure Domino 7 to use DB2
Procedure 1\Everyone: Enable transaction logging on Domino 7
Procedure 2\Everyone: Run the Enable Server for DB2 tool
Change 1: Domino 7 startup messages
Change 2: NOTES.INI
Change 3: Services file
Change 4: Server document
Change 5: DB2 name and password added to Server ID file
Change 6: TCPIP node added for DB2 server and attached
Change 7: DB2 container database created and cataloged
Exercise: Explore container database in the DB2 Control Center
Set DB2 log file size
Exercise: Create new NSFDB2
Day-to-day administration of NSFDB2s

Topic 9: Install DB2 Access Server
DB2 Access for Lotus Domino
Procedures to install the DB2 Access Server
Procedure 1\Instructor: Create a Domino server ID for the DB2 server
Procedure 2\Instructor: Install DB2 Access Sever on DB2
Procedure 3\Everyone: Edit your Servers Server document
Procedure 4\Everyone: Run DB2 ACCESS SET console command
Procedure 5\Everyone: Verify configuration of DB2 Access Server
DAV security overview
How to map DB2 to Domino 7 user names
Validate DB2 User Names tool
Set DB2 Username tool
Procedure 6\Instructor: Map DB2 to Domino 7 user names
Allowing anonymous access to Notes data

Topic 10: Create DB2 Access Views
DB2 Access Views overview
Domino data translation
Procedures to create a DAV
Procedure 1: Create the DAV
Procedure 2: Choose or insert fields
Procedure 3: Set DB2 Access View properties
Procedure 4: Save and validate the DAV
Procedure 5: Create/Update the table in DB2
Procedure 6: Populate in DB2
Exercise: Design DAV
Procedure 7: Grant access to the DB2 view
Exercise: Add new DAV user
Uninstall DB2 Access Server

Topic 11: Create Query Views
Query Views overview
Create a QV
SQL Query formula
Exercise: Create QV of one DAV
Limit number of rows returned by QVs
QV of two DAVs
Exercise: JOIN two DAVs
Data source federation
Procedure 1\Instructor: Federate DB2 instance
Procedure 2\Everyone: Create data source wrapper
Procedure 3\Everyone: Create server definition
Server definition object folders
Procedure 4\Everyone: Create nickname to external table/view
Exercise: QV of the EMPLOYEE table
Using QVs in Notes applications
Exercise: QV to JOIN DAV and EMPLOYEE table

Experience programming Notes applications using Domino Designer 7 and experience administering Domino using Domino Administrator 7 is required.