What is PRIME TABLE and what are the uses of it
Answer / poonam
Prime Double Hash Table always uses prime number table sizes. The table is expandable, and the cost of rehashing is amortized across each insertion or deletion operation
| Is This Answer Correct ? | 0 Yes | 0 No |
What is db2 bind process?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
When do you specify the isolation level?
What is the difference between cursor and select statement?
how will you retrieve first record in table
What is the SQL Communications Area and what are some of its key fields?
what is Static and dynamic linking
Plan has the optimized access path in it. But is that optimized access path is attained or known
How are write I/Os from the buffer pool executed?
How do you define a correlated name?
What's the difference between DB2 active log and archive log? Thanks a lot...
Give some example of statistics collected during RUNSTATS?