Sawaal
  • Home/
  • Searching for at

 Searching for "at"

Q:

What is DBRM? What it contains? When it will be created?

Answer

- DBRM stands for Database Request Module


- The output of pre-compile process is represented as DBRM


- The SQL statements are extracted from the host language by the pre-compiler

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is sqlcode -811?

Answer

SELECT statement has resulted in retrieval of more than one row.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is REORG? When it is used?

Answer

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is RUNSTATS?

Answer

A DB2 utility used to collect statistics about the data values  in tables which can be used   by the optimizer to decide the access path. It also collects statistics used for space   management. These statistics are stored in DB2 catalog tables.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How does DB2 determine what lock- size to use?

Answer

1. Based on the lock-size given while creating the table space


2. Programer can direct the DB2 what lock-size to use


3. If lock - size ANY is specified, DB2 usually chooses a lock-size of PAGE

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

Answer

a nonmatching index scan if ACCESSTYPE = 1


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is DCLGEN?

Answer

DeCLarations GENerator : used to create the host language copy books for the table    definitions. Also creates the DECLARE table.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a cursor ? Why should it be used in DB2?

Answer

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time. Cursor should be used because the host language  can deal with only one row at a time.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview