I want to Removes the inactive part of the log without making a backup copy of it and truncates the log to free spaces. That's like the statement "BACKUP LOG db-name WITH TRUNCATE_ONLY " in SQLServer. Is there any statements/method to do that? Thanks in advance!

I think it will help if you can explain clearly what that command does exactly in SQL server...otherwise you are limiting yourself to only those individuals who knows both SQL and DB2!!! Please read "must read before posting"

dollar

sorry, coz I didn't know about what should I do clearly. But I've try my best to explain now~

can use command:

archive log for database db-alias