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.