Hi...

I'm trying to get the error log from any kind of schema. I wonder if I could get it by using a query like:

SELECT * FROM SCHEMA.LOGTABLE

What I need to do is catch various kind of errors and warning in excecutions in the whole database.

Regards

the same entry twice -->> the same answer twice
I hope you also finished the db2 training - it should be a mandatory prereq before coming to a forum to understand at least what you are doing.
all messages are in diag.log or in db2dump directory - there are no sysibmadm views for this - you can extract complete messages from diaglog with db2diag tool
db2diag - db2diag logs analysis tool

and you are using db2 what?


PD_GET_DIAG_HIST table function

The table function returns log records, event records and notification records from a given facility.

PDLOGMSGS_LAST24HOURS administrative view and PD_GET_LOG_MSGS table function
This administrative view and table function return problem determination log messages that were logged in the DB2 notification log. The information is intended for use by database and system administrators.

Hi sathyaram_s.

I'm using DB2 LUW V9.7 and I'm using data studio, the answer you give me is close to what i'm looking for. I mean I wanna get the log from a 'x' table, get when sombody insert a new row, update, delete, you know stuffs like that also if I try to make anything like before but is was unsuccesful.

Thanks a lot for your support

Sorry. I have lost the plot here. What sort of messages do you want to see?
Related to database errors or application errors ?

few example will make it easier to understand.


---

First of all thank a lot for your time.

Well lets say I've just insert a new row to Table1. I wanna get the acction (insert), the sqlcode and time where it happens. Also if was a bad excecution I mean if try to insert a character in an integer field.

Thanks.

Regards.

Then we are not talking about the same thing

You have created another thread for this issue. You follow up on that. This thread's subject is misleading