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
What is load replace in db2?
What is db2 plan table?
What is db2 connect?
What is the information associated with sysibm.syslinks table?
What is cloudant database?
What is sqlca?
What does db2 blu stand for?
What is the maximum size of varchar data type in db2?
How can we retrieve the total number of records in RPG & CLLE?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a trigger in the db2 database?
Why do we bind in db2?
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 utility in db2?
List out the three types of page locks that can be held.