Archives of the TeradataForum
Message Posted: Wed, 19 Sep 2012 @ 19:46:03 GMT
Currently in our system we are getting a lot of problem of "error message 3278: No Monitor Session available"
We have 2 PEs and as per teradata there are four monitor sessions available for each PE and when I am running the below SQL to check the no of session which is logged in as monitor PM/API
sel IFPNo, count(*) from dbc.sessioninfo where Partition like '%monitor%' group by 1 order by 1; IFPNo Count(*) 1 16382 2 2 16383 2 UserName Partition IFPNo 1 DBCMANAGER MONITOR 16382 2 SYSDBA MONITOR 16383 3 DBCMANAGER MONITOR 16382 4 DBCMANAGER MONITOR 16383
Can you please help me in why we are not getting more session or what we can do to deal with this issue?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|