Top Interview Questions on DB2

Storage group is a storage path where data can be stored. A table space can also be assigned to storage group. In IBM Db2, a storage group, commonly referred to as STOGROUP, is a logical grouping of storage volumes. It is used to simplify database administration by providing a way to manage the physical storage … Read more

Data manager is a DB2 component that is responsible to manage physical database. It performs logging and locking by invoking other system components. In the context of IBM’s DB2 database management system, the term “Data Manager” typically refers to a component responsible for managing and controlling access to the database. The Data Manager in DB2 … Read more

Buffer pool is part of main memory space. This space is allotted by the database manager. It cache table and index data from the disk. In the context of IBM Db2, a buffer pool is a memory area that is used to cache data pages and index pages from database tables. The purpose of a … Read more

DBRM stands for Database Request Module. It is a component inside DB2, which is created by the pre compiler of DB2. It contains SQL source statements that get extracted out of the application program. DBRMs form inputs that are helpful in the binding process. In the context of IBM’s DB2 database management system, DBRM stands … Read more

DB2 bind is process that prepares an access path to the data. This access path is stored as a package in the DB2 catalogue. In the context of IBM Db2, “bind” refers to the process of associating a SQL statement or a set of SQL statements with the underlying database objects and creating an access … Read more