Previous Topic: DBSQLPR ParametersNext Topic: DBSQLPR DSV Sample


Sample Problem - 1

A user has existing AutoCollect spreadsheets, but would like a spreadsheet with a reduced view of the BVM table. All the required data is on the Delta LAST rowsets.

For LAST rowsets, list the following:

MUF

Display the MUF name.

DATE

Display the end date.

TIME

Display the end time.

CPU

Display the CPU seconds used.

IO

Display the I/O used.

REQUESTS

Display the requests processed.

REQ_PER_CPU

Display the requests per CPU second used.

REQ_PER_IO

Display the requests per I/O used.

COST_PER_REQ

Display the cost per request (new column).