View previous topic :: View next topic |
Author |
Message |
pkrish_18 Beginner
Joined: 08 Apr 2005 Posts: 12 Topics: 7
|
Posted: Fri Jul 15, 2005 6:15 am Post subject: Reorg or Load after altering and adding col to DB2 table. |
|
|
Hi,
Is it mandatory for us to do a Reorg or Load after altering and adding a col to DB2 table.
Is there any impacts if we don't do a reorg after altering the table..
Regards,
krish |
|
Back to top |
|
|
schintala Beginner
Joined: 18 May 2005 Posts: 108 Topics: 31 Location: USA
|
Posted: Fri Jul 15, 2005 7:56 am Post subject: |
|
|
It is not a mandatory to REORG after just altering the table. But it is good idea to run runstats utlity. REORG for space management. |
|
Back to top |
|
|
|
|