When will you chose to run RUNSTATS?
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
Is This Answer Correct ? | 4 Yes | 4 No |
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is coalesce in db2?
Can there be more than one cursor open for any program?
what is the use of bind parameter, Replace?
Where can you declare a cursor in a cobol-db2 program?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Explain the contents that are a part of dclgen.
What is deadlock in db2?
What are the three lock types?
What is a db2 table?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is db2 and what is the use of db2 optimizer?