Page 101 - DCAP408_WEB_PROGRAMMING

Unit 6: Memory Management (II)

 instance_memory: This parameter states how much memory is assigned for instance Notes
management.

 numdb: This parameter states the maximum number of simultaneous active databases that
dissimilar applications can use. Since each database has its own global memory area, the
quantity of memory that might be assigned increases if you increase the value of this
parameter.
 maxappls: This parameter states the maximum number of applications that can concurrently
connect to a single database. It affects the amount of memory that might be assigned for
agent private memory and application global memory for that database.

Did u know? This parameter can be set in a different way for every database.
 maxagents and max_coordagents for parallel processing: These parameters limit the
number of database manager agents that can subsist concurrently across all active databases
in an instance. Together with maxappls, these parameters limit the amount of memory
assigned for agent private memory and application global memory.
The memory tracker, invoked by the db2mtrk command, permits you to observe the current
assignment of memory inside the instance, involving the following types of information for
every memory pool:
 Current size

 Maximum size (hard limit)
 Largest size (high water mark)
On Unix and Linux, even though the ipcs command can be utilized to list all the shared memory
segments, it does not precisely reflect the amount of resources taken. You can use the db2mtrk
command as an substitute to ipcs.

Task Make distinction between Numdb and maxappls parameters.

Self Assessment

Fill in the blanks:
1. Memory may be assigned to a specific memory area when a stated ......................happens.
2. In an Enterprise Server Edition environment that includes numerous logical database
partitions, every database ...................... contains its own Database Manager Shared Memory
set.
3. The ...................... parameter states the size of the shared memory for the application group

4. An ...................... parameter states how much memory is assigned for instance management.
5. ......................parameter states the maximum number of applications that can concurrently
connect to a single database.

6. The database manager configuration parameter ...................... fixes an upper limit on the
number of applications that can attach to a database.

LOVELY PROFESSIONAL UNIVERSITY 95