You can monitor IBM DB2 databases with the ADO and the ADO User Experience monitors. These monitors require that the appropriate OLE DB provider for your database be installed on the ipMonitor host computer.
The IBM DB2 OLE DB Provider, contained in the DB2 Administration Client, is available for download directly from the IBM website.
You will need:
- The system name and host name of the IBM DB2 database server.
- The service name of the IBM DB2 database.
- The database name and database alias of the IBM DB2 database.
- A user name and password to access the IBM DB2 database.
To configure the OLE DB connection:
- Install the IBM DB2 Provider.
- Download the IBM DB2 Administraion Client to the ipMonitor host machine.
setup.exe to install the client.
- Click Install Product.
- Click DB2 Administration Client, and then click Next.
- Click Next to continue running the Setup Wizard.
- Read and accept the End User License Agreement, and then click Next.
- Click Typical, and then click Next.
- Confirm the Installation Folder, and then click Next.
- Configure NetBIOS settings, or click Next to skip.
- Confirm your settings, and then click Install to begin the installation process.
- Click Finish.
- Configure the Windows services file.
- At the end of the installation process, the IBM DB2 First Steps Launchpad window appears. Minimize this window.
Note: If the IBM DB2 First Steps Launchpad window does not appear automatically, you can launch it manually from Start > All Programs > IBM DB2 > Setup Tools > First Steps.
- With a text editor, open the following file for editing:
- Append the following to the end of the
/tcp #Connection port for instanceName
mydb2service 50000/tcp #Connection port for DB2 instance DB2
- Save and close the
- Configure the OLE DB connection.
- Restore the minimized IBM DB2 First Steps Launchpad window.
- Click Configure Access to Remote Databases.
- At the Would you like to add a database now? prompt, click Yes.
- Click Manually configure a connection to a database, and then click Next.
- Click TCP/IP, and then click Next.
- In the appropriate boxes, enter the Host Name, Service Name, and Port Number of the database, and then click Next.
- In the appropriate boxes, enter the Database Name and the Database Alias, and then click Next.
- Clear the Register this database as an ODBC source checkbox, and then click Next.
- From the Operating System list, select an operating system.
- Enter the Instance Name of the database, and then click Next.
- In the appropriate boxes, enter the System Name, Host Name, and Operating System of the database server, and then click Next.
- Click Use authentication value in server's DBM Configuration, and then click Finish.
- Test the OLE DB connection.
- In the pop-up window appears after the configuration process is complete, click Test Connection.
- Clear the CLI checkbox.
- Select the OLE DB checkbox.
- In the appropriate boxes, enter your Windows account username and password.
- Click Test Connection.