What would be the equivalent of truncate table command of ORACLE in UDB.

I need to clean up the tables without dropping it and without creating tons of log files.

What are my options ?

Also if I can pile on one more question : How do I put the user tablespace USER1 in an offline mode ? ( I would also appreciate if you can point me to any particular references for tablespace management)
Thanx
-Soumil

You can try using this command,

alter table .... activate not logged initiatlly with empty table..

this will delete all rows maintaining all other definitions.

... only if the table has been created with "NOT LOGGED INITIALLY" option.

You can effectively truncate a table by LOADing or IMPORTing an empty file into it (with REPLACE option).

create one dummy file
if it is unix

touch test.txt

replace table with dummy file, that ownt create log same as truncate table in Oracle

db2 load from test.txt of del replace into <table name>

--Raju

For an empty file, you can use system's /dev/null ...

there is a windows equivalent also, unfortunately, I do not remember

Sathyaram