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 4932I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
2064Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
2 5117
What is innodb buffer pool?
What is a db2 schema?
Explain the benefits you can get from mainframe connect?
Why cursor is used in db2?
What do you mean by cursor?
What is the use of predicate?
What is a storage group (stogroup)?
What is runstats db2?
What is drop table?
How do I delete a column in db2?
Comment whether the cursor is closed during commit or not.
Explain correlated sub-queries.
what is utility for parm lib
What is the maximum No of rows per page?
Define buffer pool.