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

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 / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is dbrm? What it contains?

1173

What is data manager?

1058

Define db2.

1123

What is bind in db2?

1055

Outputs of explain are with matchcols = 0. What does this signify?

1073

Explain about rct.

1095

What is db2 command?

1046

What is the difference between using bind () and rebind () methods of naming class?

1413

What is the maximum size of varchar data type in db2?

1141

What is drop table?

1022

What does db2 plan contain?

1031

What is db2 optimizer?

1262

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1247

What is the difference between dbm cfg and db cfg file in db2 ?

1547

Give a brief description of db2 isolation levels?

1081