DB2 Interview Questions and Answers For Freshers Part-1
2.Which component checks DB2 deadlocks?
Locking services are provided by Locking services component which is known as Internal Resource Lock Manager (IRLM) and manages concurrency issues and dead locks.
3.Which component is responsible for execution of SQL statements?
Database services component is responsible for execution of SQL statements and it manages buffer pool also.
4.Which component handles DB2 startup and shutdown?
System services component handles DB2 startup and shutdown.
5.On which level we can apply the locks?
Locking can be applied on either of these − Page, table and table space.
6.In which step we specify the isolation level?
In Bind step we specify the isolation level.
.7Which field in SQLCA shows the number of updated rows after update statement?
Check the value of SQLERRD to know how many rows got updated after an update statement.
8.What is the physical storage length of TIMESTAMP data type?
TIMESTAMP data type takes 10 bytes and default is YYYY-MM-DD:HH:MM:SS-NNNNNN
9.What is the physical storage length of DATE data type?
DATE data types take 4 bytes and default is ‘YYYY-MM-DD’
10.Which component is used to processes SQL statements and selects the access paths?
DB2 optimizer is used to select the access paths & to process the SQL queries.