Hallo Elke
I want to see the same informations like Database Manger GUI provides
when I'm connecting to database.
Sesions: 4%, Used 4, Free 96
SYSINFO.ACTIVECONFIGURATION (Parameter MAXUSERTASKS)
- this is correct param for all sessions
SYSINFO.SESSIONS
- returns only 2 lines (only ODBC connections)
(2users are connectes by DBM GUI, 2 by ODCB)
Auto Log: On
SYSINFO.ACTIVECONFIGURATION (Parameter AUTOSAVE)
-parameter doesn't change when I change Automatic Log Backup (1 always)
Command Monitor: Off
SYSINFO.ACTIVECONFIGURATION (Parameter MONITOR_*)
- there are MONITOR_READ, MONITOR_TIME, MONITOR_SELECTIVITY,
MONITOR_ROWNO
parameters but none seems to be right
Database Trace: Off
SYSINFO.ACTIVECONFIGURATION (Parameter TRACE_*)
- there are 79 such params
Dusan
On Thu, 05 Jan 2006 11:45:44 +0100, Zabach, Elke <[EMAIL PROTECTED]>
wrote:
Dusan Kolesar wrote
Hello Elke
Thank you for quick response.
I have found most nedded informations in DATASTATISTICS, LOGSTATISTICS
tables.
I also need:
SELECT
"Sessions (%)" AS SESSION_PER,
"Sessions Max " AS SESSION_TOTAL,
"Sessions " AS SESSION,
SYSINFO.SESSIONS, SYSINFO.ACTIVECONFIGURATION (Parameter MAXUSERTASKS)
"Autosave" AS AUTO_LOG,
SYSINFO.ACTIVECONFIGURATION (Parameter AUTOSAVE)
"Command Monitoring" AS CMND_MON,
SYSINFO.ACTIVECONFIGURATION (Parameter MONITOR_*)
"Kernel Trace" AS KERNEL_TRACE
SYSINFO.ACTIVECONFIGURATION (Parameter TRACE_*)
FROM INFO_STATE
Can you help me where to find them?
It sounds strange to check all of this info in different systemtables.
But I think, you are only USED to see them together in one and need to
know them at different points of time.
Elke
SAP Labs Berlin
Dusan
On Thu, 05 Jan 2006 09:09:33 +0100, Zabach, Elke <[EMAIL PROTECTED]>
wrote:
> Dusan Kolesar wrote:
>>
>> Hello list
>>
>> MaxDB: W32/INTEL 7.6.00 Build 016-123-109-428
>> OS: WinXP Home, SP2
>>
>> Where is DOMAIN.INFO_STATE table?
>> I have used version 7.4.3.32 before and there was such a table.
>> Or is any other way how to read this informations using ODBC?
>> Now the only way I have found to obtain these information is using
> DBMCLI
>> with command "info data" and "info_log". It is important that "info
> infos"
>> command
>> shows that INFO_STATE table should exist.
>>
>> Can you help me please, how to show in application database state?
>
> Which info do you mean, that given in SYSINFO.DATASTATISTICS
>
http://dev.mysql.com/doc/maxdb/en/a4/40d93f130f9115e10000000a155106/fram
> eset.htm
>
> or that written in SYSINFO.LOGSTATISTICS (in newer releases of 7.6)
>
http://dev.mysql.com/doc/maxdb/en/cd/99a841c1dae034e10000000a1550b0/fram
> eset.htm
>
> or what else?
>
> That crazy mixture of info concerning many different aspects of the
> database does not exist any more for public usage.
>
> Elke
> SAP Labs Berlin
>
>>
>> Regards, Dusan
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
