The DBQLUtilityTbl is populated if you use the WITH UTILITYINFO option for BEGIN/REPLACE QUERY LOGGING. Each row of the QryLogUtilityV view of the DBQLUtilityTbl stores information for one completed load/export utility or Data Stream Architecture job.
Phases
The following table describes the different column phases shown in QryLogUtilityV:
Utility Protocols | Phase Zero Name | Phase One Name | Phase Two Name | Phase Three Name | Phase Four Name |
---|---|---|---|---|---|
FASTLOAD MLOAD MLOADX |
Setup | Acquisition | Application | Cleanup | N/A |
FastExport | Setup | Select | Export | Cleanup | N/A |
DSA | N/A | Dictionary | Data | Build | Postscript |
Phase1 and Phase2 columns are used for the required phases. Phase0, Phase3, and Phase4 columns are used for the optional phases.
Possible Values for CPUDecayLevel
CPUDecayLevel is the decay level reached for CPU usage per AMP, for requests using the default Timeshare workload management method. Possible values are:
Value | Description |
---|---|
0 | Indicates that the request is running at the default priority. |
1 | Indicates that the priority level is reduced and the resource allotment is halved. |
2 | Indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more. |
Possible Values for IODecayLevel
IODecayLevel is the decay level reached for I/O usage per AMP, for requests using the default Timeshare workload management method.
Value | Description |
---|---|
0 | Indicates that the request is running at the default priority. |
1 | Indicates that the priority level is reduced and the resource allotment is halved. |
2 | Indicates that the priority level is reduced again, the resource allotment is halved again, and it will not be reduced more. |
Possible Values for MaxDataWaitTimeID
- For FastLoad, MultiLoad, and FastExport: The ID of the AMP owning the utility session with the highest data wait time.
- For MLOADX: The session number of the session with the highest data wait time.
- For DSA: The ID of the stream with the highest data wait time.
Possible Values for UtilityRequest
UtilityRequest is the main utility SQL request for the job. It contains the target database and/or table names. The possible statements are:
- BEGIN LOADING (FastLoad)
- BEGIN MLOAD (MLOAD/MLOADX)
- SELECT (FastExport)
- DUMP/RESTORE (DSA)