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
How to check table size in db2 sap?
How does a cursor work?
Explain about rct.
What is the usage of open cursor command?
How many types of page locks can be held in db2?
What is the use of db2 optimizer?
What are the two types of logging in the db2 database? Explain them.
Which isolation level provides highest data integrity?
What is the syntax for FETCH in DB2 ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
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 ?...
Mention some fields that are a part of sqlca.
How to find schema of a table in db2?
What is a storage group (stogroup)?
what is diffrence b/w file-aid tool and file-aid utility???