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

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


What are data types?

2 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,






What does sqlcabc has?

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


How do I add a column in db2?

0 Answers  


Is Cursor exicutable ?

3 Answers   TetraSoft,


What is explain in db2?

0 Answers  


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


Is db2 a mainframe?

0 Answers  


Categories