What is the difference between TYPE 1 index & TYPE 2 index
Answer Posted / 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 |
Post New Answer View All Answers
Explain about mirror activator disk mirroring?
Can we update view in db2?
What is query_cache_limit?
Explain about open switch business continuity software?
How to create db2 table in mainframe?
What is buffer pool in the db2 database?
How can we read records for specific member in CL? AND rpg?
What do you mean by cursor?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Which is faster delete or truncate?
What is a db2 tablespace?
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 ?
How many databases are there?
What is cursor stability in db2?
Is db2 a mainframe database?