Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    8

    Unanswered: some questions about dbm and db cfg

    Operating System Information:

    OSName: SunOS
    NodeName: domain5
    Version: Generic_117000-03
    Release: 5.8
    Machine: sun4u

    Instance db2inst1 uses 32 bits and DB2 code release SQL08020
    with level identifier 03010106
    Informational tokens are DB2 v8.1.0.72, s040914, U498351, FixPak 7.


    Max number of existing agents (MAXAGENTS) = 1000
    Maximum query degree of parallelism (MAX_QUERYDEGREE) = 8
    Enable intra-partition parallelism (INTRA_PARALLEL) = YES

    Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 100000
    Percent of mem for appl. group heap (GROUPHEAP_RATIO) = 70
    Max appl. control heap size (4KB) (APP_CTL_HEAP_SZ) = 512

    I have serval question:
    1. The maxconnections=min(1000,100000/512)=195
    is it right?
    2. when (INTRA_PARALLEL) = YES
    the memory is : 100000*4k*0.7 is shared , for every application 512*4k*0.3 is allowed
    when (INTRA_PARALLEL) = no

    for every application 512*4k is allowed
    is it right?

    3. how can estimate the number of subagents and monitor active agents counts and subagent counts?


    anybody helps me ,thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    One of the things on SunOS is that to identify DB2 process using ps will show only 'db2sysc'. Use db2ptree to get the right picture.

    HTH.

Posting Permissions

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