Describe major components of DB2?

devquora
devquora

Posted On: Nov 23, 2022

 

DB2 is a huge relational database management system with many components in it. The four major components of DB2 are:

  • System services component: It supports system operations, other communication, logging, and similar functions. It handles startup and shutdowns.
  • Locking services component: It provides the necessary controls for managing concurrent access to data. This component is known as Internal Resource Lock Manager (IRLM) and it manages the concurrency issues and deadlocks.
  • Database services component: It supports the definition, retrieval, and update of user and system data. It is responsible for the execution of SQL statements and it also manages the buffer pool.
  • Distributed data facility component: It provides DB2s, and distributed database support.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    DB2 Interview Questions

    What is DB2 and what is the use of DB2 Optimizer?

    DB2 is a huge relational database management system for the MVS (Multiple Virtual storages) operating systems, where th..

    DB2 Interview Questions

    Mention data types used in DB2 ?

    The data types used in DB2 are: SMALLINT DECIMAL CHAR FLOAT INTEGER VARCHAR DATE TIME ..

    DB2 Interview Questions

    What is Buffer pool and list some of them?

    It is a reserved main storage which is to satisfy the buffer needs for one or more tablespaces or indexes. It is made u..