Troubleshooting
Problem
Identifying all of the actively connected IP addresses to the NPS system.
Resolving The Problem
A DBA may need to identify all of the actively connected IP addresses to the NPS system.
You can find the IP addresses of clients connecting to NPS by running the following query:
select distinct qh_cliipaddr
from _v_qryhist
order by qh_cliipaddr;
Please note that that the number of entries in the _v_qryhist table is determined by the registry value for startup.queryHistTblSize.
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ085932
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21569271