IBM Rational Developer for System z v9.0 (RDz v9) and IBM Data Studio 4.1 (DS 4.1) GA'ed on June 14th 2013, and since then there is a lot of excitement, buzz around the new integration capabilities added between both products - this blog entry is aimed at describing the integration points and features as applicable to the z/OS application development.
RDz is an Eclipse based integrated, multi-platform development environment with modern, easy to use application development tools for applications running on IBM z/OS operating system. Data Studio is an Eclipse based IDE for database developers and DBA's, and provides an integrated, modular environment for development and administration of databases. Both RDz v9 and DS 4.1 are built on Eclipse 4.2.2 as the base foundation - and that allows both products to be installed into the same Eclipse "shell" - popularly referred to as "shell sharing". Shell sharing essentially enables the set of products appear to the user/developer as a single product with different sets of capabilities - and is a pre-req for having the integration capabilities between different sets of products.
RDz v9 and DS 4.1 take advantage of the shell sharing to provide much richer integration between the product capabilities and thus enhance the overall developer productivity and experience. The core integration features are enabled from the RDz editors (COBOL Editor, PLI Editor and System z Lpex):
- Ability to select an EXEC SQL statement and Run the SQL
- Ability to select an EXEC SQL statement and Tune the query
- Populate the SQL Outline view - a feature of Data Studio - with the SQL statements from the COBOL or PLI program that the user is editing - and thus make available all the menu items to Run, Tune, Visual Explain etc. from the SQL Outline view
Steps to enable the integration features:
Start by defining a DB2 z/OS connection thru the Data Source Explorer in the Data Perspective
In the connection dialog, the following are required parameters
- DB2 location (this is the DDF name for your DB2 subsystem – you should ask your DB2 DBA for this value)
- Host Name/IP Address
- Port number for DB2 JDBC access (again, ask your DB2 DBA for this value)
- Your TSO ID and password
- A default Schema name
- The COBOL or PLI source to be edited should be added to a RDz MVS SubProject (create one if necessary )
To enable the integration capabilities - Right click on the MVS Sub project and select "Add Data Access Development Support" as shown in the image below:
Adding the Data Access development support will result in the association of a sub project and its source files with a defined database connection:
From here on, any COBOL or PLI source being edited in the RDz editors will have additional menu items enabled when an EXEC SQL statement is selected as shown:
Behavior or work flow for each of the menu items shown in the above image:
- Refresh SQL in Outline View - populates and refreshes the SQL Outline view with the EXEC SQL Statement translated into standard SQL, the Database tab of the view will show the Schema and the tables being used by the program as shown. Also right clicking on the SQL statement in the outline view will display the menu items as shown below. The other tabs show the same SQL but with different organization i.e the Source tab will show all the queries in the program and its dependencies ( Copybook or Includes).
Run SQL from the Editor would Run the SQL - and if Host Variables are present - a dialog would be presented to the user to specify the value for the Host variables, and results are displayed in the SQL Results view as shown below:
- Tune Query menu item would trigger the Query Tuning capabilities from the Optim Query Workload Tuner client that is included in IBM Data Studio. The tuning capabilities however will require a valid license for the Optim Query Workload Tuner for DB2 z/OS server component - which is a charged feature.
RDz v9 and DS 4.1 in addition to the standard Database access, table filtering, stored procedure support provide much richer capabilities for the COBOL and PLI application developers. IBM Data Studio - a free of charge offering is bundled with RDz. RDz standalone does come with a base set of Data Tooling capability - and that is a proper sub set of the IBM Data Studio product. The base set of capabilities however are limited to providing connection to databases, table editing, SQL scripting, COBOL/PLI stored procedure support etc. In order to get the best of both products and full capabilities for DB2 z/OS development - the recommendation is to have RDz and Data Studio shell shared.
There are several other high value SQL application development features in IBM Data Studio that are not covered above, but stay tuned, we will be adding more blogs to cover those topics.