Data Studio 3.1.1 encounters issues when connecting to DB2 V10.1 FP1 or newer
The Administration Explorer and Data Source Explorer from Data Studio 3.1.1 displays the incorrect database version. When connecting to DB2 for Linux, UNIX, and Windows Version 10.1 FP1, the database information is incorrectly displayed as (DB2 for Linux, UNIX, and Windows V9.1).
Symptoms include missing functionality and missing features in the Administration Explorer and Data Source Explorer.
The Admin Explorer and Data Source Explorer incorrectly displays a DB2 V10.1 database version as DB2 for Linux, UNIX, and Windows V9.1
Many behavior and catalog changes were made from DB2 V9.1 to DB2 V10.1 FP1. Items were renamed, moved and removed. Because the database is incorrectly displayed as V9.1, Data Studio checks for information in places where it would be, if the database were V9.1. But of course it is actually DB2 V10.1 FP1 or later. So there might be possible problems when loading objects from the database catalog in the form of missing information, failures or errors. Another example would be delta ddl and generate ddl. They would be based on V9.1. objects, which is incorrect.
During the database connection establishment, Data Studio 3.1.1 fails to properly classify the correct database version. When that happens, Data Studio falsely thinks that it is a DB2 V9.1 connection.
All users of Data Studio 3.1.1 connecting to a database on
DB2 Version 10.1 fix pack 1 (10.1.0.1) or newer on Linux, UNIX and Windows.
The following products are affected:
- Data Studio 3.1.1
- Optim Query Workload Tuner 3.1.1
- InfoSphere Data Architect 8.1
- InfoSphere Warehouse Design Studio V10.1
Diagnosing the problem:
Use the following information to validate if you are encountering this issue.
- Connect to a DB2 LUW V10.1 FP1 or later database using Data Studio 3.1.1
- Database version information is displayed as V9.1 instead of V10.1 in the Admin Explorer and the Data Source Explorer
Resolving the problem:
A temporary fix can be implemented by obtaining a patch for RTC 14510
The patches are packaged with IBM Installation Manager.
Installation instructions are in the readme.txt included with the patch.
Download the corresponding patch for your product:
|Data Studio||3.1.1||Fix Central|
|Optim Query Workload Tuner||3.1.1||Fix Central|
|InfoSphere Data Architect||8.1||Fix Central|
|InfoSphere Warehouse Design Studio||10.1||Contact the IBM InfoSphere
Warehouse support team to obtain a patch
for resolving this problem.
In the United States and Canada dial 1-800-IBM-SERV
View support contacts for other countries
Open a Service Request with Technical Support
Sign-up to receive e-mail notification of changes to this document.
- Sign in to My Notifications
- select Subscribe tab
- select "Information Management" from the Software column
- select the check box for "DB2 for Linux, UNIX and Windows"
click the Continue button.
- select the check box for "Flashes" and all other document types
click the Submit button.
|Information Management||DB2 for Linux- UNIX and Windows||AIX, HP-UX, Linux, Solaris, Windows||10.1|
|Information Management||InfoSphere Optim Query Workload Tuner for DB2 for Linux- UNIX and Windows||3.1.1|
|Information Management||InfoSphere Data Architect||8.1|
|Information Management||InfoSphere Warehouse||DWE - Design Studio||10.1|
More support for:
IBM Data Studio
Software version: 3.1.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1610862
Modified date: 06 November 2012