Skip to content

How to find the blower details in a SPA – Netezza

How to find the blower details in SPA 4 (i.e. mm004) of your Netezza Twinfin appliance.

RUn below command as nz and you will get all the required info regarding this blower.

MyServer:/export/home/nz->ssh mm004 info -T blower[1]

system> info -T blower[1]
UUID: 8EE0 3CED CS05 14DE B51E 0919 9432 C5E6
Manufacturer: IBM (epM)
Manufacturer ID: 20301
Product ID: 64
Mach type/model: Chassis Cooling Dev
Mach serial number: Not Available
Manuf date: 4509
Hardware rev: 5
Part no.: 44E8110
FRU no.: 44E5083
FRU serial no.: YK10CD8E6060
CLEI: Not Available
Status: critical
Speed ( % of Max): 0%
Avg RPM: 0
Control State: Operational
VPD: 14

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.