Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: maxappls needs to be increased. What other parameter should be modified?


    Application team is addingone new feature in the application and expecting more no of connections hence we have to increase the value of maxappls database parameter.

    Currenlty we have maxappls = 600

    dbm parameter :
    Max number of existing agents (MAXAGENTS) = 1000
    Agent pool size (NUM_POOLAGENTS) = 200
    Initial number of agents in pool (NUM_INITAGENTS) = 150
    Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS

    I know min of maxagent or maxapps can be the max no of application connections.

    What other parameter we should change ?

    We are running db2 9.1 FP4 at Sun Solaris.


  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    You may want to take a look at maxuprc (Solaris)

Posting Permissions

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