DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: MTS Doubts!!!

  1. #1
    Join Date
    Nov 2000

    I have some doubts on MTS related stuff.

    1. CONNECTIONS & SESSION attributes of MTS_DISPATCHERS. I'm unable to understand the diff. I have gone through the help but I found it vague.

    CONNECTIONS (CON or CONN) Specifies the maximum number of network connections to allow
    for each dispatcher

    SESSIONS (SES or SESS) The maximum number of network sessions to allow for each dispatcher.

    I appreciate if someone can explain the differences between the above two.

    2. Setting Dispatcher Address


    In the above attributes of mts_dispatchers, host attribute is mentioned. Can I have dispatchers located on a different machine other than the database server? Or Is this attribute existing for paraller server configuration?

    Looking forward for your answers!!!

    Thanks in advance,


  2. #2
    Join Date
    Apr 2001

    The difference between connections and sessions is to do with connection pooling :-

    Imagine you wanted a dispatcher that could have 15 connections but only 10 doing any work. the remaining 5 would be idle (the pool). You have 10 physical network connections serving 15 clients.

    The mount of time an idle connection will wait in the pool is specified using the ticks option of the mts_dispatcher parameter.

    Not sure about second question.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.