Is it possible for you to alter the table (adding a column to it) whil

1.	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?
Answer» To be short and CRISP, the answer is yes, we can alter the table at the same time when some other transaction is taking place but this does not exactly happen as it SOUNDS to be. The DB2 table will not change its structure in any form till a transaction or MULTIPLE TRANSACTIONS are taking place. The table-altering commands will be stored by the database engine and will not be executed till all the transactions are complete. After one user has MODIFIED the values in the table, then the column will be added.

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?

Answer»

To be short and CRISP, the answer is yes, we can alter the table at the same time when some other transaction is taking place but this does not exactly happen as it SOUNDS to be.

The DB2 table will not change its structure in any form till a transaction or MULTIPLE TRANSACTIONS are taking place. The table-altering commands will be stored by the database engine and will not be executed till all the transactions are complete. After one user has MODIFIED the values in the table, then the column will be added.

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?