Use the nzsystem command to change the system state, and show and set configuration information.
nzsystem [-h|-rev|-hc] subcmd [subcmd_options]
Input | Description |
---|---|
nzsystem offline options | Takes the system offline. |
nzsystem pause options | Pauses the system. Use this command to pause the system for administrative work, but allow all current transactions to complete. |
nzsystem restart options | Stops and then automatically restarts the system. |
nzsystem resume options | Returns the system to the online state. |
nzsystem set options | Configures a system setting. Restriction: Do not
change your system settings unless directed to do so by IBM® Netezza® Support.
|
nzsystem showRegistry options | Displays the system configuration registry. |
nzsystem showRev options | Displays the system software revision level. |
nzsystem showState options | Displays the system state. This is the default subcommand if you type the nzsystem command without any subcommands. It is also the same as the nzstate show command. |
nzsystem showIssues | Displays any hardware or dataslice issues that are found on the system. |
nzsystem stop options | Stops the system. |
Command | Option | Description |
---|---|---|
All nzsystem commands | -u user | Specifies the database user name [NZ_USER]. |
-pw password | Specifies the user password [NZ_PASSWORD]. | |
-host name | Specifies the host name or IP address [NZ_HOST]. | |
-timeout secs | Specifies the number of seconds to wait for the command to complete before it exits with a timeout error. The default is 300. | |
offline, pause, restart, set, stop | -force | Does not prompt for confirmation. |
offline, pause, restart, stop | -now | Aborts the transactions that cannot be restarted after the state transition. |
-nowAfter seconds | Specifies the time for the work to finish before it resorts to -now. The default is 300 seconds. | |
set | -regFile file_name | Loads the registry configuration file. |
-arg | Specifies the configuration argument and its value. Some configuration arguments take a comma-separated list of multiple values. (<tag>=<value[, value,...]>). | |
-ignoreErrors | Skips unavailable or erroneous settings. | |
showRev | -build | Shows the build string for the IBM Netezza software as set by the Configuration Manager (CM). |
-label | Shows the label version of the build string. |
nzsystem offline -u user -password password -host nzhost
To start the system again, use the nzsystem resume command.
nzsystem pause -u user -password password -host nzhost
To start the system again, use the nzsystem resume command.
nzsystem restart -u user -password password -host nzhost -now
nzsystem resume -u user -password password -host nzhost
nzsystem set -u user -password password -host nzhost -regFile
MaxReboot FreqPerHr
nzsystem showRegistry -u user -password password -host nzhost
nzsystem showRev -u user -password password -host nzhost
nzsystem showState -u user -password password -host nzhost
[nz@nzhost ~]$ nzsystem showIssues
Hardware Issues :
Description HW ID Location Role State
----------- ----- -------------------- ------ --------
Disk 1030 spa2.diskEncl1.disk1 Failed Ok
Disk 1031 spa2.diskEncl1.disk2 Failed Ok
PowerSupply 1113 spa1.diskEncl1.pwr1 Active Critical
Disk 1118 spa1.diskEncl1.disk2 Failed Ok
Dataslice Issues :
Data Slice Status SPU Primary Storage Mirror Storage % Used
---------- ---------- ---- ---------------- --------------- -------
5 Unmirrored 1194 1139 95.90
6 Unmirrored 1194 1139 95.63
nzsystem stop -u user -password password -host nzhost
To start the system again, use the nzstart command.