Hi All,
a quick question.
I haven't used DB2 on mainframe since 1995 so my memory is fading a
bit. But I seem to recall DB2/MVS having the ability to perform
unlogged deletes.
Situation is I have an oracle partition with 500M rows in it and I need
to update 60M rows and I expect the logging of updates will be too
much...I had proposed that the rows be deleted using unlogged deletes
and then the new images loaded. But I am told oracle does not support
unlogged deletes. So I was just wondering, is my memory of DB2 accurate
in allowing unlogged deletes, or am I just dreaming of the good old
days before everyone bought Oracle all the time...;-)
(Sybase IQ is the only database I know that lets me to unlogged
updates. (Though perhaps DB2 does that now???) )
Thanks
Peter