Installation
Download
You can obtain the IBM Data Server Driver for ODBC and CLI by doing the following:
- Go to the IBM Support Fix Central Web site: http://www.ibm.com/support/fixcentral/. Data Server client and driver packages are found under the Information Management Product Group and IBM Data Server Client Packages Product selection. Select the appropriate Installed Version and Platform and click Continue. Check the Browse for fixes radio button and click continue. You will be presented with a list of all client and driver packages available for your platform, including IBM Data Server Driver for ODBC and CLI.
- Starting from Db2 11.5.5 and above, dmctop will be shipped with Db2 as what db2top and dsmtop did.
Installation
There is no installation program for the stand alone IBM Data Server Driver for ODBC and CLI. You must install the driver manually:
- Copy the compressed file that contains the driver onto the target machine.
- Uncompress that file into your chosen install directory on the target machine.
- Optional: remove the compressed file.
- Setup environment variable
- Linux: LD_LIBRARY_PATH=<DRIVER_INSTALL_PATH>/lib
- Windows: PATH=%PATH%;<DRIVER_INSTALL_PATH>\bin
Authorization
User ID used with dmctop to monitor database requires the following privileges, for detailed privilege information please refer README file included in the package.
| Function | Objects | Authorization |
|---|---|---|
| Monitor | Table functions SYSPROC.MONGET* SYSPROC.DB2_GET_INSTANCE_INFO SYSPROC.ENV_GET_DB2_SYSTEM_RESOURCES SYSPROC.ENV_GET_SYSTEM_RESOURCES SYSPROC.WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES SYSPROC.WLM_GET_SERVICE_CLASS_AGENTS SYSPROC.WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES Tables SYSIBMADM.MON_LOCKWAITS | Execute Execute Execute Execute Execute Execute Execute Select |
| Format explain | Procedures SYSPROC.EXPLAIN_FROM_SECTION Tables Explain tables | Execute Select and insert |