RE: [LIKELY JUNK]Re: Who is logged

 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
>