Knowledge Center > FAQs

The ADO (SQL Connect) and ADO - QA (SQL Query) Monitors require that you have the correct OLE DB Provider installed on the ipMonitor host computer to provide access to the database type you wish to use.

To access an IBM DB2 Database, you will need to download and install the DB2 Administration Client, available from IBM Corporation at http://www.ibm.com.

IMPORTANT! You'll require the following information before you begin:

• The System and Host Name of the machine where the IBM DB2 Database is located.
• The Service Name of the IBM DB2 Database.
• The Database Name and Database Alias of the IBM DB2 Database.
• A username and password to access the IBM DB2 Database.

1. Download the IBM DB2 Provider to the ipMonitor host machine.
2. Run the setup.exe file to install the Client.
3. Click the Install Product button.
4. Select the DB2 Administration Client option, and then click Next.
5. When prompted, click Next to continue running the Setup Wizard.
6. Read and accept the End User License Agreement, and then click Next.
7. Leave the Typical option selected and click Next.
8. Confirm your Installation Folder, and then click Next.
9. Configure NetBIOS settings, or click Next to skip.
10. Confirm your settings, and then click Install to begin the installation process.
11. Click Finish.

1. At the end of the installation process, the IBM DB2 First Steps Launchpad window will appear. Minimize this window for now.
   
   Note: If the IBM DB2 First Steps Launchpad window does not appear automatically, you can also launch it manually by clicking Start, All Programs, IBM DB2, Setup Tools, and then First Steps.
2. Open the following file with a with a text editor such as Notepad or Ultra Edit:
   C:\Windows\SYSTEM32\DRIVERS\etc\services
3. Add a line similar to the following to the end of the 'services' file:
   <service name> <portnumber>/tcp #Connection port for <instance name> instance DB2

   Example:
   mydb2service 8888/tcp # Connection port for DB2 instance DB2

4. Save and close the 'services' file, then return to the IBM DB2 First Steps Launchpad window and click the Configure Access to Remote Databases button to launch the Configuration Assistant.
5. Click Yes when prompted to confirm Would you like to add a database now?
6. In the Add Database Wizard window, select to Manually configure a connection to a database, and then click Next.
7. Select the TCP/IP option, and then click Next.
8. Enter the Host Name and Service Name of the IBM DB2 Database you want to monitor.

9. Enter the Port Number manually, or click the Retrieve button to have the field populated automatically, and then click the Next button.
10. Enter the Database Name and the Database Alias, and then click Next.
11. Uncheck the option to Register this database as an ODBC Source, and then click Next.
12. Select your Operating System, and then enter the Instance Name of the Database you want to monitor. Click Next.
13. Enter the System Name, Host Name and Operating System for the host machine of the IBM DB2 Database you want to Monitor, and then click Next.
14. Select the Use authentication value in server's DBM Configuration option, then click Finish.

1. In the pop-up window that displays after the configuration process is complete, click the Test Connection button.
2. Uncheck the CLI option and check the OLE DB option. Enter your Windows account username and password. Click Test Connection.

3. Once the Test Connection succeeds, click Cancel, then Close the Configuration Assistant.

For additional information regarding the ADO and ADO - QA Monitors, refer to the Monitors section of ipMonitor's Context-Sensitive Help system, and then select Monitor Types. The Context-Sensitive Help can be accessed by clicking the Help link located in the top right corner of ipMonitor's Administration web interface.

For information on other features and concepts related to those discussed in this article, refer to the following ipMonitor resources:

< Back

Last Updated: April 25, 2006 | What did you think of this topic?