Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vasuki🐍
reorganizes the table and its indexes by
rebuilding the index data into unfragmented and contiguous area on the disk.
Normally after a large amount of INSERT, UPDATE, DELETE activities on data tables, we generally need a REORG.
After a table space reorganization the fragments are moved around and clustered,
however the database still utilizes the old statistic to query the data.
So it is recommended to run a RUNSTATS on the table.
This command updates the statistic information.
Besides it makes sure that the DB2 optimizer takes advantage of the refreshed statistic information.
Reorg>>runstats
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How does a cursor work?
What is a db2 collection?
What is meant by dclgen?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do I import a csv file into db2?
What is page size in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What are the bind parameters ibm db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How does cobol compile db2 program?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is runstats utility in db2?
What is db2 bind process?
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.
