Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
 View Only
Back to discussions
Expand all | Collapse all

IBM Data Studio 4.2.0 released

  • 1.  IBM Data Studio 4.2.0 released

    Posted Thu January 29, 2026 09:41 PM

    FYI,

    IBM have just released Data Studio 4.2.0 to address multiple vulnerabilities in the old versions.

    https://www.ibm.com/support/pages/node/7258315?myns=swgother&mynp=OCSS62YD&mync=E&cm_sp=swgother-_-OCSS62YD-_-E

    It is a separate install, not an upgrade. I don't think there are any functional improvements, just the security update.

    To save you hunting for it, here's the link to Fix Central:

    https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Information+Management&product=ibm/Information+Management/IBM+Data+Studio&platform=All&function=all

    Cheers



    ------------------------------
    Greg Palgrave
    ------------------------------


  • 2.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 05:03 AM

    Thanks Greg! Do you know how to install it? I did not find any setup.exe or a readme.txt or a documentation link.

    Regards

    Gerald



    ------------------------------
    Gerald Zottl
    ------------------------------

    Original Message


  • 3.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 07:47 AM

    I would try to unpack DS 4.20 over a copy of an existing installation directory (for example DS 4.1.4) overriding existing files and then perform installation.



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for work
    Katowice or Krakow
    +48 783 109 863
    ------------------------------

    Original Message


  • 4.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 08:47 AM

    Hello all,

    It needs to be a separate installation, there is no migration for Data Studio.   Uninstall the old version to install the new one.

    You can find some additional information at:

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

    I hope that helps!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 5.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 09:47 AM
    Edited by Cintia Ogura Fri January 30, 2026 09:47 AM

    FYI: I am double checking with development team about the missing information for the installation of Data Studio 4.2.   I will update here when I get a resolution.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 6.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 09:59 AM

    Hi Cintia,

    I've already opened PMR TS021321943 because I receive a error message during install(I've deinstalled 4.1.4 before and upgraded to the latest Installaion Manager).

    Regards
    Gerald



    ------------------------------
    Gerald Zottl
    ------------------------------

    Original Message


  • 7.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 10:02 AM

    Hello Gerald,

    Currently I see 3 open cases with the same question.

    That's why when I get an update from development, I will update the results here to avoid having more cases.

    I will keep you posted.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 8.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 12:18 PM

    Hello team,

    I updated the Data Studio installation Technote after checking with the development team:

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

    Please note:

    1.) Installation Manager is not included with Data Studio package anymore, and it needs to be downloaded separately.

    2.) Data Studio V4.2 installation only supports Installation Manager 1.9.3.3 and 1.9.3.4.   If you try any other release, you will get an error.

    3.) There is no migration from V4.1.x to V4.2.   You will need to uninstall the old release to install V4.2.

    4.) The steps to install V4.2 are the same as V4.1.4

    5.) The only part that is missing is the Compatibility Report, and it will be updated later by the team as I don't have access to it.

    I hope that helps!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 9.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 08:39 AM
      |   view attached

    Hi Cintia,

    I've already told support that point 2) is really strange because IBM recommended several versions of Installation Manager before to migrate to at least 1.10.1 because of security risks. And that was the reason why we migrated all of our machines to 1.10.1 or later. So we cannot downgrade.

    Regards
    Gerald



    ------------------------------
    Gerald Zottl
    ------------------------------

    Original Message


  • 10.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 07:57 AM

    Hi Cintia,

    After installing V4.2 I got an SQL0N error when trying to connect to a data source using TLS.
    The stack trace reports: java.lang.IllegalArgumentException: Unsupported protocolSSL_TLSv2  

    Replacing the shipped db2jcc4.jar with the V12.1.3 version, driver version 4.36.6 fixed the issue.

    Regards

    Sven



    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 11.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 08:29 AM

    Hi Sven!

    From DOS and OS/2 times we survived "DLL hell"; from Linux times we survived "shared library hell", now we are in "jar hell" ...

    Which of the db2jcc4.jar would you replace with which one?



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for work
    Katowice or Krakow
    +48 783 109 863
    ------------------------------

    Original Message


  • 12.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 09:47 AM
    Edited by Sven Heidorn Mon February 02, 2026 09:53 AM

    Hi Jan,

    it seems you kept your old SDPShared and still have the old driver folder. So, it depends which one you are using on your data source.
    If you look at the driver properties for your data source, then klick on the little triangle on the right (Edit Driver Properties), in that window that opens look in the JAR List tab, you should see which folder the driver is in there.

    I actually uninstalled 4.1.4.4 and made sure the old installation folders were gone, both DataStudio and SDPShared, before installing 4.2. I wanted to be sure I got rid of all the old stuff and start with a clean SDPShared. And in that case it should be the ......db2_2.3.0.202601090956\driver\db2jcc4.jar

    https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads?view=full

    I took the one for Db2 12.1.3, driver version 4.36.6

    Regards

         

    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 13.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 06:20 PM

    Hi Sven!
    I uninstalled IBM DS completely - run scan for db2jcc4.jar, then I installed DS 4.2 and rerun scan again.



    Conclusions:

    1. Two backlevel db2jcc4.jar are installed into SDPShared by IBM IM installing DS 4.2;
    2. IBM Db2 installs two different versions of db2jcc4.jar - one in SQLLIB\Java, second one in SQLLIB\db2tss\lib:

    C:\DB2V12R1M5F0\SQLLIB\java>.\jre\bin\java -cp ./db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -version
    IBM Data Server Driver for JDBC and SQLJ 4.37.3

    C:\DB2V12R1M5F0\SQLLIB\java>.\jre\bin\java -cp ../db2tss/lib/db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -version
    IBM Data Server Driver for JDBC and SQLJ 4.28.11



    ------------------------------
    Jan Nelken
    Db2 (LUW) DBA
    Open for work
    Katowice or Krakow
    +48 783 109 863
    ------------------------------

    Original Message


  • 14.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 03:19 AM

    Hi Jan,

    yes you are correct, there are 2 installed.

    From my experience the driver used by the defined data sources/connections is the one in com.ibm.datatools.db2_2.3.0.202601090956\driver, but to be sure you will need to look at the properties of your data source.    



    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 15.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 09:24 PM

    Got to say I love the term JAR hell.  
    now moving to the DB2 Extension you will learn a bunch new terms.   Like what were they thinking, this thing is a no work of art, as well as, all things are hard to do and don't work.   And when they get it all working and you are use to it.  Bam and new crappy product to replace it.   Good luck trying to get visual explains to work.   



    ------------------------------
    Douglas Partch
    CEO
    Database Nerds
    Omaha NE
    ------------------------------

    Original Message


  • 16.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 04:15 PM

    Sven,

    Does your TLS connection work for "Analize and Tune"?



    ------------------------------
    Michael Averbukh
    ------------------------------

    Original Message


  • 17.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 02:54 AM

    Hi Michal,

    Yes it does, just tested and confirmed. 



    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 18.  RE: IBM Data Studio 4.2.0 released

    Posted Fri January 30, 2026 05:47 PM

    Hello Gerald,

    According to our extended team, they have tried using Installation Manager V1.10, but it is not currently working and they are still investigating the issue at this time.

    If you want to use Data Studio V4.2, you will need to use 1.9.3.3 and 1.9.3.4 for now.

    Otherwise you will need to wait for the conclusion of Installation Manager V1.10 investigation.

    I hope that clarifies your question.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 19.  RE: IBM Data Studio 4.2.0 released

    Posted Sun February 01, 2026 07:48 PM

    Just for reference, I used IBM Installation Manager 1.9.1.6 for the installation without issue.

    The support link from Cintia has the standard installation instructions.

    Cheers



    ------------------------------
    Greg Palgrave
    ------------------------------

    Original Message


  • 20.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 04:14 PM

    I'm trying to check the IBM Software Product Compatibility Reports but v4.2 doesn't appear on the list. Does anyone know when IBM will be updating?



    ------------------------------
    Gordon Foley
    ------------------------------

    Original Message


  • 21.  RE: IBM Data Studio 4.2.0 released

    Posted Mon February 02, 2026 04:21 PM

    Hello Gordon,

    The team is still working on it.

    I will provide an update as soon as I have the details.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 22.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 09:29 AM
    Hi Cintia,

    I used to have Installation Manager v1.9.1.6 (1.9.1006.20210614_1906) , had to move up to v1.10.1.3 ( 1.10.1003.20250827_1041) 
    along with Data Studio v4.1.4 APAR4 to address security concerns (flagged by WIZ scanner).
    It was made clear that DS 4.2.0 needs IM v1.9.3.3 or 1.9.3.4, so, IM v1.10.1.3 gotten rid of, but I can't install neither v1.9.3.3 nor 1.9.3.4,
    Installation is reported to be "Successful with warnings", error stack in both logs is almost identical
    My fellow AI compared 2 XML logs from both attempts:

    Both XML logs hit the same primary error stack: an Eclipse SWT UI failure org.eclipse.swt.SWTException: Graphic is disposed, originating at org.eclipse.swt.graphics.Image.getBoundsInPixels(Image.java:1422) and cascading through SWT layout/Workbench rendering code paths.

    Stack head (same)

    In both files, the top of the exception is org.eclipse.swt.SWTException: Graphic is disposed with org.eclipse.swt.SWT.error(SWT.java:4533/4448/4419) followed by Image.getBoundsInPixels(Image.java:1422), then SWT Label.computeSizeInPixels, Control.computeSize, GridData.computeSize, and GridLayout.layout/computeSize.

    Mid-stack path (same)

    Both stacks proceed through Composite.updateLayout/layout, then into e4 workbench renderer code (org.eclipse.e4.ui.workbench.renderers.swt.SashRenderer.* and org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.*) and then up through WorkbenchWindow.* close paths and Workbench.closeWorkbench(...).

    Additional errors (different)

    Only IM_20260202_1705.xml also logs a java.lang.NullPointerException in org.eclipse.ui.internal.WorkbenchPage$E4PartListener.partDeactivated(WorkbenchPage.java:227) and the follow-on "An exception occurred while notifying part listeners" message.

    Log dated "20260202" is for IM 1.9.3.3 (Java 1.8.0_461), another log (from Jan.29th) is for the failed attempt to install IM 1.9.3.4 (Java 1.8.0_471)

    Have you, by chance, heard of similar issues?
    Thanks.


    ------------------------------
    Nikolai Chekhmatov
    ------------------------------

    Original Message


  • 23.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 10:16 AM

    Hello Nikolai,

    Yes, I have seen this error before.

    During the installation, please disable the product search in Installation Manager.  Data Studio zip file already contains all necessary files, and you don't need Installation Manager to be looking for new updates.

    There are 2 places that you need to disable that:

    1.) In the Information Manager Preferences page

    2.)

    After you disabled the search on both places, please try the installation again.

    I hope that helps!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 24.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 10:29 AM

    Having installed IBM Installation Manager Version: 1.10.1.3 Internal version: 1.10.1003.20250827_1041, I have downloaded IBM DataStudio 4.2, and am trying to install it. I get so far, but at the last step, I get:

     

     

    Any clues, anyone?

     

    Regards,

    Marcus Davage CEng CITP MBCS

    Lead Product Developer
    Intelligent Z Optimization and Transformation
    BMC Software Ltd
     My Digital Pin IBM Champion 2025 badge image. Experience. Advanced level. Issued by IBM

     




    Original Message


  • 25.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 10:35 AM

    Hello Marcus,

    Currently there is a limitation of Data Studio V4.2, where we are only supporting Installation Manager 1.9.3.3 and 1.9.3.4.   If you try any other release, you will get an error.

    We are investigating this issue with a high priority as the research has been escalated internally already.

    I will be updating this discussion as soon as I have any updates from our extended team.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 26.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 10:51 AM

    Cintia, hi.
    thanks for your response above, but you are thinking one step ahead. I wouldn't dare to install DS without a clean installation of IM, and I can't even achieve that.



    ------------------------------
    Nikolai Chekhmatov
    ------------------------------

    Original Message


  • 27.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 02:08 AM

    A little quirk I have noticed in 4.2.0 is a new menu option for James Bond:

    It's not documented that I have found yet. Cintia Ogura can you enlighten us?

    Cheers



    ------------------------------
    Greg Palgrave
    ------------------------------

    Original Message


  • 28.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 03:29 AM

    That is part of Eclipse, not provided by Data Studio. 



    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 29.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 08:35 AM

    Thanks,

    Is long - awaited dark mode available in DS 4.2.0?

    Cheers!



    ------------------------------
    Pawel Romanek
    ------------------------------

    Original Message


  • 30.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 03, 2026 08:50 AM

    Hello Pawel,

    As Data Studio is currently in maintenance mode, we only had vulnerabilities and newer OS versions available for the new 4.2.0.   We did not have any features enhancements in the code.

    You can see the list of changes in the following link: https://www.ibm.com/support/pages/node/7257426



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 31.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 11, 2026 01:45 PM

    Hello all,

    As promised, here is the latest news that I have about IM release topic:

    Unfortunately Data Studio 4.2 is only supporting Installation Manager 1.9.3.3 or 1.9.3.4, and this is a limitation of the product.

    Currently we don't have plans to support IM 1.10.

    Please refer to Data Studio 4.2 installation procedure here:

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



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 32.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 12, 2026 04:23 AM

    For IM 1.9.2.5 IBM recommends it's customers to migrate to IBM 1.10.1.1 or later because of bugs and/or security vulnerabilities(https://jazz.net/downloads/ibm-installation-manager/releases/1.9.2.5). And now after customers migrated to IM 1.10.x they should downgrade to an older version because their own product DataStudio 4.2(which was released only because of security problems) does not support the newest version of IM?? How crazy is that????

    And the most craziest thing is that the old version DataStudio 4.1.4 installs without any problem using IM 10.1.3.1....;-))



    ------------------------------
    Gerald Zottl
    ------------------------------

    Original Message


  • 33.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 12, 2026 09:24 AM

    Hi Cintia,
    we are currently using the  Db2 Analytics Accelerator Studio (IDAA) plugin for DS V4.1.4.  We know it's deprecated, but due to some "limitations"  on the Db2 Admin Foundation it is still in use.
    Are there any plans or is there a timeline from the lab for delivering/adopting  this plugin for DS V4.2?
    Thanks a lot.
    Thomas Frölich



    ------------------------------
    Thomas Froelich
    ------------------------------

    Original Message


  • 34.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 12, 2026 10:06 AM

    Hello Thomas,

    If the plugin was already deprecated in V4.1.4, we won't support it in V4.2.

    Data Studio V4.2 was released mostly to fix some vulnerability issues and newer OS.

    As Data Studio is in maintenance mode, unfortunately there are no plans for enhancements on the code.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 35.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 11:03 AM

    Hello all,

    I have some great news: after several internal escalations, our extended team agreed to build a fix for Data Studio 4.2 to work with Installation Manager 1.10.

    We still don't have the dates yet, but I will have an update here when the fix is available.

    Thank you for your patience!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 36.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 02:06 PM
    Hi Cintia,

    that's great news.

    Thank you!

    Regards
    Gerald



    Original Message


  • 37.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 02:18 PM
    Edited by carol goldberg Tue February 17, 2026 02:26 PM

    My understanding is that DS does not support DB2  on Z/os V13,  is this still true. We are currently at DS 4.1.4. It seems to work at DB2 V13 FL100, can it be used at hight function levels in DB2 V13.

    If it does I would be delighted and would install the new version of DS.

    Carol



    ------------------------------
    carol goldberg
    ------------------------------

    Original Message


  • 38.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 03:54 PM

    Hello Carol,

    Data Studio does not support z/OS databases since March 31 2025 as the announcement here:

    https://community.ibm.com/community/user/blogs/jane-chan2/2024/02/27/ibm-data-studio-support-for-db2-for-zos-ends-on-ma

    Just to clarify, a non-supported environment means, if it works: great, but if it doesn't, we are not able to help you.

    So my recommendation is to start using the new z/OS replacement products as soon as possible, before Data Studio stopped working with new z/OS releases.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 39.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 04:01 PM

    Hello Community,

    I need some help from all of you.

    As you might know, Data Studio support team only knows that you are using a product when there is an issue with it, and you create a case with us.

    We don't actually know how you use the product on your daily routine.

    Can you please provide a list of Data Studio features that you like/use the most and why?

    That would help provide a feedback to the product manager and development team to improve our products.

    Appreciate the feedback!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 40.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 04:18 PM

    We still use Data Studio for the "Visual Explain/Tune Query" feature. We work with Db2 for z/OS 13 and the feature still works fine for us.

    These days (outside of Mainframe) we primarily use the DB2 Developer Extension for VS Code for most other DBA and Developer's needs.

    Data Studio 4.2 appears to be much less stable than 4.1.4. Data Studio 4.2 abends every so often with "Unhandled event loop exception".

    This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system.



    Original Message


  • 41.  RE: IBM Data Studio 4.2.0 released

    Posted Tue February 17, 2026 09:18 PM

    Hi Cintia

     

    I use DS for performance analysis and native stored procedure development primarily because there is either no mainframe/TSO equivalent in our shop or the reports are more easily digestible for our consumers

     

    Cheers

    Bruce

    --

     




    Original Message


  • 42.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 02:05 AM

    Hi Cintia,
    we are using DS 4.1.4 for the pairing process with IDAA V7.5.14 and also for debugging stored procs with Db2 Unified Debugger. 
    AdminFoundation V1.2 even with the newest maintenance level still does not provide this pairing function. 
    Best regards,
    Thomas Froelich



    ------------------------------
    Thomas Froelich
    ------------------------------

    Original Message


  • 43.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 02:16 PM

    Hello Thomas,

    According to the z/OS team, the IDAA pairing function has been available in Admin Foundation.  You can see this indicated in the screenshot:

    Have you tried a newer release of the product?

    I am adding here, in case other people has this same question.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 44.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 19, 2026 06:20 AM

    Hi Cintia,
    thanks for your feedback. We have installed  ADF  V1.2.1.5,  UMS  V1.2.0.14 on Zowe v. 3.2.0+20250430, so this is the newest official maintenance level of ADF and UMS.
    Unfortunately, the ADD button does not exists in any UI function in our setup. Not sure if this is a licensing issue.  
    As pairing the IDAA V7.5 with Db2 13 within DS V4.1.4 is still working, we currently do not have the pressure the issue needs to be analyzed & fixed neartime.   
    We will check opening a case or contact the ADF support via Slack channel. 
    Best regards,
    Thomas 



    ------------------------------
    Thomas Froelich
    ------------------------------

    Original Message


  • 45.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 09:10 AM

    My take on this is that DataStudio still is the best tool in this category that has come from IBM, it has outlived DSM and DMC, and I wouldn't be surprised if it outlives the intelligence center also.

    Now, IBM recognizes that developers want to use an IDE, VS Code, and hence have developed the developer extension, that one is however mostly aimed at developers, not really useful for DBAs.

    The power of an IDE is that it is customizable, you can add stuff to it that you need in your day to day work, none of the browser-based solutions like DMC or Admin Foundation have that possibility.            

    I probably do 80-90% of my work from within the eclipse environment which runs DataStudio, I have MQ Explorer installed into the same eclipse, to manage queues for Q-replication if needed.

    I have direct access to the servers file systems through the Remote System Explorer which is part of eclipse by default, together with the bash editor I installed into eclipse I can do my shell scripting directly on the server.

    Now, you could use a myriad of different tools, but I think, having most everything I need in one place is a huge benefit and simplifies what I need to do, by a lot.  



    ------------------------------
    Sven Heidorn
    DBA
    CSN
    Sundsvall
    ------------------------------

    Original Message


  • 46.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 04:12 PM

    I totally agree , the SQL tuning (liberty ) falls short when comparing it to Data Studio, But DB2 for MVS , datastudio is not going to support DB2 v13. I feel like my hands have been bound and tied using Zowe.

     

    Carol

     

     

    Carol Goldberg

    Texas Comptroller of Public Accounts

    Software Development

    512-475-0612

    Carol.Goldberg@CPA.Texas.gov

    111 E 17th Street

    Austin, Texas 78774

     

     




    Original Message


  • 47.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 11:34 PM
    The IBM Data Studio Web Console provides health monitoring, job management and connection management for DB2 databases. It can be used to share monitored features and analysis across database servers. The web console generates reports and keep track of databases. These report are handy for investigating performance problems and setting benchmarks for database.



    Original Message


  • 48.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 19, 2026 09:29 AM
    Edited by Cintia Ogura Thu February 19, 2026 09:32 AM

    Hello Madhusudan,

    If you are using Data Studio with LUW databases, have you tried Data Management Console (DMC) or Db2 Intelligence Center (Db2IC)?

    We do have the same features that you mentioned, and in addition, we have alerts, monitor Q Rep queues, query tuning, historical data, etc.

    One of the advantages for monitoring is, as DMC and Db2IC support newer Db2 releases, we use newer metrics as well.   For example, in Db2 Intelligence Center, the query tuning feature has impact analysis and what if reports too.

    It has a lot more metric details compared to the old Data Studio, which has not being improved for several years.   Data Studio tolerates newer Db2 releases, but it does not explore the new features or metrics.

    In case you are interested to try, DMC is free of charge and you can download the V3.1.13.2 from IBM Fix Central 

    If you need help, I have the DMC User's Guide

    For Db2 Intelligence Center, we have a 30 days trial 

    If you need help, I have a workshop material showing steps on how to install, and use the product, that I can share with customers.

    I hope that helps!



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 49.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 19, 2026 10:52 AM

    Hello Cintia,

    Without wanting to start a fundamental debate, I have witnessed the development over the years from Control Center, Data Studio and DSM to DMC. 

    I consider it strategically unfortunate that the new DB2IC is now bundled with paid AI functions as standard.

    A modular model would make more sense: DB2IC as the base system for all customers for free, with AI as an optional add-on for those who actually need the added value.

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------

    Original Message


  • 50.  RE: IBM Data Studio 4.2.0 released

    Posted Thu March 05, 2026 01:52 PM

    Hello all,

    Some great news: Db2 Genius Hub is now available for download.

    Db2 Genius Hub is replacing the Db2 Intelligence Center with a new way to manage your databases using agentic intelligence for autonomous database operations, embedding AI-driven reasoning and built-in agents directly into Db2.

    Here are some additional information:

    The trial is now 90 days instead of 30 days for the advanced features, and after the trial, you can still use the free version of the product.

    And if you have any issues, please let us know, and we will be glad to assist you.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 51.  RE: IBM Data Studio 4.2.0 released

    Posted Thu March 05, 2026 07:30 PM
    Edited by Greg Palgrave Thu March 05, 2026 07:34 PM

    Hi Cintia,

    It is still showing 30 days trial here: https://early-access.ibm.com/software/support/trial/cst/welcomepage.wss?siteId=2220&tabId=&w=1 and also showing 30 days in the license agreement if you go to the download.

    Is this just a re-brand of the Db2 Intelligence Center or is it actually something new?

    Regards,



    ------------------------------
    Greg Palgrave
    ------------------------------

    Original Message


  • 52.  RE: IBM Data Studio 4.2.0 released

    Posted Fri March 06, 2026 09:40 AM
    Edited by Cintia Ogura 7 days ago

    Hello Greg,

    Db2 Intelligence Center is not available anymore, and the Db2 Genius Hub is the new product now.

    We have changed the way we license Db2 Genius Hub.  You cannot buy Db2 Genius Hub product by itself, like the previous Db2 Intelligence Center.

    Db2 Genius Hub is now part of the Db2 AI Edition packages.  (for more details, please check the product announcement above)

    According to the product manager, the 90 days free trial is the following:

    30 days: you can download the product and use it, no questions ask

    60 days extension: if you liked the product and you want more time to test it, we can provide the extension license for 60 more days

    We have a complete different way for the AI part where we are now integrating agentic AIs to monitor your databases for you.  It explores all the AI capabilities included in the new Db2 V12.1.4.

    Here are some exciting new features in Db2 Genius Hub:

    • Besides using our Watson AI technology, you now have a choice to configure Db2 Genius Hub to use your own AI stack.   You can see more details here.
    • One new feature that a lot of people were asking in the past is now available in Db2 Genius Hub, you can now use the Log Analysis feature to monitor the db2diag.log file (Yay!!!!).

    Please try our new product, and if you need any further assistance, the IBM team will be glad to help you.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 53.  RE: IBM Data Studio 4.2.0 released

    Posted Fri March 06, 2026 05:12 AM

    Hello Cintia,

    Really great news. 

    Can you tell me when the version for AIX will be released? It says "coming soon" for Windows, but not for AIX. Or is Linux the preferred platform for the future?

    Best regards, Joachim



    ------------------------------
    Joachim Müller
    ------------------------------

    Original Message


  • 54.  RE: IBM Data Studio 4.2.0 released

    Posted Fri March 06, 2026 10:50 AM

    Hello Joachim,

    Currently we are not planning to have a release for AIX.

    The reason for that is because there are a number of components we need for Agentic AI that are not available on AIX.

    You can still monitor databases on AIX, but the Db2 Genius Hub needs to be installed on Linux or Windows (coming soon).



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 55.  RE: IBM Data Studio 4.2.0 released

    Posted Sun March 08, 2026 11:26 AM

    Are there plans to release anything to MacOS?



    ------------------------------
    Troy Potter
    ------------------------------

    Original Message


  • 56.  RE: IBM Data Studio 4.2.0 released

    Posted Mon March 09, 2026 09:56 AM

    Hello Troy,

    Related to your question: plans yes, dates no.

    There are certain operational challenges we are working internally to resolve first before making the final decision.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 57.  RE: IBM Data Studio 4.2.0 released

    Posted Sun March 08, 2026 11:22 AM

    Hey Joachim, I think it is worth noting that Db2 Genius Hub running on RHEL will work with a Db2 database running on Db2 Power. If running Genius Hub itself on Power isn't a requirement, you can leverage the platform across your Db2 fleet on Power.



    ------------------------------
    Greg Petrossian
    Worldwide Go-To-Market Lead, Db2 LUW
    IBM
    ------------------------------

    Original Message


  • 58.  RE: IBM Data Studio 4.2.0 released

    Posted Wed February 18, 2026 04:21 PM

    I have been using the Liberty plug in Zowe, I feel like the tool is back 10 years ago, when first being invented. The way it displays the visual diagram is horrible compared to the Visual in Data Studio. The information is not in one place when performing a tuning task. The diagram and the active information for each object is not presentable as output. it creates all these little files and really can not provide the analysis that is provided via data studio. I am extremely disappointed with the new improved Zowe, it falls short, and feel like we have to suffer for the poor presentation of the performance information. 



    ------------------------------
    carol goldberg
    ------------------------------

    Original Message


  • 59.  RE: IBM Data Studio 4.2.0 released

    Posted Thu February 19, 2026 11:52 PM
    I concur. It is awful and harder to use and the install and setup requirements are far more complex.


    Sent from my iPhone


    Original Message


  • 60.  RE: IBM Data Studio 4.2.0 released

    Posted Fri February 20, 2026 11:25 AM

    Hello all,

    I am not sure if you are aware of, but we just announced (yesterday) the new:

    IBM Db2 Developer Extension for VS Code

    https://www.ibm.com/new/announcements/announcing-the-ibm-db2-developer-extension-for-vs-code

    Please give it a try:

    https://marketplace.visualstudio.com/items?itemName=IBM.db2-for-luw

    Let me know any feedback/comments/suggestions, so I can share with development team.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 61.  RE: IBM Data Studio 4.2.0 released

    Posted Fri February 20, 2026 12:11 PM
    Yes, got the heads up that it was being released publicly yesterday.  I've been evaluating it privately since 0.0.2.

    Already a great improvement over the previous attempt.  And with Vijaya at the helm, I have high hopes that it will develop quickly into a great tool !!!

    Phil



    Original Message


  • 62.  RE: IBM Data Studio 4.2.0 released

    Posted Mon March 02, 2026 12:48 PM

    Hello Cintia-san

    Thank you for sharing this important information about the release of the Developer Extension for LUW.
    With the release of the Developer Extension for LUW, I assumed the following future directions, but is my assumption correct? Please let me know if you can answer.
     
     - As with Db2 for z/OS, Db2 for LUW and Data Studio connections will no longer be supported.
     - Data Studio is no longer supported.
     
    As a background to the above question, I know that the application development team I work with uses Data Studio to connect to Db2 13 for z/OS.
    Because if Data Studio is going to end support, I need to tell them to stop using Data Studio from a security point of view and use the Developer Extension for z/OS.
    Best regards.
    --------------------
      Satoshi Horata
    --------------------


    ------------------------------
    SATOSHI HORATA
    ------------------------------

    Original Message


  • 63.  RE: IBM Data Studio 4.2.0 released

    Posted 8 days ago
    Edited by Cintia Ogura 3 days ago

    Hello all,

    Just to let you know, Data Studio V4.2.1 is now available at IBM Fix Central.

    Here is a list of improvements:

    1. IM 10 support

    2. Adding the response file into the package

    3. Fixing vulnerabilities

    Please try and see if that works now.

    Let me know the results, or if you have any additional questions/concerns.



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 64.  RE: IBM Data Studio 4.2.0 released

    Posted 3 days ago
    Edited by Cintia Ogura 3 days ago

    Technote has been updated:

    Download and install IBM Data Studio 4.2.x

    Ibm remove preview
    Download and install IBM Data Studio 4.2.x
    This document describes how to download and install IBM Data Studio 4.2.x.
    View this on Ibm >

     



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 65.  RE: IBM Data Studio 4.2.0 released

    Posted 3 days ago

    After upgrading to 4.2.0 and later to 4.2.1 I can no longer see Predicates in Visual Explain. Is this specific to DB2 for z/OS?

     




    Original Message


  • 66.  RE: IBM Data Studio 4.2.0 released

    Posted 3 days ago

    Hello Michael,

    According to the Db2 LUW documentation, it should be part of the LUW as well.

    If that is missing, we need to contact development team, and I will need a case to track it.

    Can you please create a case with us, for further investigation?



    ------------------------------
    Cintia Ogura
    Support Technical Leader for Db2 Tooling products
    IBM Corporation
    TX
    ------------------------------

    Original Message


  • 67.  RE: IBM Data Studio 4.2.0 released

    Posted 2 days ago

    Cintia,

     

    I have submitted Case number TS021977334 for this issue.

     

    Thank you,

                    Mike




    Original Message


Related Content