want to retrieve SQL which ran last night

azs0309 · #1 (**permalink**) 03-05-08, 09:33

Hi all,

Can I retrieve SQL which ran last night , I dont have any event monitor setup but isnt there any way to know which SQL ran at what time.

ARWinner · #2 (**permalink**) 03-05-08, 10:35

I think the only ways you can get that kind of information is with an event monitor or using Query Patroller.

Andy

azs0309 · #3 (**permalink**) 03-05-08, 10:40

query patroller is an add on tool. right?

ARWinner · #4 (**permalink**) 03-05-08, 10:45

Yes it is.

Andy

Cougar8000 · #5 (**permalink**) 03-05-08, 10:48

Quote:

Originally Posted by azs0309

Hi all,

Can I retrieve SQL which ran last night , I dont have any event monitor setup but isnt there any way to know which SQL ran at what time.

You can get this info many different ways be it home grown tool or what you buy from some vendor. Bun NON of them will tell you today where you have been yesterday unless you buy a crystal ball.

stolze · #6 (**permalink**) 03-05-08, 10:57

How should this work? You don't tell DB2 to collect anything and then expect it to do that nevertheless?

The only option you have is to analyze the DB2 log records to figure out which effects any data modification statements had. The DB2 Log Analyzer tool/product can help you there.

Internet Services

Web Development

Digital Marketing

Consumer Tech