asked on How to list IPs and users connections to DB2 database?
Hi,
We want to know which IPs, and username, have connected last day or week to our DB2 database. Is is possible?
Thanks.
We want to know which IPs, and username, have connected last day or week to our DB2 database. Is is possible?
Thanks.
DB2
Last Comment
Kent Olsen
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What version of DB2 are you running? Those system tables are "relatively" new, having been introduced at version 10, I think.
Without them you won't find much (if any) information on past sessions.
Without them you won't find much (if any) information on past sessions.
ASKER
Hi, FInd below db2 version:
():[db2d] /db2/db2d -> db2level
DB21085I This instance or install (instance name, where applicable: "db2d")
uses "64" bits and DB2 code release "SQL10013" with level identifier "0204010E".
Informational tokens are "DB2 v10.1.0.3", "s130918", "IP23509", and Fix Pack "3".
Product is installed at "/opt/IBM/db2/V10.1".
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
First sentence runs with "SELECT * FROM sysibmadm.applications" but the second not runs correctly
SQL0204N "SYSIBM.SESSIONS" is an undefined name. SQLSTATE=42704
But the information for first sentence is only the actual connections, is possible see the connections between two dates?
Thanks