Download and install IBM Data Studio 4.2.x

Download Description

IBM Data Studio is a no-charge offering that consists of the Data Studio client.

The Data Studio client provides an integrated development environment for instance and database administration, routine and Java application development, and query tuning that can be installed with other IBM software products so that they can share a common environment.

Important 

The Data Studio web console is no longer supported, however, you can easily perform the same tasks with our replacement offering, the IBM Data Management Console. You can download it from the IBM Support Portal, and get detailed installation and configuration information at the IBM Data Management Console documentation.

What's new and changed in IBM Data Studio 4.2.1

• Response file into the package

• IBM Installation Manager 1.10 support

• Fixed security vulnerabilities, including:

  • Upgraded to log4j-core-2.25.3
  • CVE-2009-4269, CVE-2015-1832, CVE-2006-7217, CVE-2010-2232, CVE-2022-46337
  • CVE-2013-0248, CVE-2014-0050, CVE-2013-2186, CVE-2016-1000031, CVE-2016-3092, CVE-2023-24998, CVE-2025-48976
  • CVE-2015-7501, CVE-2015-6420

   

What's new and changed in IBM Data Studio 4.2.0

• Uplifted Eclipse SDK to 4.23

• Upgraded IBM Installation Manager to 1.9.3.3 and 1.9.3.4

• Fixed security vulnerabilities

• Updated support for the following database versions:

  • HSQLDB 1.8
  • DB2 for Linux, UNIX, and Windows V12.1
  • Derby 10.12
  • Informix 14.10
  • SQL Server 2022
  • Sybase:16.0
  • Oracle 23
  • MySQL 8.0

For more details about this release, see Overview of IBM Data Studio.

Resolving known issues after installation

Out of memory errors

a. Clear specific Eclipse cached data

Navigate to the workspace directory for example:

C:\Users\userid\IBM\rationalsdp\workspace\.metadata\.plugins\

Delete the folder:

org.eclipse.core.runtime

Refer to the following IBM technote:

https://www.ibm.com/support/pages/node/7048178

b. Increase Java heap size in datastudio.ini file

c. Start IBM Data Studio

SQL4230N error during database connection

a. Replace the db2jcc4.jar in SDPShared installation directory, e.g.: 
C:\Program Files\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.3.0.202603121632\driver

b. Download the JDBC driver from 11.5.9:
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads?view=full
For example: V11.5 M9 FP0 - 4.33.31
https://www.ibm.com/support/fixcentral/swg/selectFixes?source=dbluesearch&product=ibm%2FInformation+Management%2FIBM+Data+Server+Client+Packages&release=11.5.9.0&searchtype=fix&fixids=*jdbc*FP000&function=fixId&parent=ibm/Information%20Management