Can anyone here please tell me the relationships that exist between an agent,application and statement


I know that any new connection will be allocated an agent and is it true that one agent can kick off multiple applications and each applications might have multiple statements

Please tell me if i I am correct r not

Thanks

Generally, one application connection has one agent, unless one of the following occur (in which case there may be multiple agents):

• A parallel acess path is chosen by DB2 (intra-partition parallelism) for a given SQL statement.
• A utility uses parallelism (such as backup, etc). See the Command Reference for details.
• A few other unusual cases that I can't remember

.

A given agent can run multiple SQL statements.

• An application can have multiple connections.
• A connection is the same as a session.
• A SQL statement is always executed on a single connection.
• Each connection has a single coordinator agent. As Mark said, each coordinator agent can use several additional subagents that do work in parallel.

In DB2, an application and connection is sometimes used synonymously. When you issue the command "list applications" you see a list of connections.