Installation and Configuration Supplement

Verifying Connections to DB2 Family Data Sources

This section explains how to verify that you have correctly configured your federated system to access DB2 family data sources. You must have completed all the steps in Adding DB2 Family Data Sources to a Federated System before continuing with this section.

step  1.
If you have not already done so, create the sample database on your DB2 federated server by issuing the following command:
DB2SAMPL

step  2.
Connect to the sample database on your DB2 federated server:
CONNECT TO SAMPLE

step  3.
Issue the following SQL statement:
SELECT * FROM SYSCAT.SYSTABLES

You should receive the entire contents of the SYSCAT.TABLES system catalog table.
step  4.
If you have not already done so, create the sample database at your DB2 family data source.
step  5.
Add a system catalog table from the DB2 family data source's sample database to your federated environment:

When issuing the CREATE SERVER statement for the data source, specify SAMPLE for the DBNAME.
When issuing the CREATE USER MAPPING statement, make sure the user ID at the data source holds at least SELECT permission for the sample database.
Create a nickname for the sample database's SYSCAT.COLUMNS system catalog table.

step  6.
Using the nickname for the SYSCAT.COLUMNS table, issue the following SQL SELECT statement to retrieve data from the DB2 family data source; for example:
SELECT * FROM nickname

where nickname is the nickname for DB2 family sample database's SYSCAT.COLUMNS table.
You should receive the entire contents of SYSCAT.COLUMNS.
After you successfully select data from both the federated database and a DB2 family data source, you can try joining data from the two data sources to complete the verification procedure.

If you will be including Oracle data sources in distributed request queries, proceed to Setting Up a Federated System to Access Oracle Data Sources.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]

step 1.	If you have not already done so, create the sample database on your DB2 federated server by issuing the following command: DB2SAMPL
step 2.	Connect to the sample database on your DB2 federated server: CONNECT TO SAMPLE
step 3.	Issue the following SQL statement: SELECT * FROM SYSCAT.SYSTABLES You should receive the entire contents of the SYSCAT.TABLES system catalog table.
step 4.	If you have not already done so, create the sample database at your DB2 family data source.
step 5.	Add a system catalog table from the DB2 family data source's sample database to your federated environment: When issuing the CREATE SERVER statement for the data source, specify `SAMPLE` for the DBNAME. When issuing the CREATE USER MAPPING statement, make sure the user ID at the data source holds at least SELECT permission for the sample database. Create a nickname for the sample database's SYSCAT.COLUMNS system catalog table.
step 6.	Using the nickname for the SYSCAT.COLUMNS table, issue the following SQL SELECT statement to retrieve data from the DB2 family data source; for example: SELECT * FROM `nickname` where `nickname` is the nickname for DB2 family sample database's SYSCAT.COLUMNS table. You should receive the entire contents of SYSCAT.COLUMNS. After you successfully select data from both the federated database and a DB2 family data source, you can try joining data from the two data sources to complete the verification procedure.