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.

Netezza – nzstart errors out

ISSUE:
nzstart fails to start Netezza

ERROR:
You will find below error in /nz/kit/log/startupsvr/startupsvr.log
Error: NZ-00305: program ‘initvrels’ stopped unexpectedly after 10 seconds with status 1.

ALso, you may not be able to see any message logged in sysmgr.log for this startp attempt because nzstart failed even before sysmgr background service was started.

RESOLUTION:
The above error message shows there was an NPS program that failed to start. One possible cause is a lock file conflict between the nzhealthcheck service and NPS. If this issue occurs once in a while then follow below steps as a work around.

Run ‘service nzhealthcheck stop’ to stop nzheathcheck service then issue nzstart. Once Neteza is started then issue ‘service nzhealthcheck start’ to restart nzhealthcheck service.

Note, this is just a work around and the actual issue needs to be resolved with IBM.