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 is the default page size of buffer pools?

644


What is db2?

739


What is the difference between spufi and qmf?

635


What does sqlcabc has?

627


Which isolation level provides highest data integrity?

593






What is the information associated with sysibm.syslinks table?

657


Explain about dbrm.

606


What is a plan and package in db2?

617


What is the latest version of ibm db2?

735


What language is db2 written in?

595


What happens in bind step in a db2 program?

564


What is innodb buffer pool?

560


What is a bind card?

679


How can record locking be achieved in those DB2 versions which do not support it?

623


What is null indicator in cobol db2?

580