Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Maintenance Considerations for zSeries >

About Tracing the Source of a Query

Using Session ID, administrators can identify from which terminals queries are generated.

The session ID is composed of three parts: host IP in decimal, process ID, and serial number. A session ID might look like this: 172.20.80.25_324_1.

Eventually the object manager and DB2 host would share the same string that can be used to identify the current connection.

Once the session ID is displayed at the Server Manager, you can also check it on the database side.

To verify session ID on DB2 host

1. At the Option prompt, enter the location of the DB2 Primary Option Menu.

   The DB2 Primary Option Menu appears.

2. At the Command prompt, enter D to access the DB2 Defaults Panel.
3. At the Command prompt, enter the name of the subsystem that you are connecting to.
4. Press F3 to go back to the DB2 Primary Option Menu.
5. At the Command prompt, enter the selection that will take you to the DB2 Command window.
6. At the DB2 Command window, enter the following:

   -DISPLAY THREAD(*) DETAIL

   NOTE:  The "-" is required.

7. Press ENTER to display current active threads.

The session ID string is displayed in the application name field. In case there are many active threads shown here, you should be able to find out your thread by matching the corresponding host name and userid.

The session ID is composed of client IP_client process id_serial #.