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

How can you quickly find out the # of rows updated after an update statement?

1033

Explain correlated sub-queries.

1023

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11667

How do I create a view in db2?

1013

What is page size in db2?

969

B37 abend during spufi?

1448

How many databases can be created inside an instance in db2 ?

1027

How to check table size in db2 sap?

1025

What is meant by union and union all?

1004

What is a collection in db2?

1028

What is a system catalog table in db2?

1178

How would the varchar column remarks defined?

1084

What is reorg and runstats in db2?

1213

Explain package in db2 and its advantages?

1201

What kind of database is db2?

1028