| View previous topic :: View next topic |
| Author |
Message |
viji
Beginner
Joined: 03 Dec 2002
Posts: 17
Topics: 11
|
 Posted: Thu Dec 12, 2002 10:46 am Post subject: Is reorg necessary after LOAD REPLACE? |
 |
|
Hi,
I have Loaded the tablespace with LOAD REPLACE. Is REORG tablespace/Indexspace required after LOAD REPLACE?
Could you please specify the link where the information about this available?
Thanks inadvance.
Viji |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Dec 12, 2002 11:31 am Post subject: |
|
|
Viji,
It depends.If your Load file is sorted on the primary/clustering index ,then you don't have to run REORG utility.Basically REORG TABLESPACE/INDEX utility reorganizes a table space to improve access performance and reclaim fragmented space..The load replace with a sorted input file is mimicing the abiliites of REORG utility.I wouldn't recommend coding a REORG step after the load replace if the input load file is sorted on the index.
If you want to learn more about the utilites then check this DB2 UDB for OS/390 and z/OS V7 Utility Guide and Reference
Hope this helps...
cheers
kolusu |
|
| Back to top |
|
|
Manas Biswal
Intermediate
Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India
|
| Posted: Thu Dec 12, 2002 10:45 pm Post subject: |
|
|
Hi Viji,
It is always better to do a BLDINDEX and RUNSTATS after a LOAD REPLACE. Again you should also do a CHECKDATA on all the tables whose columns have a foreign key relationship with the table that you have loaded.
As kolusu said, loading a table from a seq file which is sorted on the primary index is always better. In fact while using the load utility, our installation always has a sort step in the job flow before the load.
Regards,
Manas |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
