Ralf Schneider wrote: > Can I find out when a user connects to the database? Is this > somewhere written > into a protocol (e.g. knldiag)? I do not need to know which > user connects, > but the time when a user established a connection. > > Any hints?
in knldiag is written <date> <time> ...... CONNECT Connect req. (T<taskno>, Node:<current node>, PID:<current pid>) if a client asks for a connection to the database. Which sql-statement is sent using this connection is not known. But only the SQL-statement CONNECT will work correctly. If the client (or the kernel) releases a connection knldiag shows <date> <time> ...... CONNECT Connection released, T<taskno> On the other hand the systemview DOMAIN.CONNECTEDUSERS will tell you, which sessions are CURRENTLY working with the server, but no time they started. --> knldiag is the one you are looking for. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
