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?

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


Please Help Members By Posting Answers For Below Questions

What do you mean by cursor?

584


What is concurrency?

709


What types of tables are there in the db2 database?

550


What is the use of db2 optimizer?

608


What is rebind in db2?

574






What is access path in db2?

562


What is a plan and package in db2?

621


What is drop table?

583


What are the prerogatives?

615


Explain package in db2 and its advantages?

593


How to check table size in db2 sap?

575


What is bind package and plan in db2?

593


What is dclgen (declaration generator)?

601


What is ibm db2 connect?

570


Define predicate?

643