How will you achieve record level locking in DB2 versions where record

1.	How will you achieve record level locking in DB2 versions where record level locking is not allowed?
Answer» We can ACHIEVE the record LEVEL locking in DB2 versions where the record level locking is not ALLOWED by having the length of the record greater than that of a page itself. Now that we have so much knowledge from the questions that we have studied, LET US now move to practice some of the MCQs that will help test your knowledge too. Useful Interview Resources Interview Questions on MainFrame Interview Questions on COBOL Interview Questions on SQL Interview Questions on DBMS Interview Questions on Oracle

How will you achieve record level locking in DB2 versions where record level locking is not allowed?

Answer»

We can ACHIEVE the record LEVEL locking in DB2 versions where the record level locking is not ALLOWED by having the length of the record greater than that of a page itself.

Now that we have so much knowledge from the questions that we have studied, LET US now move to practice some of the MCQs that will help test your knowledge too.

Useful Interview Resources

Interview Questions on MainFrame
Interview Questions on COBOL
Interview Questions on SQL
Interview Questions on DBMS
Interview Questions on Oracle

Discussion

No Comment Found

Related InterviewSolutions

How will you achieve record level locking in DB2 versions where record level locking is not allowed?
What is DSNDB07? What does it do?
Is there any specific reason why SELECT is not preferred in embedded SQL programs?
What is the RUN STATS that was mentioned in the previous answer?
Let us say that I have a program it uses dynamic SQL. It has been working fine till now, however, lately, I have found that the performance has been affected and deteriorated. Can you guess what can be the reason behind this?
What are SPUFI and QMF? What is the difference between them?
In a COBOL-DB2 program, where are all the SQL statements coded?
What are ACQUIRE and RELEASE in BIND?
Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.
Is it possible for you to alter the table (adding a column to it) while some other person is accessing the table and even updating some values in it?

How will you achieve record level locking in DB2 versions where record level locking is not allowed?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment