Course Details
Course Code: ND7DB2
Course Title: DB2 for Domino 7 Administrators and Developers
Units: 8
Duration: 2 classroom equivalent days
Discussion Access: 4 months1
1. Up to 12 months access when purchased as part of a Curriculum Package.
Summary Description
Notes and Domino 7 can store Domino databases in DB2. In this course you will learn how to use this new feature of Domino by installing a DB2 server, enabling a Domino 7 server to store databases in DB2, and creating DB2 Access Views and Query Views. This course is designed for someone who has no knowledge of DB2 and includes the basics of administering DB2 and DB2 security. You will learn how to install DB2, set configuration parameters for DB2 instances and databases and how to back up and recover DB2 databases. Next, learn how Domino works with DB2 and how to install and configure a Domino 7 server to store databases on a DB2 server. Finally, learn how to create new types of applications that integrate Domino with DB2 by using DB2 Access Views and Query Views and allow Domino applications access to other DB2 databases (federated data.) This course is a great foundation to start using DB2 with Domino 7.
Audience and Prerequisites
Experienced Domino administrators and developers who want to learn how to use the new DB2 feature.
System Requirements
Required Before Installing the Course
- Notes 7 client, including Domino Administrator and Domino Designer
(This must be installed prior to installing this TLCC course.)
- Domino 7 server (installed during the course)
- At least one computer on which the DB2 and Domino 7 test servers can be installed; two or three separate testing systems are desirable, but not required. The computers used for testing must have static IP addresses. The computer on which DB2 is installed must have XP Professional or Windows 2000 (XP Home will not work.)
Installed During the Course (TLCC provides instructions on how to download and install the following:)
- DB2 UDB Version 8.2, available as a trial version at no charge
Course Modules
Module 1 - Installing DB2
The first task in enabling the NSFDB2 feature is installing and configuring a DB2 server. This module provides hands-on experience to:
- Install the DB2 server software
- Configure the DB2 server
- Start and stop the DB2 server
Module 2 - Basic DB2 Administration
Domino administrators using the NSFDB2 feature will need to know the basics of administering a DB2 server. This module covers how to install the DB2 Administration Client and how to use selected DB2 administration tools, as well as the basics of DB2 security and backing up DB2 databases.
- Install the DB2 Administration Client on an administrator's machine
- Catalog a remote DB2 system on an administrator's machine
- Use the Control Center, Command Window, Command Line Processor, and Command Editor tools to administer DB2
- Explore the basics of how to configure a DB2 system
- Learn how DB2 security works
- Back up and recover DB2 databases
Module 3 - Configuring Domino 7 and DB2
There are several tasks that administrators must complete to allow Domino 7 to store databases in DB2. This module covers how to enable the NSFDB2 feature, and how Domino data is translated and stored in DB2.
- Install the DB2 Runtime Client on the Domino server
- Configure the Domino 7 server to store databases in DB2
- Install the DB2 Access Server on the DB2 server
- Map Domino users to DB2 users
Module 4 - Domino 7 and DB2 for Application Developers
Storing Domino databases in DB2 allows developers to use two new design elements: DB2 Access Views and Query Views. DB2 Access Views allow DB2 applications to access Domino data using SQL. Query views allow one view in Domino (which uses a SQL Query) to display data from its Domino database, from other Domino databases, and from other DB2 databases.
- Understand the purpose of DB2 Access Views
- Create DB2 Access Views
- Learn the advantages of Query Views
- Create Query Views
- Configure federated data to allow access to other DB2 databases
- Create a Query View that includes federated data