Hi ,

Can anyone tell me what is topsql.

Is topsql available in DB2.

If so how we run it.

Please help,

DBFinder

There is a monitor called db2top that is avaiable in the newer releases of DB2 (and updated in 9.5 FP3). I don't know if that is what you mean.

Are you talking about TOP SQL's which is basically
select top 3 * from tablename in SQL Server???

If that is the case then in DB2 it is
select * from tablename fetch first 3 rows only.

To capture top SQL statement for performance tuning or troubleshooting.
I donot know but I guess it may be a utility or a built in command to analyze the sqls running as slow performing.

'topsql' was used by a high level professional in context of perfomance tunning. I could not find it in DB2 Docs.

DBFinder

Is this what you are looking for (from the V9.5 info center):

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Andy

Maybe,

but this one is only Ver 9.5 ; we have mixed env where some are ver db2 v8s

I had seen this before I did post. db2 might be saving sqls in ver 8 too.

I need a solution in a script to run 12 different servers outputting to text or csv file.

I am trying to find out and will post my findings.

Thanks anyway.

DBFinder

You can do a get snapshot for dynamic sql, but you will have to do some manipulation of the output file to figure out the which ones take the longest.