Results 1 to 5 of 5

Thread: engine

  1. #1
    Join Date
    Jan 2011
    Posts
    24

    Unanswered: engine

    I hear people saying "db2 engine". What does this mean? db2 optimizer?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Basically everything running under db2sysc. Things not in the engine are separate programs such as db2look, db2move, Command Line Processor, etc, although these separate programs may invoke the DB2 db2sysc process to execute DB2 engine commands. Another example is SQL Replication, where most of it is done via separate processes outside the DB2 engine.
    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
    Jun 2007
    Location
    germany
    Posts
    155
    before you pummel us with 'what is this, what is that',
    this introductory-level article Everything You Wanted to Know About DB2 Universal Database Processes
    could be of some interest to you.
    Dick Brenholtz, Ami in Deutschland

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by dbzTHEdinosaur View Post
    before you pummel us with 'what is this, what is that',
    this introductory-level article Everything You Wanted to Know About DB2 Universal Database Processes
    could be of some interest to you.
    That's interesting, but IBM significantly rewrote how the process model works when version 9.5 was introduced and that article is from 2003.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    thanks for the link to the 'updated' process documentation.
    Dick Brenholtz, Ami in Deutschland

Posting Permissions

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