does anyone knows an easy way to get the pid for the instance in a windows platform. I know it is in the db2diag.log, but having a tool renaming this file, to avoid having a large file, there might be no db2diag.log at a specific moment. it would not be easy to find the latest rename file.
Thanks for all info
Best Regards, Guy Przytula

I'm not sure I really understand what it is you're asking for. But if you want to get the current process/session ID, you can do that with

this query will return the applid for this application.
what I need is the process id (pid) in windows for this instance, as reflected in db2diag.log and tag pid:xxx

Try pslist from sysinternals. It lists the processes running on a system

http://www.sysinternals.com/Utilities/PsList.html

When using the Cygwin environment, the "ps -W" command gives the "WINPID" value for all processes, which is the Windows process ID. Search for the "db2inst" process in that list.