I'm using IBM DB2 version 5.2
(Yea I know, its old, I've finally got the bosses convinced that its time to move.)
(please see http://www.experts-exchange.com/Databases/IBM_UDB/Q_21766241.html
for a detailed question of the setup and how things are going.)
when I issue a carefully crafted delete statement against a dated dataset to delete data older than a certain date I get an error indicating that the transaction log is not large enough to accomodate my request.
I end up having to reissue the same sql statement and incrementing the date by a week, or a month or whatever to get a years worth of data purged.
In my estimation I need to do one of two things:
1) find a way to temporarily (or dynamically) increase the transaction buffer so that the sql statement will execute ONCE and be done.
2) find a way to bybass the the transactional logging system and rollbacks and all that for a one time use sql statement.
I'm open to suggestions on approach as well as method.
Thanks for your help.