What is RUNSTATS?
Answers were Sorted based on User's Feedback
Answer / s
RUNSTATS is a utility to collect statistics of the
tablespace that will be used by the optimizer to generate
best cost access paths.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / srinivasa yadav
RUNSTATS:- RUNSTATS IS A UTILITY
IT IS GET THE LATEST INFORMATION OF TABLESPACE,
INDEX AND e.t.c
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kathir
this utility is giving information about the tablespace and
indexspace of statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why might full image copies be faster to implement than an incremental image copy?
i want to maintain uniqueness on pdf without make lf??????????
What is a clustering index ?
What is a DBRM, PLAN ?
What is -904 sql code? How to resolve it?
can i code union in cobol-db2 pgm ?
What are common abends
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is the maximum size of a char data type in db2?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?