Can system catalog tables be pruned?
Question posted by: Bruce Pullen
(Guest)
on
November 12th, 2005 06:03 AM
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
1
Answer Posted
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" <bruce_pullen@hotmail.com> wrote in message
news:9de33a7d.0312120433.37cdd97d@posting.google.c om...[color=blue]
> 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[/color]
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,829 network members.
Top Community Contributors
|
