Exporting the model as a CSV file

You can export the system model as a Comma Separated Value (CSV) file. The export includes most model elements and any tags that are applied. The export does not include DB2, IMS, or WebSphere MQ elements. The exported data can be used in an external application. You can use the application to provide you with a better understanding of your environment, and as an aid to future planning.

Procedure

In the DA Explorer view, right-click the connection name that contains the model that you want to export. Click Export to File as CSV. In the Export to CSV window, select the location where you want to save the data and click Save. The exported model is saved as a CSV file.

What to do next

You can now load the data into an external application.

An example OpenDocument Spreadsheet (.ods) file is included in the related links. You can right-click the link and click Save Link As to save the file on your local computer. The example file shows one of the ways you might use the exported data.

The example file contains four data sheets:
Exported data
This sheet shows the data as it was exported from CICS DA.
DataPivot tables
This sheet shows the pivot tables used in the example to organize the data.
By LPAR
This sheet shows a graphical representation of the data, organized by LPAR.
By user ID
This sheet shows a graphical representation of the data, organized by user ID.