<div>
Sathyaram,<br />
Thank you again for excellent suggestions
</div>


Sathyaram,
Thank you again for excellent suggestions

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
Is there a way to trace a running or completed SQL back to the user id or the terminal ID that initiated the SQL? We have a situation that we will like to know which of the users or terminals started a application with a sloww running SQL. Can I use a snapshot or event monitor or SQL command to get this information?<br />
<br />
Any and all help will be appreciated.
</div>
</div>


Hi all,

Is there a way to trace a running or completed SQL back to the user id or the terminal ID that initiated the SQL? We have a situation that we will like to know which of the users or terminals started a application with a sloww running SQL. Can I use a snapshot or event monitor or SQL command to get this information?

Any and all help will be appreciated.

How can I find user id or terminal id that is running an application using snapshots or any other AIX tool?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.