Product Documentation
Abstract
The following tables show supported topologies for the data server, InfoSphere® Optim™ Performance Manager, InfoSphere Optim Performance Manager Extended Insight, the JCC version, and the driver versions for CLI and .NET. The compatibility with previous products or versions is also considered.
Content
At a minimum, the following driver versions are supported in general:
- JCC applications V9.5.5 or V9.7.0 or later
- CLI/ODBC applications that use Data Server Client packages for Version 9.7 Fix Pack 2 or later
- NET applications that use the DB2® .NET provider from the IBM Data Server Client packages Version 9.7 Fix Pack 3 or later
- Embedded SQL applications that use Data Server Client Packages for Version 9.7 Fix Pack 6 or later
However, depending on the versions of the target data server and InfoSphere Optim Performance Manager, the minimum prerequisite driver level might be greater than stated above. The actual minimum levels are stated in more detail here as follows:
Table 1: DB2 for Linux, UNIX, and Windows
| DB2 for Linux, UNIX, and Windows | InfoSphere Optim Performance Manager and previous products or versions | Compatible versions of Data Tools Runtime Client or previous InfoSphere Optim Performance Manager Extended Insight Client Software | Minimum version of IBM Data Server Drivers for InfoSphere Optim Performance Manager Extended Insight Client Software |
| V9.1 and V9.5 | Performance Expert V3.2.0, Performance Expert V3.2.1, or Performance Expert V3.2.2 | Performance Expert Extended Insight Feature V3.2.0 | DB2 V9.5 Fix Pack 3 with APAR IZ35480 (JCC 3.53.82, JCC 4.3.97) |
| Performance Expert Extended Insight Feature V3.2.1 | DB2 V9.5 Fix Pack 4 with APAR IZ43011 (JCC 3.53.95, JCC 4.3.111) | ||
| Performance Expert Extended Insight Feature V3.2.2 | DB2 V9.5 Fix Pack 5 (JCC 3.57.110, JCC 4.7.112) DB2 V9.7 (JCC 3.57.82, JCC 4.7.85) | ||
| Optim Performance Manager V4.1 or later | Optim Performance Manager Extended Insight Client Software for Linux, UNIX, and Windows V4.1 | DB2 V9.5 Fix Pack 5 (JCC 3.57.110, JCC 4.7.112) DB2 V9.7 (JCC 3.57.82, JCC 4.7.85) DB2 V9.7 Fix Pack 2 (CLI) | |
| Optim Performance Manager Extended Insight Client Software for Linux, UNIX, and Windows V4.1.0.1 or later, or DTRC 2.1 or later* | DB2 V9.5 Fix Pack 5 (JCC 3.57, JCC 4.7) DB2 V9.7 (JCC 3.57, JCC 4.7) DB2 V9.7 Fix Pack 2 (CLI) DB2 V9.7 Fix Pack 3 (.NET) | ||
| V9.7, V9.8, and V10.1 | Performance Expert V3.2.2 | Performance Expert Extended Insight Feature V3.2.2 | DB2 V9.5 Fix Pack 5 (JCC 3.57.110, JCC 4.7.112) DB2 V9.7 (JCC 3.57.82, JCC 4.7.85) |
| Optim Performance Manager V4.1 or later | Optim Performance Manager Extended Insight Client Software for Linux, UNIX, and Windows V4.1 | DB2 V9.5 Fix Pack 6 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 1 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 2 (CLI) | |
| Optim Performance Manager Extended Insight Client Software for Linux, UNIX, and Windows V4.1.0.1 or later, or DTRC 2.1 or later* | DB2 V9.5 Fix Pack 6 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 1 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 2 (CLI) DB2 V9.7 Fix Pack 3 (.NET) | ||
| V9, V10.1 and V10.5 | InfoSphere Optim Performance Manager V5.1 or later | InfoSphere Optim Performance Manager Extended Insight Client Software for Linux, UNIX, and Windows V5.1 or later, or DTRC 2.1 or later* | DB2 V9.5 Fix Pack 6 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 1 (JCC 3.58.98, JCC 4.8.102) DB2 V9.7 Fix Pack 2 (CLI) DB2 V9.7 Fix Pack 3 (.NET) DB2 V9.7 Fix Pack 6 (Embeded SQL) |
Table 2: DB2 for z/OS
| DB2 for z/OS | InfoSphere Optim Performance Manager and previous products | Compatible versions of Data Tools Runtime Client or previous InfoSphere Optim Performance Manager Extended Insight Client Software | Minimum version of IBM Data Server Drivers for InfoSphere Optim Performance Manager Extended Insight Client Software |
| V9 | Optim Performance Manager V4.1.0.1 or later, which is shipped as part of IBM Tivoli® OMEGAMON® XE for DB2 Performance Expert on z/OS V510 | Optim Performance Manager Extended Insight Client Software for z/OS V4.1.0.1 or later, or DTRC 2.1 or later* | DB2 V9.5 Fix Pack 5 (JCC 3.57, JCC 4.7) DB2 V9.7 (JCC 3.57, JCC 4.7) DB2 V9.7 Fix Pack 2 (CLI) DB2 V9.7 Fix Pack 3 (.NET) |
| V10 | Optim Performance Manager V4.1.0.1 or later, which is shipped as part of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS V510 | Optim Performance Manager Extended Insight Client Software for z/OS V4.1.0.1 or later, or DTRC 2.1 or later* | DB2 V9.5 Fix Pack 7 (JCC 3.59, JCC 4.9) DB2 V9.7 Fix Pack 2 (JCC 3.59, JCC 4.9) DB2 V9.7 Fix Pack 3 (CLI) DB2 V9.7 Fix Pack 3 (.NET) DB2 V9.7 Fix Pack 6 (Embeded SQL) |
| V9, V10 and V11 | InfoSphere Optim Performance Manager V5.1 or later, which is shipped as part of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS V511 | InfoSphere Optim Performance Manager Extended Insight Client Software for z/OS V5.1 or later, or DTRC 2.1 or later* |
*Note:
- DTRC 2.1.1.0 is compatible with InfoSphere Optim Performance Manager Version 5.1.1.1 and above if you have installed APAR IC88119.
- DTRC 3.1 and DTRC 3.1.0.1 can be deployed on DB2 LUW server if you have installed APAR IT07158.
- DB2 V10.5.3, DB2 V10.5.4, DB2 V10.5.5 can be used for .NET applications if you have installed APAR IT07104.
- DB2 V9.7.7, DB2 V9.7.8, DB2 V9.7.9 are compatible with DTRC 2.1.1.1 or earlier versions if you have installed APAR IT02659.
- DB2 V10.1.2, DB2 V10.1.3, DB2 V10.1.4 are compatible with DTRC 2.1.1.1 or earlier versions if you have installed APAR IT04323.
- DB2 V10.5, DB2 V10.5.1, DB2 V10.5.2 are compatible with DTRC 2.1.1.1 or earlier versions if you have installed APAR IT07156.
- DTRC 3.1.0.2 and earlier versions with Java applications might result in out of memory issues.
- IBM Data Server Driver Package for ODBC and CLI versions 10.5.4 and 10.5.5 can be used with SAP if you have installed APAR IT06553.
Supported IBM Data Server Drivers for JDBC and SQLJ for InfoSphere Optim Performance Manager Version 5.1.1.1, Version 5.1.1, and Version 5.1.0
The versions stated above are minimum versions. To get the complete set of Extended Insight monitoring data, upgraded versions of a data server client driver are required.
The following data server client version is required to get the complete set of Extended Insight monitoring data.
- IBM Data Server Driver for JDBC and SQLJ Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
- IBM Data Server Driver for CLI Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
- IBM Data Server Driver for .Net Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
- IBM Data Server Driver for Embedded Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
[{"Product":{"code":"SSBH2R","label":"InfoSphere Optim Performance Manager for Db2 for Linux, UNIX, and Windows"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF013","label":"Inspur K-UX"}],"Version":"4.1;5.1;5.1.1;5.1.1.1;5.2;5.3;5.3.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg27023428