Manually Database table maintainance procedure

guyprzytula · #1 (**permalink**) 11-23-06, 01:59

- runstats should be executed on regular interval
- reorgchk and reorg if check indicates reorg is needed
- backup (this is not part of maintenance)
- space usage if dms tablespaces defined
probably many more ...

Coolhard · #2 (**permalink**) 11-23-06, 02:07

Guy przytula,
thanks so much for your response....

I think you r right.Still there may have some more things to do.
Is there anybody know some more facts for table maintainance ?
Could you pls share us?

Thanks,

bala_e · #3 (**permalink**) 11-23-06, 02:18

One of the maintenance activity is to bring down HWM for DMS tablespaces. This can be achieved in two ways.

1. Offline re-org (for this you required 100% free space of table allocated size on your tablespace).
2. Table data unload & load.

After completion of any of the above steps,

do update runstats for those tables.

Quote:

Originally Posted by Coolhard

Dear All,

I want to make a maintainance for some of my tables by manually in every month.
May I know what to do?
I only know the statistic.I think there are some others procedure I suppose to do for the maintainance.Am I right?
Is there any idea pls?

Thanks in advance,

Internet Services

Web Development

Digital Marketing

Consumer Tech