what is REORG? what is the use?
Answers were Sorted based on User's Feedback
Answer / aasif
A common maintenance task performed by database
administrators is the reorganization of data in tables and
indexes, called "reorg." Table reorganization is used to
defragment a table, reclaim free space, and eliminate
overflow rows in order to improve data access performance.
Optionally it can be used to reorder data in the order of a
particular index, to optimize queries that use that index.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / s
It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / deepak dada
used for reorganising the datas in the tables after the
load utility
Is This Answer Correct ? | 1 Yes | 0 No |
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is the difference between IN subselects and EXISTS subselect?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is correlation names?
What is difference between *omit and *nopass?
What is rebind in db2?
What are the disadvantages of using VARCHAR?
What do you do to keep the cursor from closing after a commit?
What should be specified along with a cursor in order to continue updating process after commit?
Which components manage deadlocks in db2?
What is a NULL value? What are the pros and cons of using NULLS?