What is DB2 agent ???

[ganeshmn25]

Hi folks,

Can any one tell me what is DB2 agent ????

Regards
Padmanaban.N

[spider007]

DB2 agent is the process which is responsible for carrying out work (be it executing SQL, etc.). Going forward in DB2 9.5, DB2 agent is a thread.

[Shashank1984]

On the client side, either local or remote applications, or both, are linked with the DB2 client library. Local clients communicate using shared memory and semaphores; remote clients use a protocol such as Named Pipes (NPIPE), or TCP⁄IP.

On the server side, activity is controlled by engine dispatchable units (EDUs). In all figures in this section, EDUs are shown as circles or groups of circles. EDUs are implemented as threads in a single process on Windows-based platforms and as processes on UNIX®. DB2 agents are the most common type of EDUs. These agents perform most of the SQL and XQuery processing on behalf of applications. Prefetchers and page cleaners are other common EDUs.

A set of subagents might be assigned to process the client application requests. Multiple subagents can be assigned if the machine where the server resides has multiple processors or is part of a partitioned database. For example, in a symmetric multiprocessing (SMP) environment, multiple SMP subagents can exploit the many processors.

All agents and subagents are managed using a pooling algorithm that minimizes the creation and destruction of EDUs.

You can read more on : DB2 architecture and process overview
so that you will get better understanding.. ....
You might have to read about new process model of V9.5, as we have changed it to multi threaded.

Thanks,
Shashank Kharche
IBM.
DB2 for Linux, Unix & Windows -Information Management Software

[ganeshmn25]

Ya i got it ...Thanks a lot !!!!!!!!!!!