Skip to content

Nzstop vs Nzsystem stop

Difference between nzstop and nzsystem stop?

Nzstop –> Stops Netezza immediatelly by kiling the currently running queries. This is the recomended command to stop Netezza.
NOTE: You can run nzstart/nzstop directly on server only. You cannot issue these commands from a client machine.

nzsystem stop –> Waits for the current active queries to complete before stopping. All the queued and new requests are killed.

nzsystem stop -now –> Just like nzstop, this command also stops Netezza immediatelly by kiling the currently running queries.
NOTE: when you use “-now” with any state like pause, offline, restart, and stop system will abort all the running transactions and will immediately chnage to that state.