Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: afdsvicosa
- Order by date
-
How to REALLY clean up a table containing LOB data
Hi Truusvlugindewind, thank you for your posts. Unfortunately we had to do some upgrades on our servers and I did not have the opportunity to try the reorg yet! But I'll definitely try it. First thing, yeah, you're right. We do not want to use "delete from" because of log usage. Our table has...- afdsvicosa
- Post #8
- Forum: IBM: DB2
-
How to REALLY clean up a table containing LOB data
I also find it funny that you call dropping a table TO DO A DATA CLEAN UP work "the normal way to go". So, do you think it is normal to drop the whole table along with its indexes, constraints, and whatever else just to do a data clean up? And then have the work of recreating everything else? I...- afdsvicosa
- Post #3
- Forum: IBM: DB2
-
How to REALLY clean up a table containing LOB data
Hi everybody. I want to know how I can really clean up a table that contains LOB data. I have a table that has various columns and one of them is a BLOB of size 134,217,728 Bytes. When I try a "load from /dev/null of del replace into <my_table> nonrecoverable" command it logically cleans up the...- afdsvicosa
- Thread
- Replies: 7
- Forum: IBM: DB2
