Category Archives: DB2 Interview Questions

What is a DB2 catalog? | DB2 Questions

The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.).

Posted in DB2 Interview Questions | Leave a comment

How are write I/Os from the buffer pool executed? | DB2 Questions

Asynchronously.

Posted in DB2 Interview Questions | Leave a comment

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2? | DB2 Questions

DB2 can be invoked by TSO users by using the DSN RUN command.

Posted in DB2 Interview Questions | Leave a comment

What are the three types of page locks that can be held? | DB2 Questions

Exclusive, update, and share.

Posted in DB2 Interview Questions | Leave a comment

Can DASD types assigned to storage groups be intermixed(i.e., 3350s and 3380s)? | DB2 Questions

No

Posted in DB2 Interview Questions | Leave a comment

What is meant by a unit of recovery? | DB2 Questions

This is a sequence of operations within a unit of work(i.e., work done between commit points).

Posted in DB2 Interview Questions | Leave a comment

What is the format (internal layout) of “TIMESTAMP”? | DB2 Questions

This is a seven part value that consists of a date (yymmdd) and time(hhmmss and microseconds).

Posted in DB2 Interview Questions | Leave a comment

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace? | DB2 Questions

If the tablespace used is only allocated to that STOGROUP: – ALTER STOGROUP – add volume (new) delete volume(old) – REORG TABLESPACE or RECOVER TABLESPACE Create a new STOGROUP that points to the new volume. ALTER the tablespace and REORG … Continue reading

Posted in DB2 Interview Questions | Leave a comment

Describe what a storage group(STOGROUP) is? | DB2 Questions

A STOGROUP is a named collection of DASD volumes to be used by tablespaces and index spaces of databases. The volumes of STOGROUP must be of the same device type.

Posted in DB2 Interview Questions | Leave a comment

What is meant by repeatable read? | DB2 Questions

When an application program executes with repeatable read protection, rows referenced by the program can’t be changed by other programs until the program reaches a commit point.

Posted in DB2 Interview Questions | Leave a comment