Use the nzstats command to display statistics about system capacity, faults, and performance.
nzstats [-h|-rev|-hc] subcmd [subcmd options]]
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:
|
nzstats show options | Displays the statistics from the System Group table. |
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. |
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
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
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
nzstats show -u user -pw password -host nzhost -colMatch "Num Data"
Field Name Value
-------------------- -----
Num Data Slices 3
Num Dataslice Issues 3