Question & Answer
Question
How do I kill all user sessions or queries and deny users access to NPS?
Cause
As the database administrator, you may need to stop all queries and prevent users from accessing NPS without stopping or restarting the processes.
Answer
This document assumes that you have installed the Netezza Contributed Toolkit. If you have not, refer to the document, "Installing the Netezza Contributed Toolkit".
To kill all user sessions and transactions, do the following:
1. Use the nz_abort_user script as described in the related document, "Script to terminate database sessions owned by a given user".
2. The Netezza Contributed Toolkit contains a script, nz_maintenance_mode.
To close database access, run the command as the 'nz' user as follows where <release> is specific to your environment:/nz/support/contrib/bin/<release>/nz_maintenance_mode -on
To restore user access to the databases, run the following command as the 'nz' user:
/nz/support/contrib/<release>/bin/nz_maintenance_mode -off
Related Information
Historical Number
NZ034864
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21573542