Special cases of creating query workloads that run on DB2 for z/OS
When you create query workloads from these locations, you
must follow prerequisite steps that are not required for creating
query workloads from other locations.
Importing query workloads from XML files
You can create a query workload that runs on DB2 for z/OS from
a query workload that was exported from the IBM Data Studio client or from a query workload
that is defined in an XML file that is written in the InfoSphere Optim Query
Workload Tuner schema.
Example of creating a query workload from a user-defined SQL repository
You can create query workloads from SQL statements that
are in data that was offloaded to DB2 for z/OS tables by non-IBM query-monitoring
applications. To do this task, you must
map categories of data to columns in the DB2 for z/OS tables that contain the offloaded
data. This
topic also shows an example of the requirements for capturing SQL
statements from such data.