Sawaal
  • Home/
  • Searching for at

 Searching for "at"

Q:

What CICS command are used to read a VSAM KSDS sequentially in ascending order?

Answer

READNEXT reads the next record from a browse operation for any of the three VSAM files.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is CICS?

Answer

Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

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:

What is QUIESCE?

Answer

A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is meant by index cardinality?

Answer

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

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