Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2005
    Posts
    3

    Unanswered: SQL1040N - Max no of applications already connect to DB

    I am running DB2 8.2 on AIX 5L v5.2. This database is for Peoplesoft CRM. However we have an outside Java application connecting in. It is using the JDBC driver bundled with the DB2 client. My configuation is :

    Instance:
    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 400
    Agent pool size (NUM_POOLAGENTS) = 200(calculated)
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INI)
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS

    DB:
    Max number of active applications (MAXAPPLS) = 150
    Average number of active applications (AVG_APPLS) = 1
    Max DB files open per application (MAXFILOP) = 256
    Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000
    Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
    Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 512

    When I get the SQL1040N error, I can no longer force applications on the database. It seems to just hang. Also when I do a db2 list applications it is only about 50 connections. Am I missing a parameter that is limiting the number of connections?

    Auth Id Application Appl. Application Id DB # of
    Name Handle Name Agents
    -------- -------------- ---------- ------------------------------ -------- -----
    QUOTEIT db2jcchttp-808 491 GA0C0AF8.H0AB.010614F2E3EB CR881PRD 1
    QUOTEIT db2jcchttp-808 391 GA0C0AF8.H0AA.010614F2DFF3 CR881PRD 1
    QUOTEIT db2jcchttp-808 361 GA0C0AF8.H0A9.010614F2DDA2 CR881PRD 1
    QUOTEIT db2jcchttp-808 382 GA0C0AF8.H0A8.010614F2DC3A CR881PRD 1
    QUOTEIT db2jcchttp-808 471 GA0C0AF8.H0A7.010614F2DAE3 CR881PRD 1
    QUOTEIT db2jcchttp-808 349 GA0C0AF8.H0A6.010614F2D341 CR881PRD 1
    QUOTEIT db2jcchttp-808 371 GA0C0AF8.H0A5.010614F29F22 CR881PRD 1
    QUOTEIT db2jcchttp-808 478 GA0C0AF8.H0A4.010614F29AAD CR881PRD 1
    QUOTEIT db2jcchttp-808 332 GA0C0AF8.H090.010614F0FB29 CR881PRD 1
    QUOTEIT db2jcchttp-808 399 GA0C0AF8.H08F.010614F0F03D CR881PRD 1
    QUOTEIT db2jcchttp-808 306 GA0C0AF8.H08E.010614F0C257 CR881PRD 1
    QUOTEIT db2jcchttp-808 421 GA0C0AF8.H08D.010614F0BD56 CR881PRD 1
    QUOTEIT db2jcchttp-808 133 GA0C0AF8.H08C.010614F07A81 CR881PRD 1
    QUOTEIT db2jcchttp-808 433 GA0C0AF8.H08B.010614F05D35 CR881PRD 1
    QUOTEIT db2jcchttp-808 120 GA0C0AF8.H08A.010614F04A0B CR881PRD 1
    QUOTEIT db2jcchttp-808 480 GA0C0AF8.H089.010614F03ABA CR881PRD 1
    QUOTEIT db2jcchttp-808 344 GA0C0AF8.H088.010614F030C7 CR881PRD 1
    QUOTEIT db2jcchttp-808 189 GA0C0AF8.H087.010614F0206B CR881PRD 1
    CR881PRD db2bp 418 *LOCAL.cr881prd.050902031825 CR881PRD 1
    QUOTEIT db2jcchttp-808 467 GA0C0AF8.GE69.0106149FFDB2 CR881PRD 1
    QUOTEIT db2jcchttp-808 107 GA0C0AF8.GE15.01061492F2E2 CR881PRD 1
    CRPRDADM PSMONITORSRV 223 *LOCAL.cr881prd.050902000121 CR881PRD 1
    CRPRDADM PSMONITORSRV 225 GA0C0AF3.C20C.000A12000115 CR881PRD 1
    SWAGNER QuestCentral.e 24 GA0C130C.FD05.0188C1212844 CR881PRD 1
    SWAGNER QuestCentral.e 351 GA0C130C.C005.016C41212406 CR881PRD 1
    QUOTEIT db2jcchttp-808 51 GA0C0AF8.H2B2.010612AAE6D3 CR881PRD 1
    CR881PRD DB2HMON 430 *LOCAL.cr881prd.050901100812 CR881PRD 1
    CR881PRD DB2HMON 407 *LOCAL.cr881prd.050901100810 CR881PRD 1
    CRPRDADM PSPPMSRV 16 GA0C0AF3.D5BE.0D03B9000152 CR881PRD 1
    CRPRDADM PSPPMSRV 441 GA0C0AF3.D5B9.010EF9000147 CR881PRD 1
    CRPRDADM PSPPMSRV 368 GA0C0AF3.D5B4.0C0D39000143 CR881PRD 1
    CRPRDADM PSPRCSRV 411 *LOCAL.cr881prd.050829000150 CR881PRD 1
    CRPRDADM PSSAMSRV 369 GA0C0AF3.D5AC.070A39000135 CR881PRD 1
    CRPRDADM PSDSTSRV 375 *LOCAL.cr881prd.050829000142 CR881PRD 1
    CRPRDADM PSSAMSRV 477 GA0C0AF3.D5A5.090C59000128 CR881PRD 1
    CRPRDADM PSAESRV 367 *LOCAL.cr881prd.050829000134 CR881PRD 1
    CRPRDADM PSAESRV 409 *LOCAL.cr881prd.050829000130 CR881PRD 1
    CRPRDADM PSSAMSRV 455 GA0C0AF3.D59D.0405B9000121 CR881PRD 1
    CRPRDADM PSAESRV 425 *LOCAL.cr881prd.050829000122 CR881PRD 1
    CRPRDADM PSAESRV 438 *LOCAL.cr881prd.050829000118 CR881PRD 1
    CRPRDADM PSAPPSRV 372 GA0C0AF3.D595.0A0379000112 CR881PRD 1
    CRPRDADM PSAESRV 510 *LOCAL.cr881prd.050829000110 CR881PRD 1
    CRPRDADM PSAESRV 216 *LOCAL.cr881prd.050829000106 CR881PRD 1
    CRPRDADM PSAPPSRV 396 GA0C0AF3.D58D.0B0219000102 CR881PRD 1
    CRPRDADM PSAESRV 293 *LOCAL.cr881prd.050829000058 CR881PRD 1
    CRPRDADM PSAPPSRV 72 GA0C0AF3.D584.080CD9000052 CR881PRD 1
    CRPRDADM PSAESRV 297 *LOCAL.cr881prd.050829000050 CR881PRD 1
    CRPRDADM PSAESRV 336 *LOCAL.cr881prd.050829000046 CR881PRD 1
    CRPRDADM PSAPPSRV 415 GA0C0AF3.D57B.070B79000042 CR881PRD 1
    CRPRDADM PSAESRV 39 *LOCAL.cr881prd.050829000038 CR881PRD 1
    CRPRDADM PSAPPSRV 141 GA0C0AF3.D573.0B07B9000029 CR881PRD 1
    CRPRDADM PSMSTPRC 159 *LOCAL.cr881prd.050829000028 CR881PRD 1

  2. #2
    Join Date
    Jan 2004
    Posts
    49

    Question EEE or Non-EEE??

    My doubt is, if it is EEE environment, u have to get the list applications globally by using "db2 list applications global" and check the number of connections.

    I'm assuming u r using EEE environment.

    With Regards

    Bala

  3. #3
    Join Date
    Aug 2005
    Posts
    3
    I do not have EEE, I have a single instance on a single machine.

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    Check intra_parallel instance parameter, if intra_parallel is enabled , db2 invokes multiple agenets to process request.

    The list applications show detail will give you the no of agents handling each request.

    Check your db2diag.log file.

    use db2 get snapshot for dbm|grep 'Agents'

    check the corodinating agents and agent registered.
    Also check the agents created from empty pool.
    check your connection concentration MAX_CONNECTIONS > MAX_COORDAGENTS

    if you have less than 200 connections, don't turn that on.


    regards,

    mujeeb

  5. #5
    Join Date
    Aug 2005
    Posts
    3
    intra_parallel is set to no at the instance level.

    here is what I got from "db2 get snapshot for dbm|grep 'Agents'"

    Agents assigned from pool = 3447
    Agents created from empty pool = 92
    Agents stolen from another application = 0

    High water mark for coordinating agents = 57
    Remote connections to db manager = 32
    Remote connections executing in db manager = 0
    Local connections = 15
    Local connections executing in db manager = 0
    Active local databases = 1

    High water mark for agents registered = 57
    High water mark for agents waiting for a token = 0
    Agents registered = 57
    Agents waiting for a token = 0
    Idle agents = 6

    I don't believe this is anything unusual.

  6. #6
    Join Date
    Mar 2004
    Posts
    448
    Only thing that I check is

    Agents created from empty pool = 92.

    Agents assigned from pool = 3447

    means 33% of the time , you need to create agent..

    sometimes agents do have creation problem , because of the OS constraint
    and some other reason.

    I will look into the aix limits like maxproc etc.
    and the no of processes runing at the OS level.

    regards,

    mujeeb

Posting Permissions

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