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 |
How is the value function used?
What is the maximum size of varchar data type in db2?
Why do we use cursor?
how can u nderstand the sql stmts executed successfully or not ?
What is a result table?
what is diffrence b/w file-aid tool and file-aid utility???
How to resolve -504 sql code in DB2?
i have a db2 variable how do u declare tht into working storage section ?
What is the usage of open cursor command?
is there any restrictions for unions ?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?