Skip to content

How to read output of USAGE column for table $hist_table_access_1

How to read output of USAGE column of History database table “$hist_table_access_1”.

This column stores the integer value for the type of query ran against a database table.

QUERYHISTORYDB(ADMIN)=> select distinct USAGE from “$hist_table_access_1” order by 1;

OUTPUT:
USAGE
——-
1
2
3
4
5
8
9
16
32
64
65
128
256
512
(14 rows)

Here is how to understand what does this each integer stands for:

1 = selected
2 = inserted
4 = deleted
8 = updated
16 = truncated
32 = dropped
64 = created
128 = statsgenerated
256 = locked
512 = altered

Please note, there is no documentation from IBM on what 3,5,9 and 65 is for. This is something which runs internally with in Netezza.