Table descriptions

Each table description includes information about the table, a description of each of the key columns, and a description of each of the data columns.

Key columns are marked with a K.

Data columns come after the last key column and are sorted in alphabetic order, with any underscores ignored.

The descriptions of most key columns and data columns contain references to the fields from which they are derived in the SMF record, such as "From BRFFLRTY." For an explanation of such fields, refer to the applicable IBM NetView Performance Monitor, IBM NetView, or IBM NetView File Transfer Program book.

The tables appear in alphabetic order, with any underscores ignored.

Note: Tables with similar contents (that is, tables with the same name but different suffixes) are described under one heading. For example, NW_ALERT_BASIC_H, _D, _W contains information about these similar tables:


NW_ALERT_BASIC_H
NW_ALERT_BASIC_D
NW_ALERT_BASIC_W

Except for the DATE column and TIME column, the contents of these tables are identical. For _W tables, the DATE column contains the first day of the week (weeks start on Monday). For _M tables, the DATE column contains the first day of the month. Differences in the contents of similar tables are explained in the column descriptions.

The DATE and TIME information is stored in the standard SQL format and displayed in the local format.

Hexadecimal codes in log records are stored as character data in Db2® tables. For example, a 2-byte field X'FFFF' is stored as a 4-byte character string FFFF.