I have a situation here. whenever I try to delete huge volumes of data the transaction logs are getting filled. so I cannot use plain delete from statement. what is the alternative to avoid such scenario's????

didnt get cant do plain delete..?
try in blocks of say 10000 and commit
or else increase logfilesz

or use the alter table command with notlogged initially option
and delete
see infodoc for details of alter command

Or import/load from an empty file with the REPLACE option (but that will truncate the whole table).

Hi,
If you issue the command like

$db2 "load from /dev/null of del replace into schema.tableName"

it will delete all the data from the above mentioned table.

Shubhrojyoti
IBM Certified DB2 UDB DBA for LUW v8 and v9

didnt say what version or platform you were on, but table partitioning LUW V9 and aboveis good option for planning out deletes of large amounts of data without impact on logs. setting up ranges based on a date, you can delete specific ranges rather than the whole table like the replace into on imports.