Why use RUNSTAT Utility?
Answers were Sorted based on User's Feedback
Answer / sajjan jindal
IT is a DB2 utility used to collect statistics about the
data values in tables which can be used by the optimizer to
decide the access path. It also collects statistics used
for space management. These statistics are stored in DB2
catalog tables.
The RUNSTAT is executed after a load, or after mass
updates, inserts, deletes, or after REORG.
| Is This Answer Correct ? | 35 Yes | 2 No |
Answer / elavarasi
to provide statistical info. abt table,tablespace and index
| Is This Answer Correct ? | 20 Yes | 3 No |
Answer / avinash
It provide the summary information about the
characteristics of data available in table, indexes etc.
DB2 records these information into the CATLOG table and use
this information to decide on the access path to data
during the bind process. To obtain the statistics you can
query the catalog table.
| Is This Answer Correct ? | 8 Yes | 4 No |
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
i have a db2 variable how do u declare tht into working storage section ?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
Comment whether the cursor is closed during commit or not.
What is dclgen in db2?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
how to copy the host variables from ps file into cobol program other than include statement
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is the purpose of the DSNC transaction ?
Which component is responsible for processing sql statements and selecting access paths?
What are the various data types available in db2?
what is static sql? what is dynamic sql? Give me details