Can system catalog tables be pruned?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bruce Pullen
    #1

    Can system catalog tables be pruned?

    UDB7.2 on AIX5.2

    Specifically, I'd like to delete all data from SYSIBM.SYSSECTI ON 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
    Tags: None
    • Uncle Buck
      #2
      Re: Can system catalog tables be pruned?

      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@h otmail.com> wrote in message
      news:9de33a7d.0 312120433.37cdd 97d@posting.goo gle.com...[color=blue]
      > UDB7.2 on AIX5.2
      >
      > Specifically, I'd like to delete all data from SYSIBM.SYSSECTI ON 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]


        Comment

        Previous template Next
        Working...