When you submit a query, the QueryEnabler component checks for matching
queries in the job table. If matching queries exist, the Result Set
window opens. Matching queries are displayed in tabular format along
with information such as job status, scheduling time, and completion
time. This window refreshes periodically based on database
activity. The Result Set window is illustrated below:
The table below contains a description of each column that displays in the Result Set window.
Table 2. Columns in the Select a Result Set Window
| Column Name | Description |
|---|---|
| Query Name | The name of the query. |
| Job ID | The unique job ID assigned by the DB2 Query Patroller system. |
| Job Status | The status of the job, which can be: hold, done, queued, estimating, running, canceled, and aborted. |
| Table Name | The name of the result table. N/A indicates that the table name is not available. |
| # Rows | The number of result rows returned by the query. |
| Sched ID | The schedule ID, which is the same for a group of recurring queries submitted simultaneously. |
| Date/Time Submitted | The date and time the query was submitted. |
| Date/Time Scheduled | The date and time the query is scheduled to run. |
| Date/Time Completed | The date and time the query completed. |
| Results Destination | The alternate result destination. |
| Error Status | An error description, if the query was aborted. |