Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    45

    Unanswered: Agent,application,statement

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    • 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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by stolze
    • 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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •