Answer Posted / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What's The Percentage Free Space ?
What is innodb buffer pool?
What is the physical storage length of timestamp data type?
What is the difference between using bind () and rebind () methods of naming class?
How do you select a row using indexes in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Differentiate between cs and rr isolation levels? Where do you specify them?
Why do chiropractors use drop table?
How can we retrieve the total number of records in RPG & CLLE?
What is the purpose of rollback and commit?
Define db2 and its databases?
What is the role of the data page in the db2 database?
Mention the various locks that are available in db2.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is null in db2?
