AutoCollect - Creating User Defined DELTA Rowsets › Extracting Delta Rowsets into DSV Output Datasets

Extracting Delta Rowsets into DSV Output Datasets

You can select Delta rowsets based on various selection criteria 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 text files can be imported into a PC-based spreadsheet product such as Microsoft Excel.

During the OPTION=DSVOUT execution, as the utility processes each of the Delta tables, it attempts 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, you can use 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, remove any unwanted data in the OUTxxx datasets or delete them entirely.

Two Delta rowset tables that provide immediate benefit to your site 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.