Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Why use RUNSTAT Utility?

Answers were Sorted based on User's Feedback



Why use RUNSTAT Utility?..

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

Why use RUNSTAT Utility?..

Answer / elavarasi

to provide statistical info. abt table,tablespace and index

Is This Answer Correct ?    20 Yes 3 No

Why use RUNSTAT Utility?..

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

Post New Answer

More DB2 Interview Questions

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


Comment whether the cursor is closed during commit or not.

0 Answers  


What is dclgen in db2?

0 Answers  


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.

5 Answers  


how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


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?

1 Answers   IBM,


What is the purpose of the DSNC transaction ?

1 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


What are the various data types available in db2?

0 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


Categories