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|
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.
How to create db2 table in mainframe?
What is null in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Request to database but database is not available so what is was abend is raised?
How to check last update on table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is plan in cobol db2?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Explain correlated sub-queries.
What are the functions of Bind?
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?