Sawaal
  • Home/
  • Searching for DB2

 Searching for "DB2"

Q:

In a DB2-CICS program which acts as co-ordinator and which is the participant?

Answer

DB2 acts as the participant and CICS acts as a co-ordinator


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How will u send data from a cobol file to db2 table?

Answer

USING HOST VARIABLE we can pass data from COBOL to DB2

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a DB2 bind?

Answer

A DB2 bind is a process that builds an access path to DB2 tables. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is a DB2 plan?

Answer

An application plan or package is generated by the bind to define an access path. 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How can record locking be achieved in those DB2 versions which do not support it?

Answer

It can be done by setting the record length’s size to more than half of the page’s size.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What does a deadlock mean in DB2?

Answer

When two independent processes contend for the same resource or the resources reserved by one another, it is called a deadlock. -911 and -913 are the SQLcode for a deadlock.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

How does DB2 use multiple table indexes?

Answer

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview