A cursor can be declared either in Working Storage Section or in Procedure Division also.
DB2 Interview Questions
DB2 Optimizer is used to process the SQL statement. DB2 Optimizer can be used to enhance the performance of SQL.
DB2 optimizer is used to select the access paths and for processing SQL statements.
By applying the following query: SELECT COUNT(*) FROM TAB
Database Services component is used to execute the SQL statement. It also manages buffer pool.
DB2 also known IBM Db2 is a relational database management system (RDBMS) product form IBM. It is designed to store, analyse and retrieve data efficiently.
The maximum size of a CHAR data type in DB2 is 254 bytes.
System Services component is responsible for handling DB2 startup and shutdown.
Locking services are provided by Locking services component known as “Internal Resource Lock Manager” (IRLM) and manages concurrency issues and deadlocks.
The maximum size of a VARCHAR data type in DB2 is 4046 bytes.