What DB2 Catalog column tell you when an index needs table
reorganized ?
What is data manager?
What is the command used by TSO users to invoke DB2?
What is rct?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is deadlock?
What is the size of a data page?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
difference between group clause and order clause
What is the physical storage length of date data type?
where will u check for sqlcode ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
what is Runstats? Whem will u choose to runatats?