can I alter a table (e.g. adding a column) when other user is selecting some c

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?

Question Posted / guest

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating 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

More DB2 Interview Questions

What can the SET option of the Repair Utility accomplish?

What is correlated subquery?

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

Where is the output of EXPLAIN stored?

how will you retrieve first record in table

How many databases are there?

Why cursor is used in db2?

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

Mention the different locking levels that are available in db2.

how to resolve -811

What is null in db2?

For more DB2 Interview Questions Click Here