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
- 4433 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 |
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
Highlight all the advantages that are attached to a package.
What do you mean by between and in? Is between inclusive of specified range values?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What do you mean by storage group (stogroup)?
How does DB2 store NULL physically?
What are data types?
What are the four lockable units for DB2?
Plan has the optimized access path in it. But is that optimized access path is attained or known
How would one remove old reorg information from the DB2 catalog?
Which command is used to connect to a database in DB2 ? Give the Syntax.
When reorg is used?
COBOL 
