The Workstation Directory is used to make a connection to a remote database server. It is used in conjunction with the DCS Directory to make a connection to a remote host server. These directories define the overall database manager environment. Figure 1 offers a synopsis of these directories. DB2 employs several different types of memory structures to more efficiently process data.
Heaps are groupings of memory segments utilized for specific types of processing.
Every lock handled by the database manager requires a block of memory. As locks accumulate, memory is consumed. A section of memory, known as the lock list, must be configured for this purpose. The buffer pool is a memory block set aside as a staging area for database reads and writes. It contains the most recently used pages of data read from the database.