Archives of the TeradataForum

Message Posted: Wed, 19 Sep 2012 @ 19:46:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

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?

	<Prev	Next>		<<First	<Prev	Next>	Last>>