Physical Data Modeling Using IBM Data Studio. August 25, 2015 I haven't written about IBM Data Studio in awhile, so I thought I'd dig into the latest version. In addition to downloading version 4.1.1, I also downloaded the current version of DB2 Express-C (V10.5) so I could have a working database. Book Description. IBM Data Studio is an Eclipse-based tool that is the replacement of the DB2® Control Center and other tools for DB2. In conjunction with DB2 Express-C, the no-charge edition of DB2, Data Studio is ideal for DBAs, developers, students, ISVs, or consultants because it's easy and free to use. IBM Data Studio stand-alone 3.1 is free to download from our software library. The most popular versions among the software users are 3.1, 2.2 and 0.2. This software was originally designed by IBM Corporation.
Active4 years, 2 months ago
Uninstall Data Studio, delete the old directories, basically adopt a 'scorched earth' policy. I used completely different directory names for the new install and workspace directory, just to be sure. Download/Install the IBM Installation Manager (mine is Version: 1.7.0 but there may be a more recent version). Studying Data Studio. Back in late April, when IBM announced the upcoming availability of Rational Developer for i, V9.0 (or RDi, as it will undoubtedly be known) they mentioned that the new version would include IBM Data Studio.
I've successfully installed IBM Data Studio and its Web Console on Ubuntu 14.04, and the Web Console runs like a dream and I can connect to my DB2 databases fine. However, when I try and run the Data Studio application (eclipse) and click on any of the tasks located in there, I get the following error message :
Checked my Java version and its 1.7.0_51:
Any ideas would be greatly appreciated :-)
![Ibm Ibm](/uploads/1/2/6/0/126015606/514617085.jpg)
user274470
user274470user274470
2 Answers
Incase anyone else runs into this issue, I resolved it by adding the following line to /opt/IBM/DS4.1.0.1/eclipse.ini :
Cheers! :-)
user274470user274470
I faced the same problem with Rational Software Architect on Ubuntu 14.04 64 bit. the solution that worked for me was to edit the /opt/IBM/SDP/eclipse.ini and I added the following a vmargs as follows:
-Dorg.eclipse.swt.browser.DefaultType=mozilla
That was enough for me on the other hand the below argument didn't work for me and was not enough.
-Dorg.eclipse.swt.browser.XULRunnerPath=/opt/xulrunner
aibrahimaibrahim
Not the answer you're looking for? Browse other questions tagged javaeclipse or ask your own question.
Posted Feb 19, 2008
By Paul Zikopoulos
So far in this series about the IBM Data Studio Developerintegrated development environment (IDE) that’s available with DB2 Version 9.5(DB2 9.5), I’ve shown you how to set up databaseconnection objects and the actions that you can perform on them. Inaddition, I introduced you (in Part 2)to some of the features available in the Database Explorer view, and Part 3 and Part4 gave you a full tour of overview diagrams. In Part 5,you learned how to point-and-click your way to OLE DB functions that canintegrate data from external data sources that have an OLE DB provider. In Part 6,I showed you how easy it is to create an SQL statement using the IBM DataStudio SQL Builder. In this installment, I’m going to show you my four favoritefeatures in the SQL Builder that make this tool even more helpful than just pointand clicking your way to an SQL statement like I showed you in the lastarticle.
Things you have to do to follow the examples in this article...
I recommend that you start with Part1 because I tend to build on the concepts and objects created in theseseries sequentially. For this article, I assume that you’ve at least createdthe SAMPLE database (use the db2sampl –xml –sql command) and that the FEMALEPERSONNELSQL statement built in Part 6resides in the SQL Scripts folder in a database development project.Your Data Project Explorer and Database Explorer views should look similar tothese:
IBM Data Studio Query Builder productivity boosters
In this section, I’ll talk about my favorite features thatreally help boost productivity when you’re designing SQL statements using theQuery Builder. I may have mentioned some of the features in past articles inthis series, but this section will serve as a place where they can all cometogether.
SQL Assist
Perhaps one of the most rapid application developmentfeatures that I know of in IBM Data Studio is SQL Assist. If you’ve ever worked with Microsoft Visual Studio and arefamiliar with IntelliSense, then you already have a good idea what I’m talking about.However, when you use the SQL Builder in IBM Data Studio, the assistance ishooked into the underlying database’s schema – not just the respectiveprogramming language semantics. In fact, since IBM Data Studio can maintain acache of the data servers you are working with, you can even work in adisconnected mode (offline) and still leverage this feature. SQL Assist is akey part of the pureQueryinitiative: it places the same assistance feature that Java programmers expectfrom their tools into an integrated editor that understands both Java and SQL.
For example, create a new query (call it FEMALEPERSONNEL2)and drag the DEPARTMENT and EMPLOYEE tables to your SQL Builder design canvas in the samemanner you did in Part 6.IBM Data Studio should now look like this:
In the last article, you added columns to the query bysimply selecting them from the middle pane of the SQL Builder. While you canuse the graphical controls at the bottom of the SQL Builder to add clauses toyour SQL statement, most developers are likely to use a combination of manualentry and assisted entry (like the Add Join and projection options Icovered in Part 6). While the check box column definition method is more usefulfor those not as adept in writing SQL, even SQL maestros will want to usecontextual assistance while they are writing the SQL statement; the SQL Builderoffers this with SQL Assist.
In the area of the SQL Builder that displays the actual textof your SQL statement, try to manually append the following condition (shown inbold text below) to the SQL statement that was automatically generatedfor you:
Note:Don’t forget to substitute the schema qualifier PAULZ used in this article forthe schema you used to create the SAMPLE database. (On a Windows platform, it’s whatever user account you were logged in with when you ran the DB2CREATE DATABASE command or db2sampl.)
Now I want you to erase thenewly typed text and retype it pausing ever so slightly after you specify PAULZ - of course, replace PAULZ with your schema name. (Stop at the period.) In IBMData Studio, when a period (.)follows a schema name that DB2 recognizes, the SQL Assist feature isautomatically engaged and all the applicable objects in context (in this case,the schema objects) are automatically presented in a pop-up list for you, asshown below:
Simply select the object you are looking for from the pop-uplist and press Enter. In this example, select the EMPLOYEE table andbriefly pauseafter typing the qualifying period after the EMPLOYEEtable name. You can see that SQL Assist is smart enough to recognize thecontext of the SQL statement: notice below that the pop-up list only shows thecolumns that are part of the EMPLOYEE table:
If you’re following along in this example, you’ll want toselect the WORKDEPT column. Sometimes you may notice that the column you wantisn’t on the pop up list. Obviously, you can use the scroll bar or your cursormovement keys to scroll down the list of returned columns - but there’s abetter way! SQL Assist has filter and stemming options that quickly move focusin the pop-up list to the location based on the first key you press. In thisexample, if you pressed W,then the SQL Assist pop-up list would only display those columns that beginwith this letter:
Ibm Data Studio 4.1.4
Note:You can also invoke SQL Assist by right-clicking in your SQL statement windowand selecting SQL Assist from the pop-up menu, or by pressing Ctrl+Spaceafter specifying an object name in your SQL statement.
Continue building this SQLstatement, but now I want you to manually enter the AND SEX=‘F’ restriction. (Notice that it changed color -we’ll talk about that in a bit.) You can see that sometimes it’s better just totype something quickly than to leverage SQL Assist. As you get more accustomedto this great feature, you’ll decide for yourself when to use it and when touse your old fashioned fast-typing fingers. In this case, I know I don’tactually have to specify the schema here, and I know there is a column called SEX, and I know the value and itscorresponding data type, so it was just faster to enter it myself.
Enter a space after SEX=‘F’. SQL Assist can help further,but it’s only going to show up if you ask for it using one of the methodsdetailed in the previous note (because there is no period triggering theaction). For example, to add the ORDERBY clause, invoke SQL Assist and manually scroll the entire list ofoptions to find this operator. (Of course, pressing a letter key willautomatically move focus in the list to the first occurrence for that group):
You can see this list is verylong. The point is that there is always some help available for you, anddepending on the context of the SQL statement, it changes dynamically. Finishbuilding this SQL statement and save your work.
Of course, since views andnicknames are presented like tables to applications, IBM Data Studio will linkthe SQL Assist features to enumerate all the qualifying views and nicknames,along with tables, in the list returned to the developer.
Another reason why this featureis so important is that if you were to create an SQL statement using the SQLEditor, you wouldn’t have the option to drag (or add) tables to the middle paneof the editor. You would just have the SQL text.
Ibm Data Studio 4.1.2 Client
You can also customize the waySQL Assist behaves in IBM Data Studio. For example, you could choose whether todisplay SQL proposals (keywords, templates, and names of database objects) whenyou use content assistance while writing or editing an SQL statement. Aspreviously mentioned, Ctrl+Space is the default key combination for thiscontent assistance. If you want to change this combination, select Window>Preferences>General>Keysand change the configuration for Content Assist.
Ibm Data Studio 4.1.2
SQL Assist really enhancesproductivity because it moves the requirement away from knowledge of thedatabase schema for productivity and places automated discovery of the schema in thehands of the application developers for a rapid application developmentexperience: this is true extreme application development.