SYSCAT.HISTOGRAMTEMPLATES catalog view

Each row represents a histogram template.

Table 1. SYSCAT.HISTOGRAMTEMPLATES Catalog View
Column Name Data Type Nullable Description
TEMPLATEID INTEGER   Identifier for the histogram template.
TEMPLATENAME VARCHAR (128)   Name of the histogram template.
CREATE_TIME TIMESTAMP   Time at which the histogram template was created.
ALTER_TIME TIMESTAMP   Time at which the histogram template was last altered.
NUMBINS INTEGER   Number of bins in the histogram template, including the last bin that has an unbounded top value.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.