Active DB2 LOGS

Koz · #1 (**permalink**) 04-29-04, 11:31

Is there a query I can run to list all active DB2LOGS? My log filesystem is filling up fast and I wanted to prune the logs. I usually prune the logs after the weekend offling backup, but it does not look like it can wait.......

Afraid of removing a log and then a rollback occuring......

J Petruk · #2 (**permalink**) 04-29-04, 11:33

Quote:

Originally Posted by Koz

Is there a query I can run to list all active DB2LOGS? My log filesystem is filling up fast and I wanted to prune the logs. I usually prune the logs after the weekend offling backup, but it does not look like it can wait.......

Afraid of removing a log and then a rollback occuring......

db2 GET DB CFG FOR <BLAH>

...
First active log file = S0000142.LOG
...

I've always found it strange that it's in the db cfg, but I'm sure there are reasons.

Internet Services

Web Development

Digital Marketing

Consumer Tech