Is Sysview Performance for DB2(IDB2) able to show which threads are using the secure and unsecure ports? 
search cancel

Is Sysview Performance for DB2(IDB2) able to show which threads are using the secure and unsecure ports? 

book

Article ID: 247344

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Few distributed db2 threads connecting from DB2 Connect.

R/HTLIST        Thread History List                                    Item 1/5
SORT OFF                                   Records Read First 08/03/22 12:35:35
From 08/03/22 12:35:35 To 08/03/22 12:54:12          11  Last 08/03/22 12:54:12
                                                               HHH:MM:SS MM:SS.TTT
       Time      Auth ID   Plan    Connect  Correlation Exc PM  DB2 Dur   DB2 CPU

. 12:35:35.2270 XFMHYJA  DISTSERV SERVER   db2bp          0            0     0.000
. 12:35:49.2879 XFMHYJA  DISTSERV SERVER   db2bp          0            0     0.001
. 12:44:28.9805 XFMHYJA  DISTSERV SERVER   db2bp          0            0     0.000
. 12:54:03.5200 XFMHYJA  DISTSERV SERVER   db2bp          0            0     0.000
. 12:54:12.4840 XFMHYJA  DISTSERV SERVER   db2bp          0            0     0.001


Some of them are using secure port (SECPORT) and some are using unsecure port (TCPPORT).

Is Sysview Performance for DB2(IDB2) able to show which threads are using the secure and unsecure ports? 
If yes, which panel?

 

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

Sysview Performance for DB2(IDB2) doesn't provide info about the ports that the threads are using.