Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in database?
- 1 Answers
- 2052 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is bind in db2?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What are the bind parameters ibm db2?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What are the various isolation levels possible?
What happens in bind step in a db2 program?
what is the responsibility of the construction superintendent
Comment whether the cursor is closed during commit or not.
What is DCLGEN ?
Explain the EXPLAIN statement?
What is data manager?
COBOL 
