DevSecOps Solutions - Group home

IBM Developer for z Systems version 16 now comes available with the new Db2 for z/OS tools, allowing you to work with Db2 data and SQL inside of IDz without the use of 3rd party plugins. This tutorial will guide you on how to create a connection to Db2 from inside IDz's Remote Systems view, then how to navigate to a table, and view table data.

Prerequisites:

To take advantage of this feature, the user needs:

• IBM Developer for zSystems (IDz) software, installed at version 16.0 or later and configured with a connection to an MVS LPAR

• Connection details to a Db2 Database

• Basic understanding of IDz navigation concepts, including the context menu (check out our no-charge IDz Remote Training options)

Estimated time:

This process should take 5 minutes from start to finish. 

Steps:

1. Open IDz and specify a workspace. A workspace is a folder or directory on your computer that contains metadata (or data about data) around any customizations you have made to the IDz workbench
2. Navigate to the Remote Systems view in the upper-right of the workbench. Find the LPAR connection on with your Db2 Database resides, right-click on it, and choose Connect.
3. The Enter Password dialog will appear. Enter your TSO credentials and click OK.
4. Once connected, click the expand arrow next to the LPAR connection you logged on to, then expand Db2 for z/OS, right-click on Db2 for z/OS Connections, and choose New > Db2 for z/OS Connection...
5. This brings up the Properties for <yourLPAR> dialog. This dialog asks for your Db2 Database connection information. Enter the Location name and Port for your Db2 subsystem, then click Test Connection. If the test is successful, a pop up will appear and display "Connection Attempt Successful". Click OK, then Apply and Close on the previous dialog panel. 
6. With the new connection made, expand Db2 for z/OS Connections, then expand the new database connection, then Schemas, and find the schema that contains the table you want to view data on.
7. Expand the schema, then right-click on the table and choose View Data. The data will appear in the Remote Systems Details view. With the data showing, you can use the Tool Bar icons to select columns to show, save table data to a CSV file, import/export column settings, or refresh data.

In this tutorial, you have created a connection to a Db2 database, connected, browsed the catalog, and viewed table data. To learn more, please consider attending the DevOps Distance Learning, a no-charge instructor-led training series.