What are ACQUIRE and RELEASE in BIND? – InterviewSolution

InterviewSolution

1.	What are ACQUIRE and RELEASE in BIND?
Answer» A certain POINT in a PROGRAM when DB2 ACQUIRES or releases the locks against the TABLES and/or tablespaces. These include the intent locks as WELL.

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?