RE: [LIKELY JUNK]Re: Who is logged

2007-01-02 Thread Zabach, Elke
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 di

Re: Who is logged

2007-01-02 Thread Lukasz Misztal
MAXDB 7.6.00.34 - I have got this synonim in 'public synonims'. query select * from "ALL_SYNONYMS" where synonym_name='SESSIONS' returns (owner) (Synonym_Name) (table_vner) (tableName) (DB_link) ADMINSESSIONSSYSINFOSESSIONS? (query exec on SQL Studio 7.6.00.27, user

Re: Error changing DBM password

2007-01-02 Thread Martin Cordova
Hi, I just tested this command and it is working fine with 7.6.0.34, I tested it in both modes online/offline. Did you upgrade your system tables after the migration? If you are using WinXP, try this: put your instance online, set the service to autostart, restart your PC and try again the comma

Re: Who is logged

2007-01-02 Thread Daniel Castro
It returns nothing... No results...no errors... Best regards, 2007/1/2, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]>: > 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

Re: Who is logged

2007-01-02 Thread Daniel Castro
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" Best Regards, 2007/1/2, Lukasz Misztal <[EMAIL PROTECTED]>: You can execute query: select * from "SESSIONS" Best regards, Luka

Error changing DBM password

2007-01-02 Thread Mario Rutz
Hello List, I'm trying to change the DBM password with DBMCLI on MAXDB 7.6.0.34(DB is offline): Using: dbmcli -d DBNAME -u DBM,DBM When entering: user_put dbm PASSWORD=newpasswd I'll get the error: -24996,ERR_PARAM: wrong parameters The same happens with DBMGUI(7.6.00.25). When I look with

Re: Who is logged

2007-01-02 Thread Lukasz Misztal
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

RE: Who is logged

2007-01-02 Thread Döhr, Markus ICC-H
> 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 S

Who is logged

2007-01-02 Thread Daniel Castro
Hi, 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? Best Regards, -- Daniel Castro - דניאל MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 316727989 Jabber: danielti Linux

RE: Auto Log not writing LogBackups

2007-01-02 Thread Brunzema, Martin
Hello Florian, when you issue the dbmcli-command "info log" you get information about the used size and the unsaved size of the log. The used size is the one needed for the next restart (i.e. the logpages starting at the last savepoint). The unsaved size ist the number of pages not yet saved. If t