Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
1 6046Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
1 4434What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
2 5498
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Which components manage deadlocks in db2?
What is a storage group (stogroup)?
Define sqlca.
What do you mean by commit and rollback?
List out the three types of page locks that can be held.
Define predicate?
Which isolation level provides highest data integrity?
What is db2 and what is the use of db2 optimizer?
What is commit in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is host variable?
How to check table size in db2 sap?
What is the difference between db2 and oracle?
What is a page in db2?