What does the RUNSTATS Utility do?

Answer Posted / srinivasa yadav

RUNSTAT: IT GIVES THE LATEST INFORMATION OF THE
INDEXES,TABLESPACES etc

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I delete a table in db2?

651


What is lock escalation in db2?

576


Is ibm db2 free?

577


What is check constraint. Explain with example.

650


Why do we need reorg in db2?

566






What is a plan and package in db2?

625


Explain the contents that are a part of dclgen.

661


How does db2 sample database connect?

572


What is an instance database?

602


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6862


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2048


What is the physical storage length of date data type?

732


what is a corelated subquerry?

662


What action db2 takes when a program aborts in the middle of a transaction?

659


List out the three types of page locks that can be held.

689