Can system catalog tables be pruned?

[Bruce Pullen]

UDB7.2 on AIX5.2

Specifically, I'd like to delete all data from SYSIBM.SYSSECTION and
SYSIBM.SYSPLAN tables prior to doing a REORG to re-gain diskspace...
without corrupting the database! The only other option I can think of
to re-gain space is to use db2move or db2look.

Can anyone advise?

Thanks
Bruce

[Uncle Buck]

The rows in these tables describe your existing plans/packages. I suppose
you could drop plans, run your reorg, then rebind the plans (assuming you
have the plans some where convenient). regards, Al
"Bruce Pullen" <br**********@hotmail.com> wrote in message
news:9d**************************@posting.google.c om...

UDB7.2 on AIX5.2

Specifically, I'd like to delete all data from SYSIBM.SYSSECTION and
SYSIBM.SYSPLAN tables prior to doing a REORG to re-gain diskspace...
without corrupting the database! The only other option I can think of
to re-gain space is to use db2move or db2look.

Can anyone advise?

Thanks
Bruce