Sawaal
  • Home/
  • Searching for i

 Searching for "i"

Q:

What is NOTCAT2?

Answer

It is an MVS message that indicates the presence of a duplicate catalogue in the database. This problem can be fixed by removing one of the entries and then adding a new one.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

Name and explain the type of locks?

Answer

There are three types of lock, namely:


Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.


Update – This lock is more lenient. It permits the program to read and change the locked space.


Exclusive – This lock restricts all users from accessing the locked space.

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:

What does it mean if the null indicator has -1, 0, -2?

Answer

 -1 indicates the field is null


 0 indicates the field is not null


 -2 indicates the field is truncated

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the difference between Cursor Stability and Repeatable Read isolation levels?

Answer

CURSOR STABILITY:


- CS is a row level locking


- Acquires an exclusive lock on the row that is to be updated


- When the control is moved to the next updatable row, the lock is released


REPEATABLE READ:


- RR is a page level locking


- Acquires an exclusive lock on the entire page which is the source of row availability


- When the control is moved to the next updatable page the lock is released

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is COPY PENDING status?

Answer

- A status occurs when image copy on a table needs to be taken


- The table is available only for queries and can not be updated


- COPY PENDING status can be removed by taking away the image copy or by using REPAIR utility

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is SQLCA?

Answer

- SQLCA stands for SQL Communication Area


- SQLCA is a structure of variables which are updated after every SQL statement’s execution


- Exactly only one SQLCA need to be provided to an application that contains executable SQL statements


- SQLCA is not applicable to JAVA application


- More than one SQLCA need to be provided for FORTRAN application

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is Mainframe Testing?

Answer

Mainframe Testing is similar to client-server applications testing, but you have to know how to operate basic TSO and ISPF commands and menus, view mainframe files, look at and use SDSF or other output tool, log on CICS and transactions, use FTP or another transfer protocol, submit the batch job - it's for QA testing of mainframe applications.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview