DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.HISTOGRAMTEMPLATEUSE catalog view

Each row represents a relationship between a workload management object that can use histogram templates and a histogram template.

Table 1. SYSCAT.HISTOGRAMTEMPLATEUSE Catalog View
Column Name Data Type Nullable Description
TEMPLATENAME VARCHAR (128) Y Name of the histogram template.
TEMPLATEID INTEGER   Identifier for the histogram template.
HISTOGRAMTYPE CHAR (1)   The type of information collected by histograms based on this template.
  • C = Activity estimated cost histogram
  • E = Activity execution time histogram
  • I = Activity interarrival time histogram
  • L = Activity life time histogram
  • Q = Activity queue time histogram
  • R = Request execution time histogram
OBJECTTYPE CHAR (1)   The type of WLM object.
  • b = Service class
  • k = Work action
  • w = Workload
OBJECTID INTEGER   Identifier of the WLM object.
SERVICECLASSNAME VARCHAR (128) Y Name of the service class.
PARENTSERVICECLASSNAME VARCHAR (128) Y The name of the parent service class of the service subclass that uses the histogram template.
WORKACTIONNAME VARCHAR (128) Y The name of the work action that uses the histogram template.
WORKACTIONSETNAME VARCHAR (128) Y The name of the work action set containing the work action that uses the histogram template.
WORKLOADNAME VARCHAR (128) Y The name of the workload that uses the histogram template.