The Netezza nzstats command allows you to view sets of related operational information that is, statistics on the tables. These sets are organised as groups of related statistics or tables that contain rows of related statistics.
The statics are very much important in Netezza appliances. System uses the up-to-date stat information to plan and execute the queries. Netezza appliance works better if the system catalog tables have up-to-date stats.
Displaying System Statistics using Netezza nzstats Command
The Netezza nzstats command displays operational statistics about system capacity, system faults, and system performance. They provide you with a high-level overview of how your system is running and as well as other details so that you can understand performance characteristics.
You can also use the nzstats command to display the group and statistics tables.
Netezza nzstats command Examples
You can use the nzstats command to display the group and table types. You can also use the command to display specific fields within a group or table.
To list the tables, enter:
nzstats listTypes
To display specific fields of a table, enter:
nzstats listFields -type dataslice
You can also use the IBM provided Netezza NzAdmin tool to display statistics. You can check the table statistics by using Netezza admin tool.