Daniel Castro wrote: > It returns: > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > Base table not found;-4004 POS(16) Unknown table name:SESSIONS. > select * from "SESSIONS" >
Which version of MaxDB do you use? At least with 7.5.00.30 Systemview SESSIONS is available. Or didn't you make load_systab? Elke SAP Labs Berlin > Best Regards, > > 2007/1/2, Lukasz Misztal <[EMAIL PROTECTED]>: > > > > You can execute query: select * from "SESSIONS" > > > > Best regards, > > > > Lukasz > > > > Döhr, Markus ICC-H napisał(a): > > >> Is there anyway to see who is logged, which machine (ip or > > >> name) , which app is accessing the DB (like SQL Server for > > >> example) and which SQL statement is being executed? > > >> > > > > > > You can try to run > > > > > > select * from running_commands > > > > > > > > > Greetz, > > > > > > > > > SIEGENIA-AUBI KG > > > Informationswesen > > > > > > i.A. > > > > > > Markus Döhr > > > SAP-CC/BC, SAPDB-DBA > > > > > > Tel.: +49 6503 917-152 > > > Fax: +49 6503 917-7152 > > > E-Mail: [EMAIL PROTECTED] > > > Internet: http://www.siegenia-aubi.com > > > > > > > > > > > > > > ---------------------------------------------------------------------- > > Jestes kierowca? To poczytaj! >>> http://link.interia.pl/f199e > > > > > > > -- > Daniel Castro - דניאל > MSN: [EMAIL PROTECTED] > Skype: danielti2005 > ICQ : 316727989 > Jabber: danielti > Linux User: 387864 > AOL User: Danielti2005 > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli > Deo Gloria >
