log files linux

[prabu]

i am a newbie of db2.
I need guidance in the following thing..

where can i find all the log files in linux (i am using db2 v8.1,
RedHat Linux v8)..specifically i am interested in finding out the time
taken to execute a query.

thanks
prabu

[Mark A]

"prabu" <ss*****@clemson.edu> wrote in message
news:cc**************************@posting.google.c om...

i am a newbie of db2.
I need guidance in the following thing..

where can i find all the log files in linux (i am using db2 v8.1,
RedHat Linux v8)..specifically i am interested in finding out the time
taken to execute a query.

thanks
prabu

DB2 log files are for database recovery only. They do not have information
about select statements. Even if you want to know about the time required
for an insert, update, or delete, the logs would not help you.

You can look at the query patroller or the event monitor. You could also
resubmit the query with the db2batch command and it will keep track of the
time in the output.

[Blair Adamache]

In DB2, logs are internal representations of transactions against the
database. To track a specific query, try DB2's snapshot monitor.

prabu wrote:

i am a newbie of db2.
I need guidance in the following thing..

where can i find all the log files in linux (i am using db2 v8.1,
RedHat Linux v8)..specifically i am interested in finding out the time
taken to execute a query.

thanks
prabu

[Paul Reddin]

Hi,

Just in case you requirements are really simple...

You can just do the following from the command line
(use unix 'time' command)

e.g time db2 "select count(*) from syscat.tables"

Paul.

ss*****@clemson.edu (prabu) wrote in message news:<cc**************************@posting.google. com>...

i am a newbie of db2.
I need guidance in the following thing..

where can i find all the log files in linux (i am using db2 v8.1,
RedHat Linux v8)..specifically i am interested in finding out the time
taken to execute a query.

thanks
prabu