View sessions

You can use the nzsession command to display the list of current user sessions and to list the session types.

You can be logged in as any database user to use the nzsession show command; however, some of the data that is displayed by the command can be obscured if your account does not have correct privileges. The admin user can see all the information.

To list all active sessions, enter: 
nzsession show -u admin -pw password

ID    Type User  Start Time               PID  Database  Schema State Priority
Client IP Client Command
                                                                      Name
          PID
----- ---- ----- ----------------------- ----- --------- ------ ------ --------
--------- ------ ------------------------
43826 sql  ADMIN 24-Feb-13, 16:49:18 EST 14840 TPCH_HUGE ADMIN active normal
127.0.0.1 14839 select * from lineitem
43827 sql  ADMIN 24-Feb-13, 16:49:31 EST 15093 SYSTEM    ADMIN active normal
127.0.0.1 15092 SELECT session_id, clien
If you are a database user who does not have any special privileges, information such as the user name, database, client PID, and SQL command display only as asterisks:
nzsession show -u user1 -pw pass
ID    Type User  Start Time               PID  Database  Schema State Priority
Client IP Client Command
                                                                      Name
          PID
----- ---- ----- ----------------------- ----- --------- ------ ------ --------
--------- ------ ------------------------
43826 sql *****  24-Feb-13, 16:49:18 EST  14840 *****    *****  active normal
***** *****
43876 sql iser1 24-Feb-13, 16:54:27 EST 17257  SYSTEM    *****  active normal
127.0.0.1 17256 SELECT session_id, clien

To list session types, enter: nzsession listSessionTypes