Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between TYPE 1 index & TYPE 2 index
- 1 Answers
- 13211 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 |
What does runstats do in db2?
How can deadlocks be resolved?
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 pagespace?
What is a LIKE table and how is it created?
What is a correlated sub query?
What is the difference between SYNONYM and ALIAS?
Why might full image copies be faster to implement than an incremental image copy?
What is REORG? When is it used?
When is the access path determined for dynamic SQL?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How does DB2 determine what lock-size to use?
COBOL 
