Interested to Buy Any Domain ? << Click Here >> for more details...
Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4618 Views
- IBM, I also Faced
- E-Mail Answers
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
| Is This Answer Correct ? | 1 Yes | 0 No |
How would one remove old reorg information from the DB2 catalog?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is the function of logging in the db2 database?
What is an intent lock?
What is the difference between SYNONYM and ALIAS?
What are the various isolation levels possible?
What are the functions in DB2?
What are the disadvantages of PAGE level lock?
COBOL 
