Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Error 3278: No Monitor Session available
From:   Ahmad, Syed Rehan

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023