IBM DB2 Query Patroller Administration Guide
This section provides information about the job accounting process and the
columns in the Job Accounting table.
If you set the Accounting Status system parameter to Write to
Table, the notifier component adds a row to the Job Accounting table
each time a job completes.
This information is used by the Tracker tool to provide reports that
display a database usage history for queries managed by the DB2 Query
Patroller system. For example, this information will be used by Tracker
to create reports showing which tables and columns have been accessed most
frequently, which tables have returned the most result rows, and which jobs
have been completed within a specific time frame.
The following list explains each of the columns in the Job Accounting
table.
- ACCOUNT_ID
- The ACCOUNT_ID column represents the accounting identifier associated
with the user from the User Profile table.
- COMPLETION_STATUS
- The COMPLETION_STATUS column contains a single letter code indicating
how the job completed. Values are D for done (normal
completion), C for canceled, or A for aborted.
- DATA_SOURCE
- The DATA_SOURCE column identifies the database instance against which
the query was run. Currently, the only supported data source identifier
is IWM.
- DTIME_COMPLETED
- The DTIME_COMPLETED column identifies the date and time that the job
was completed.
- DTIME_CREATED
- The DTIME_CREATED column identifies the date and time that the user
submitted the job to DB2 Query Patroller.
- DTIME_SCHEDULED
- The DTIME_SCHEDULED column identifies the date and time after which the
user scheduled the job to be run.
- DTIME_STARTED
- The DTIME_STARTED column identifies the date and time that the job
started running. If the job was canceled or aborted before the job
started running, this column contains a NULL value.
- ELAPSED_TIME
- The ELAPSED_TIME column identifies the elapsed time in seconds from
when the job started running until it completed.
- ELAPSED_TIME_LIMIT
- The ELAPSED_TIME_LIMIT column identifies the maximum number of
elapsed seconds a job will be permitted to run.
- ERROR_REASON
- The ERROR_REASON column identifies the reason why the job did not
complete successfully.
- ESTIMATED_COST
- The ESTIMATED_COST column identifies the estimated cost for the job in
accounting units, if one was derived. This column contains the value of
the estimated cost for the job multiplied by the cost factor from the Data
Source table.
- JOB_ID
- The JOB_ID column contains a number that identifies the job.
- JOB_PRIORITY
- The JOB_PRIORITY column contains the priority level number assigned to
the job.
- JOB_TEXT
- The JOB_TEXT column contains either the job's SQL statement or its
system command.
- JOB_TYPE
- The JOB_TYPE column contains either the letter S for SQL jobs or the
letter C for jobs containing system commands.
- NODE_ID_EXECUTED
- The NODE_ID_EXECUTED column identifies the host name of the node
where the job was run.
- NODE_ID_SUBMITTED
- The NODE_ID_SUBMITTED column identifies the node from which the job
was submitted.
- PREDECESSOR_JOB
- If the job was assigned a predecessor job (a job which must have
completed before this job could run), the PREDECESSOR_JOB column
contains the predecessor's job identifier. If no predecessor was
assigned, this column contains a NULL value.
- RESULT_DESTINATION
- If the user selected an alternative result destination, the
RESULT_DESTINATION column contains the identifier of the
destination. If the results were to be written to a result table
created in the database, this column contains a NULL value.
- RESULT_ROWS
- The RESULT_ROWS column contains the number of database rows that a job
selected, updated, deleted, or inserted.
- RESULT_ROWS_LIMIT
- The RESULT_ROWS_LIMIT column identifies the maximum number of rows a
SQL SELECT statement is allowed to return.
- RESULT_TABLE_OWNER
- The RESULT_TABLE_OWNER column contains the database identifier of
the owner of the result table, if it was created.
- RESULT_TABLE_NAME
- The RESULT_TABLE_NAME column contains the table name of the result
table, if it was created.
- SUBMIT_SOURCE
- The SUBMIT_SOURCE column contains the name of the program that
submitted the job.
- SUBMITTER_USER_ID
- The SUBMITTER_USER_ID column contains the system identifier of the
submitter of the job. This identifier could be different from the
job's owner if one user submitted the job on behalf of another
user.
- SYSTEM_TIME
- The SYSTEM_TIME column contains the number of CPU seconds of system
time consumed by the job.
- USER_ID
- The USER_ID column contains the system identifier of the job
owner.
- USER_TIME
- The USER_TIME column contains the number of CPU seconds of user time
consumed by the job.
[ Top of Page | Previous Page | Next Page ]