What is the use of reorg in db2?
What is database manager in db2?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
what is the soft code for deadlock ?
What is DB2 (IBM Database 2)?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Are view updateable?
Mention data types used in db2 ?
If I have a view which is a join of two or more tables, can this view be updateable?
select 100 records from million records ?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How do we specify index to include or not during bind process.
What is the size of a data page?