The nzstats command

Use the nzstats command to display statistics about system capacity, faults, and performance.

Syntax

The nzstats command uses the following syntax:
nzstats [-h|-rev|-hc] subcmd [subcmd options]]

Inputs

The nzstats command takes the following inputs:
Table 1. The nzstats inputs
Input Description
nzstats listFields -type type Displays a numbered list of the fields for the specified type of group or table. Possible types are shown in the description of the nzstats listFields command. Each field in the list that is displayed corresponds to a column that can be displayed for the specified type of object by means of the nzstats show command.
nzstats listTypes Lists the types of objects for which you can display information:
dbms
DBMS Group.
system
System Group (this is the default).
database
Database Table.
host
Host Table.
hostCpu
Host CPU Table.
hostFileSystem
Host File System Table.
hostIf
Host Interface Table.
hostMgmtChan
Host Management Channel Table.
hostNet
Host Network Table.
hwMgmtChan
HW Management Channel Table.
query
Query Table.
queryHist
Query History Table.
spu
SPU Table.
spuPartition
SPU Partition Table.
table
Table Table.
tableDataSlice
Per Table Per Data Slice Table.
nzstats show options Displays the statistics from the System Group table.

Options

The nzstats show command takes the following options:
Table 2. The nzstats options
Option Description
-u user The database user name [NZ_USER].
-pw password The user password [NZ_PASSWORD].
-host name The host name or IP address [NZ_HOST].
-timeout secs The number of seconds to wait for the command to complete before it exits with a timeout error. The default is 300.
-type type The type of group or table that you want to show. The default is system. Possible types are shown in the description of the nzstats listFields command.
-cols list A list of numbers that correspond to the columns that are to be displayed (for example, 1,4,5). Each number corresponds to one of the numbered fields listed by the nzstats listFields command for the corresponding object type.
-colMatch str Display only the columns whose name contains the str string.
-orient type The output orientation (auto, horizontal, or vertical).
-fmtNum Format numbers in the output for improved readability.
-fmtMemFlds format Format memory fields with size options such as KB, MB, or GB for improved readability.
-allocationUnit units For the type table, the units in which disk space used value is displayed (usedbytes, extents, or usedblocks). The default is usedbytes.

Description

The nzstats command does the following:
Privileges required
Your database user account must have the Manage System privilege to show the actual system statistics. Any user can list the fields and types.
Common tasks
Use the nzstats command to display operational statistics. If you have a Netezza Performance Server Release 7.0.3 or later client, note that the command does not work with Netezza Performance Server systems that run a release earlier than 7.0.3 and which do not support multiple schemas within a database.

Usage

The following provides sample usage:
  • To list the types of objects for which statistics can be displayed:
    nzstats listTypes 
    Group/Table Type Description
    ---------------- ------------------------------
    dbms             DBMS Group
    system           System Group
    database         Database Table
    host             Host Table
    hostCpu          Host CPU Table
    hostFileSystem   Host File System Table
    hostIf           Host Interface Table
    hostMgmtChan     Host Management Channel Table
    hostNet          Host Network Table
    hwMgmtChan       HW Management Channel Table
    query            Query Table
    queryHist        Query History Table
    spu              SPU Table
    spuPartition     SPU Partition Table
    table            Table Table
    tableDataSlice   Per Table Per Data Slice Table
  • To list the fields (columns) of output that are generated for the system group:
    nzstats listFields -type system
    Col Field Name
    --- --------------------
    1   Name
    2   Description
    3   Contact
    4   Location
    5   IP Addr
    6   Up Time
    7   Up Time Text
    8   Date
    9   State
    10  State Text
    11  Model
    12  Serial Num
    13  Num SFIs
    14  Num SPAs
    15  Num SPUs
    16  Num Data Slices
    17  Num Hardware Issues
    18  Num Dataslice Issues
  • To display the first 9 columns of the system group:
    nzstats show -type system -cols 1,2,3,4,5,6,7,8,9
    Field Name   Value
    ------------ --------------------------------
    Name         bbnzdev-blh
    Description  <sys description>
    Contact      <contact name>
    Location     
    IP Addr      9.152.63.180
    Up Time      1827020 secs
    Up Time Text 21 days, 3 hrs, 30 mins, 20 secs
    Date         19-Dec-13, 15:51:48 CET
    State        8
  • To display the columns that match the string Num Data Slices:
    nzstats show -u user -pw password -host nzhost -colMatch "Num Data"
    Field Name           Value
    -------------------- -----
    Num Data Slices      3
    Num Dataslice Issues 3