If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Sql0900n

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-03, 09:59
jagan_5378 jagan_5378 is offline
Registered User
 
Join Date: Nov 2003
Posts: 68
Sql0900n

hi to all
pl tell me we are using db2 version 7.2 on linux 6.2
we are haveing one server 20 dum terminals.
everry time they will connect to server.
max 25 users will connecting continuously.
some times automatically disconnected. y
pl tell me y it is disconnecting from database.
is there any parameter settings is there.


thank u
Reply With Quote
  #2 (permalink)  
Old 12-18-03, 09:07
nitingm nitingm is offline
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
Max_Connections

Hi Jagan

Please check the value of Max_Connections probably that is limited.

Please also check if you have sufficient agents allocated at the instance level.

The error code says that it has something do with the application disconnecting abruptly and firing new threads on reconnecting. Is it the case with you?? Try taking a snapshot for applications that would yield some clue.

HTH

Nitin
__________________
HTH

Nitin

Ask the experienced rather than the learned

Last edited by nitingm; 12-18-03 at 09:12.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On