AUTOCOLL (Collect and Manage Snapshots) › Create DSV Output Datasets

Create DSV Output Datasets

You can select Delta rows based on various column values and output the rowsets content as a Delimiter Separated Value (DSV) file, then use available FTP protocols to download the sequential output files from the mainframe to the PC as text files. These TXT files can be downloaded into a PC-based spreadsheet product like Microsoft Excel.

During the OPTION=DSVOUT execution, as the utility processes each of the Delta tables, it will attempt to open a matching sequential dataset for each of the tables. The sequential dataset DDname is specified as:

OUTxxx

The xxx is the three character table name in the Delta database.

If the DDNAME is missing from the JCL, the printed report indicates that no output dataset could be opened and skips the DSV processing for that table. The utility attempts to process all 17 tables generating output for those datasets that are defined.

To allow you to place output from multiple DSVOUT functions into a single set of OUTxxx sequential files, the following JCL example utilizes the DISP=(MOD...) JCL parameter. MOD allows each DSVOUT function to add its selected output to the "end" of the OUTxxx datasets.

Note: Before running the DBUTLTY OPTION=DSVOUT function with the DISP=MOD JCL, you should remove any unwanted data in the OUTxxx datasets or delete them entirely.

Two Delta rowset tables that should provide immediate benefit to you for the MUF performance analysis are the Business Value Metrics (BVM) and Business Value Details (BVD) tables. These tables provide key performance measurement ratios.

Once loaded into a spreadsheet, you can perform a variety of editing, sorting, and summarization tasks to manipulate the data into a usable form for your site.