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 / 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 |
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is meant by the attachment facility?
What is node in db2?
How do you check for a null value in a db2 column?
Mention the different locking levels that are available in db2.
Do we need cursor for Count(*)?
Which transaction use a command thread ?
How to create db2 table in mainframe?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What are the advantages of using a PACKAGE?
What is the information associated with sysibm.syslinks table?
Explain in detail about buffer manager and its functionalities?