IBM Db2 11.1 Certification Guide

Histogram templates

A histogram template is a graphical representation of tabulated frequencies. Histogram templates are used by service subclasses and work actions to define the bin values for the statistics that are maintained using histograms.

If you want to create a lifetime histogram for a direct sales high bin value of 50,000, you can do so by executing the CREATE HISTOGRAM statement, as shown in the following:

    -- Creating a histogram
    
    CREATE HISTOGRAM TEMPLATE HIST_DIRECTSALES HIGH BIN VALUE 50000;
    
    -- Creating a subclass
    
    CREATE SERVICE CLASS DIRECTSALES UNDER SALES ACTIVITY LIFETIME HISTOGRAM TEMPLATE HIST_DIRECTSALES;