How to Resolve Netezza too many Concurrent Sessions issue?

  • Post author:
  • Post last modified:February 27, 2018
  • Post category:Netezza
  • Reading time:3 mins read

If you are working on the Netezza with the heavy load on it then you might have seen the Netezza too many concurrent sessions issue when you try to connect to the Netezza system. You may get this issue while connecting to Netezza from Aginity workbench or from Putty.

In this article, we will see how to resolve Netezza too many concurrent session issue.

Check Netezza too many Concurrent Sessions issue

To verify the concurrent sessions follow below steps:

Login to Netezza either from Putty or from Aginity Workbench and connect to Netezza SYSTEM database.

Usually, each Netezza user is allowed four concurrent connections yo the Netezza system. You have to check if any of these sessions are stuck in the ‘Connect’ state.

Use below query to verify of the user sessions are in ‘Connect‘ state:

select * from system.._v_session where username like 'xxxxxx';

If the Netezza user who got error does not have any sessions in the ‘Connect’ state, then they cannot have their concurrent session limit increased.

Identify Netezza user Session limit

Use the below query to calculate the sessions. You can use result of below query in alter user command to increase the sessions:

SELECT count(1)+4 as concurrent_sessions, 
USERNAME 
FROM SYSTEM.._V_SESSION_BRIEF
 where upper(SESSION_STATE_NAME) = upper('connect') and CLIENT_PID = 0 
group by USERNAME;

Increase Session Limit

Login to Netezza and connect to the source database that the concurrent session that has the too many concurrent sessions.

Execute the following alter user command to increase the sessions:

alter user USERNAME concurrent sessions <concurrent_sessions>;

<concurrent_sessions> : You can get this value from Identify Netezza session limit query

Also Read:

Tags: