Chapter 6. Case study software components 167
An administrator has access to the full functionality of Query Patroller Center.
The following list shows some of the tasks that administrators can do with Query
Manage the Query Patroller system parameters.
Create, update, or delete profiles for Query Patroller submitters and
Create, update, or delete submission preferences for Query Patroller
Create, update, or delete query classes.
Monitor and manage queries that have been intercepted by the Query
Generate and analyze reports that display database usage history.
A submitter has access to a subset of the functionality of Query Patroller Center.
The following list shows some of the tasks that submitters can do with Query
Monitor and manage queries that they have submitted through the Query
Store results of the queries that they have submitted for future retrieval.
Show or file results of the queries that they have submitted.
Create, update, or delete their own query submission preferences.
Query Patroller command line support
Command line support enables Query Patroller administrators and submitters to
perform most Query Patroller tasks from the DB2 CLP or from the operating
system's command line prompt. Query Patroller commands can also be
combined with shell scripts or languages such as Perl, awk, and REXX.
6.1.7 DWE Mining
Data Mining is embedded into DB2 through the use of DB2 stored procedures
and user-defined functions (UDFs). That are three distinct modules:
A typical data modeling process is based on the steps depicted in Table 6-2 on
page 168. As a prerequisite, data should have been preprocessed.