TDWMLoadUtilStatistics Function | Application Programming Reference | Vantage - 17.10 - TDWMLoadUtilStatistics - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Returns the statistics on the load utilities that are available in the system.

Syntax

REPLACE FUNCTION TDWM.TDWMLoadUtilStatistics (
) RETURNS TABLE (
    UtilityType VARCHAR(10) CHARACTER SET LATIN,
    UtilityCount SMALLINT,
    UtilityLimit SMALLINT
  )
  ...
;

Syntax Elements

UtilityType
Type of utility:
  • 0 = MultiLoad + FastLoad
  • 1 = MultiLoad
  • 2 = FastLoad
  • 3 = FastExport
  • 4 = ARC
  • 5 = Standalone Mload
  • 6 = Standalone FastLoad
  • 7 = Standalone FastExport
  • 8 = TPT update Op: MultiLoad
  • 9 = TPT load Op: Fastload
  • 10 = TPT export Op: FastExport
  • 11 = JDBC MultiLoad
  • 12 = JDBC FastLoad
  • 13 = JDBC FastExport
  • 14 = CSP Save Dump (FastLoad)
  • 15 = DSA
  • 16 = DSA Backup
  • 17 = DSA Restore
  • 18 = MLOADX
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
       .
       .
       .