Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between TYPE 1 index & TYPE 2 index
- 1 Answers
- 13208 Views
- IBM, I also Faced
- E-Mail Answers
Answer / s
TYPE 1 index has subpages and uses index locking.
TYPE 2 index has no subpages and does data-only locking.
| Is This Answer Correct ? | 20 Yes | 4 No |
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?
I use CS and update a page. Will the lock be released after I am done with that page?
What is precompiler in db2?
Explain about rct.
What is FREEPAGE and PCTFREE in TABLESPACE creation?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
How to take backup of table in db2?
What are bind parameters in db2?
Mention and explain the contention situations caused by locks?
How is a typical DB2 batch program executed ?
COBOL 
