Troubleshooting
Problem
How to get rid of a session without restarting NPS.
Symptom
For example, there is a session where the user running the query had a communication link failure, but the query continued running and when trying to abort the session it will not abort and you cannot restart NPS.
[nz@system ~]$ nzsession abortTxn -u admin -pw password -id 12345678 -force
[nz@system ~]$ nzsession abort -u admin -pw password -id 12345678 -force
Error: 306 second timeout expired before command completed, exiting.
nzsession abortTxn: Abort a user transaction, the user session remains active.
nzsession abort: Abort a running user session, the user is disconnected.
Environment
IBM PureData System for Analytics with any NPS release.
Resolving The Problem
When nzsession abortTxn/abort do not help the session may be removed by pausing and resuming the system.
1) Run this command : nzsystem pause
This command pauses the system. Use this command to pause the system for administrative work, but allow all current transactions to complete.
2) Run this command : nzsystem resume
This command returns the system to the online state.
Product Synonym
pda netezza
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21700753