Results 1 to 2 of 2

Thread: Sql0900n

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: 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

  2. #2
    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
    Last edited by nitingm; 12-18-03 at 10:12.
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •