15.10 - TDWMLoadUtilStatistics - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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

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.

    Note: There is one record for every utility.

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