By Whei-Jen Chen
Read Online or Download Sap Solutions on IBM DB2 Udb V8.2.2 Handbook PDF
Similar languages & tools books
SOA for the Business Developer: Concepts, BPEL, and SCA
Service-Oriented structure (SOA) is a manner of organizing software program. in case your company's improvement tasks adhere to the rules of SOA, the result may be a listing of modular devices referred to as "services," which permit for a fast reaction to alter. This ebook tells the SOA tale in an easy, trouble-free demeanour that can assist you comprehend not just the buzzwords and advantages, but in addition the applied sciences that underlie SOA: XML, WSDL, cleaning soap, XPath, BPEL, SCA, and SDO.
Extra info for Sap Solutions on IBM DB2 Udb V8.2.2 Handbook
Sample text
4 Agent private memory DB2 agents, such as coordinator agents or subagents, can allocate their own private memory area for memory that is only required by that specific agent, such as memory for private sorts or private application heap memory. Agent private memory is allocated for an agent when the agent is assigned as the result of a connect request or a new SQL request in a parallel environment. Agent private memory can grow as required, but freed memory is not necessarily returned to the operating system.
System and database administrators commonly examine the DB2 processes on their database servers to understand the DB2 activity and resource consumption within the server at various occasions, such as system planning and configuration, performance tuning, as well as health check and problem analysis. In this book we introduce the process model from a practical view in line with what you would normally see when you operate in DB2 environments. 1 Fault monitor facility If you maintain your DB2 databases on UNIX platforms, it is beneficial for you to understand the fault monitor facility as the first step before you look into the core of DB2 process model (see Figure 2-1).
The shared workspace used by an application group can be monitored via DB2 application snapshots. The application group shared heap is freed when the last connection in an application group terminates. The Application control heap is allocated from the application group shared memory and contains the information about a specific connection. Memory for table queues is also allocated from the application control heap. The application control heap is not freed when a connection terminates, but is reused by a subsequent connection.