Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: maximum number of agents has been exceeded

    Hi,
    I am getting the error as "maximum number of agents
    has been exceeded." When I looked into the list
    applications and counted on the no. of applications ,
    it is showing very less, [1/5]th of MAXAGENTS.
    The error message is as below. And all new client
    connections are being thrown out complaining the above

    reason. We have MAXAGENTS as 600 and no. of
    connections as 102. But I am seeing this error. oes
    'list applications' really say how many agents are
    there [applications]. If not which command should I
    use to get the total no. of agents.

    Any help is greatly appreciated.

    Thanks in advance
    Girish

    2004-06-16-21.31.27.839075 Instance:PKstdb2
    Node:000
    PID:30382(db2tcpcm 0) TID:1 Appid:none
    common communication sqlcctcpconnmgr_child Probe:125

    ADM7009E An error was encountered in the "TCPIP"
    protocol support. A possible cause is that the
    maximum number of agents has been exceeded.

    2004-06-16-21.31.27.868989 Instance:PKstdb2
    Node:000
    PID:30382(db2tcpcm 0) TID:1 Appid:none
    common communication sqlcctcpconnmgr_child Probe:126

    Return code from sqleGetAgent =
    0x0FFFFFFFFFFFA174 : 0xFFFFFB36

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    "list application" shows the total num. of connected app.

    Error does't tell much. Can you post the SQLCODE and SQLSTATE error number. Please also specify operat. system and db2 version + fp level. Command db2level will give you the info.

    Thanks,
    Grofaty

  3. #3
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    max agents is at the instance level (so for all active databases) There is a setting for each database that states the maximum number of connected applications (MAXAPPLS). If you have multiple databases up and running you may well exceed the total of 600 agents........
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

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