odd Log problem

JDionne · #1 (**permalink**) 10-22-04, 13:08

I was running an insert statment and filled up the db log files. The job stopped and I assumed that it rolled back. However the logs did not release themselves. I know that I cant just delete the logs...so how do I get the roll back to commit and clear the logs?
Jim

udbraja · #2 (**permalink**) 10-22-04, 13:39

Just issue db2stop command. DB2 will take care.

-Tks

JDionne · #3 (**permalink**) 10-22-04, 13:42

Is there any other way...I have a transaction that is runnig unlogged as well as the one that failed. the one that is running will take forever to run in the first place I would hate to kill it now...
Jim

Internet Services

Web Development

Digital Marketing

Consumer Tech