Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is Runstats? Whem will u choose to runatats?



what is Runstats? Whem will u choose to runatats?..

Answer / s

RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


How to create db2 table in mainframe?

0 Answers  


What is null in db2?

0 Answers  


Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,


Request to database but database is not available so what is was abend is raised?

2 Answers   UST,






How to check last update on table in db2?

0 Answers  


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


What is plan in cobol db2?

0 Answers  


EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


Explain correlated sub-queries.

0 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  






Categories