Db2

 View Only

 IBM Data Studio and DB2 12.1 for Windows

  • IBMChampion
nikos dimitrakas's profile image
nikos dimitrakas posted Mon December 16, 2024 08:57 AM

The new version of DB2 (12.1) has according to the release notes discontinued the DAS service. In the documentation at https://www.ibm.com/docs/en/db2/12.1?topic=121-discontinued-functionality it says that "The Db2 administration server (DAS) and all associated functionality is discontinued." and that "The IBM Data Studio or IBM Db2 Data Management Console products can be used to administer Db2 databases." But the latest IBM Data Studio (4.1.4) does not seem to work to create a database. The error is "Failed DAS server communication: db2dasjutil64 (Not found in java.library.path)". It works with DB2 11.5.9.

I have tried this on two separate machines using Windows 11 Pro and Windows 11 Enterprise. Is there something I am doing wrong? How can I create a database from inside IBM Data Studio? Will a new version of IBM Data Studio be release with support for DB2 12.1 (without relying on DAS)?

If a database already exists (for example created using the DB2 Command Line Processor), then I can connect to it from IBM Data Studio.

Douglas Kostelnik's profile image
Douglas Kostelnik

You'll probably get a lot of responses that Data Studio was deprecated a long (long) time ago. The announced replacement was originally DSM (Db2 v10.x) and later DMC (Db2 v11.x). If you don't want to use DMC, you can use a tool like DBeaver or Quest Toad for DB2.

nikos dimitrakas's profile image
nikos dimitrakas

If IBM Data Studio is deprecated, why is it still listed as the recommended tool for DB2 and is mentioned even in the release notes of DB2 12.1. I tried DMC already but it is even worse. There is no way to create a database and is not really a tool for doing things that Data Studio is for, like running SQL, code completion, code coloring,  support for XML. And DMC is web based.

At www.ibm.com/products/ibm-data-studio there is no mention of Data Studio having been replaced or even being deprecated. I can switch to a different product (like DBeaver), but I wish to use the tool IBM recommends for DB2. And from everything I can find, that is still IBM Data Studio. 

Every major DMBS has its own tool: SQL Server has SQL Server Management Studio, Oracle DB has SQL Developer, MySQL has MySQL Workbench. Isn't IBM Data Studio the equivalient for DB2?

Eric Sheridan's profile image
Eric Sheridan

From what I recall, Data Studio has been deprecated for Db2 LUW. IBM will no longer be adding new features or services for Data Studio in regard to Db2 LUW. Data Studio is still supported for Db2 z/OS. The reason IBM has somewhat moved away from Data Studio is that it is based on Eclipse which is a pain for everyone. Not to mention all of the JAVA security updates. 

For Db2 LUW you should instead use DSM. It is free to use and can be installed locally on your workstation. However, you will not be able to make use of a repository database to store historical monitoring data. Provided you have the license you can, of course, set it up for that. 

As for the documentation being misleading, a majority of the documentation for V12.1 was simply copied from the V11.5 documentation. This is why you will sometimes see references to previous versions in the documentation. You can either provide feedback on the document or open a PMR with IBM to make them aware of the issue. 

Douglas Kostelnik's profile image
Douglas Kostelnik

The official replacement for Data Studio has been DMS and then DMC. 
I'm not going to say that I would endorse using them, I don't. Neither replacement product is a good tool for an Administrator (in my opinion).

I have had discussions, this year, with Data Studio Support. Their stance is the product will only be changed if there is a MAJOR issue or security problem, so none of my issues would be addressed. It was maybe 10 years ago they started talking about deprecating it. You can try opening a case with IBM, but I would not hold out much hope.

Jan Nelken's profile image
Jan Nelken IBM Champion

I am not going to augment excellent replies from Doug - but would like to insert my 2 cents CDN /2 grosze PL:

I am against in principle presence of the button "Create Database" - unless this button is linked to complete configuration panel where you can define properties of the tablespace(s) to be created, their characteristics and value of the database configuration parameters (there are plenty of those). In my opinion task of creating a new database in the instance is better left to skilled DBA.