Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2004
    Posts
    16

    Question Unanswered: Number of agents

    What determines the number of agents an application opens?

    I have four databases within one instance (DB2 V8.2 on Linux) and when I list applications one database always shows 3 agents for each connected application. All the other databases only have 1 agent per connection.

    All the parameters that would seem to have anything to do with the number of agents are set in the DBM configuration. There has to be a configuration parameter at the database configuration that controls this, but I havn't been able to find it.

    I haven't been able to find much helpful info about this in the doc.
    Thanks for you input in advance
    Bob.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by winterb
    when I list applications one database always shows 3 agents for each connected application
    Is this a partitioned database, by any chance?

    Could you provide a sample of the LIST APPLICATIONS output?

  3. #3
    Join Date
    Jun 2004
    Posts
    16
    It's not a partitioned database.

    Here's a sample of the list applictions output.


    Auth Id Application Appl. Application Id DB # of
    Name Handle Name Agents
    -------- -------------- ---------- ------------------------------ -------- -----
    PUB db2jccServlet. 416 GA32281D.N293.041220141458 INV 3
    PUB db2jccServlet. 450 GA32281C.C1A2.041220132050 INV 3
    HR db2jccmain 330 GA65214D.H192.041220161446 HRP 1
    HR db2jccServlet. 288 GA32281C.HEA2.041220161435 HRP 1
    HR db2jccmain 68 GA65C94A.AB89.041220160749 HRP 1
    HR db2jccServlet. 504 GA32281D.KDC1.041220154116 HRP 1

    Thanks again.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Do you have intra-partition parallellism enabled? If you have DFT_DEGREE set to 2 I guess you'll have 3 agents working on an applications: a coordinator agent and two subagents.

  5. #5
    Join Date
    Jun 2004
    Posts
    16
    Thanks, it looks like the DFT_DEGREE is the difference. It is set to "ANY" on the database that has 3 agents. It is set to 1 on the other databases. That would seem to explain it.

    Thanks again for the info.
    Bob

  6. #6
    Join Date
    Jun 2004
    Posts
    16
    Thanks, it looks like the DFT_DEGREE is the difference. It is set to "ANY" on the database that has 3 agents. It is set to 1 on the other databases. That would seem to explain it.

    Thanks again for the info.
    Bob

Posting Permissions

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