can I alter a table (e.g. adding a column) when other user
is selecting some columns or updating some columns from the
same table?



can I alter a table (e.g. adding a column) when other user is selecting some columns or updating s..

Answer / s

No, Because it requires an EX lock on the DBD to make
alters to the table description.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

What information is contained in a SYSCOPY entry?

2 Answers  


Is Cursor exicutable ?

3 Answers   TetraSoft,


What is a page in db2?

0 Answers  


what is the use of bind parameter, Replace?

5 Answers   IBM,


What is pagespace?

1 Answers  






What is dbrm? When it will be created?

0 Answers  


What is access path in db2?

0 Answers  


how can i pull up a query which was previously stored in qmf

3 Answers  


What is copy pending and check pending in db2?

0 Answers  


What is copy pending status in db2?

0 Answers  


How can you compare table column after update and before update?

5 Answers   Satyam,


What is the picture clause of the null indicator variable?

6 Answers  


Categories