By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,289 Members | 3,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,289 IT Pros & Developers. It's quick & easy.

Removal of old entries in Journal or old storage snapshots

P: n/a
DB2 Enterprise Server Edition, version 8.1 (fixpack 6a) on Windows 2003.

Is there a command to remove old entries both from Journal or old storage snapshots. Storage snapshots is saved in the systools schema of the database, and old entries in Journal are in the toolsdb. So it should be possible to write SQL that removes old entries for both of these. Has anybody found out how to do this ?

Regards
Odd Bjørn Andersen
ErgoGroup
Oslo, Norway
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I know that it's possible to remove old entries via the GUI, but I wanted to know if it's possible to create a script that does the same.

:-) Odd Bjørn A
"Odd Bjørn Andersen" <od**********@ergo.no> wrote in message news:11***************@makrell.interpost.no...
DB2 Enterprise Server Edition, version 8.1 (fixpack 6a) on Windows 2003.

Is there a command to remove old entries both from Journal or old storage snapshots. Storage snapshots is saved in the systools schema of the database, and old entries in Journal are in the toolsdb. So it should be possible to write SQL that removes old entries for both of these. Has anybody found out how to do this ?

Regards
Odd Bjørn Andersen
ErgoGroup
Oslo, Norway
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.