Purpose
Returns the statistics on the load utilities that are available in the system.
Definition
REPLACE FUNCTION TDWM.TDWMLoadUtilStatistics() RETURNS TABLE (UtilityType VARCHAR(10) CHARACTER SET LATIN, UtilityCount SMALLINT, UtilityLimit SMALLINT ) . . . ;
Result Rows
Column Name | Description |
---|---|
UtilityType | Type of utility:
|
UtilityCount | Number of utilities of this type that are active. |
UtilityLimit | Current limit on the number of utilities of this type. |
There is one record for every utility.
Example: Using TDWMLoadUtilStatistics
SELECT * FROM TABLE (TDWM.TDWMLoadUtilStatistics()) AS t1; *** Query completed. 4 rows found. 3 columns returned. *** Total elapsed time was 3 seconds. UtilityType UtilityCount UtilityLimit ----------- ------------ ------------ MultiLoad 0 30 FastLoad 0 30 FastExport 0 60 ARC 0 350 . . .