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

Comment whether the cursor is closed during commit or not.

1110

What is declare cursor?

1127

What is null indicator in cobol db2?

1067

i want to maintain uniqueness on pdf without make lf??????????

2158

How does cobol compile db2 program?

1069

What are the contents of dclgen?

1114

Explain various types of locks in db2?

1159

What is explain in db2?

1033

How do I add a column to a table in db2?

1104

What is cursor stability in db2?

1363

Which component is responsible for db2 startup and shutdown?

1037

How does db2 sample database connect?

1034

What does db2 blu stand for?

1169

What is db2 plan table?

1054

What is cascading rollback?

1218