Designing your queries
The LIST
command is the HCL Workload Automation for Z equivalent of an
SQL query, which is used to find data within the database and plans. It is important to
understand how to design an efficient query, which in turn needs an understanding of the data
you are querying.
To reduce the amount of data processing, define your search to a narrow set of criteria.
For example, use the STATUS
argument to limit the number of
results by considering only the operations in a specific status.
When a large set of results is expected, you can define a series of smaller queries instead
of a larger one. For example, split the results alphabetically by listing all output
beginning with A*
, then B*
and so on.
The Current Plan Operation commands are also a form of query. They perform a
LIST
, then filter it down to size. Ensure that you set the
identification keywords to specific values, so that the amount of data searched is limited.
To further reduce the data processing, use also the filter keywords.