TDWMLoadUtilStatistics

Teradata® Database Application Programming Reference

brand
Software
prodname
Teradata Database
vrm_release
16.20
category
Programming Reference
featnum
B035-1090-162K

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:
  • 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
       .
       .
       .