What is RCT?

Resource Control Table (RCT) is controller that directs the CICS DB2 interface. Using DSNCRCT, RCT can produce a micro table.

What is SPUFI?

SPUFI stands for SQL Processor Using File Input.

Give the name of some fields form SQLCA.

The following three are the fields from SQLCA:

SQLCODE
SQLERRM
SQLERRD

What is the default page size of buffer pools?

The default page size of buffer pool is 4kb.

BP0
BP1
BP2
BP32

What do you mean by storage group (STOGROUP)?

Storage group is a storage path where data can be stored. A table space can also be assigned to storage group.

What is the picture clause of Null indicator variable?

S9(4)COMP is the picture clause of a null indicator variable.

Which components manage deadlocks in DB2?

Locking services are provided by Locking services component known as “Internal Resource Lock Manager” (IRLM) and manages concurrency issues and deadlocks.

What is role in DB2?

In DB2, a role is an object of database that group various privileges together and can be assigned to groups or user by GRANT statement.

What are the contents of a DCLMGEN?

EXEC SQL DECLARE TABLE statement which gives the layout of the table in terms of DB2 data type.
A host language copy book that gives the host variable definitions for the column name.

What action DB2 takes when a program aborts in the middle of a transaction?

DB2 performs auto rollback when a program is aborted in the middle of some transaction.