What is RUNSTATS?

Answer Posted / s

RUNSTATS is a utility to collect statistics of the
tablespace that will be used by the optimizer to generate
best cost access paths.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is host variable in db2 cobol?

591


Highlight all the advantages that are attached to a package.

619


Describe major components of db2?

633


What is lock escalation in db2?

566


Explain in brief how does db2 determine what lock-size to use?

587






How to create db2 table in mainframe?

623


How many databases are there?

585


Explain about open switch business continuity software?

554


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7477


What are the full forms of spufi and dclgen and why are they used?

646


How will you return the number of records in table?

509


How to compare data between two tables in db2?

653


What do you mean by cursor?

578


Define data page.

625


What is node in db2?

602