Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     

Contact Us   -   Why Choose Wintrac   -   Clients    

Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cloud Computing
Crystal Reports
Data Science
Desktop Application Software
Embedded Systems
Google Web Toolkit (GWT)
Leadership Development
Machine learning/AI
Mainframe programming
Microsoft technologies
MultiMedia and design
New Manager Development
Object oriented analysis and design
Oracle VM
Professional Soft Skills Workshops
Project Management
Sales Performance
Software quality and tools
SQL Server
Visual Basic
Visual Foxpro
Web Development
Websphere MQ (MQSeries)
Windows programming
XML Web Services
DB2 for Domino 7 Administrators and Developers
Lotus Training Overview

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 you will learn the essentials of DB2 installation, configuration, and security. You 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. You 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.

Lotus Training Learning Objectives

In this course, you will learn how 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.
Lotus Training Audience

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 you can begin to work with DB2 databases and Domino 7. This course does not, however, fully prepare you to become a DB2 administrator.

Lotus Training Course duration

This course is sold as a 2-days course.

Course design

This is a lecture/lab course that follows a task-oriented approach. During the many exercises you will create a working test/development environment where you will work with the all aspects of the Domino 7/DB2 integration.

Lotus Training Course outline

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

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

About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac

Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy