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?
- 1 Answers
- 4528 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How is deadlock resolved?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is a db2 collection?
What is the function of logging in the db2 database?
How does coalesce work?
Define db2.
What is database manager in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is bind in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the purpose of rollback and commit?
What is meant by dclgen?
What is runstats utility in db2?
What parameters are used to control the free space in DB2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
