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
How do I delete a table in db2?
How do I start db2 in windows?
What is database alias db2?
What is the use of dclgen in db2?
Name the various locking levels available?
What action db2 takes when a program aborts in the middle of a transaction?
What is reorg?
How is the value function used?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Before you give the explain statement, what are the prerogatives?
How do I import data from excel to db2?
How to run db2 command in windows?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
