From: Dusan Kolesar (d.kolesarcentrum.sk)
Date: Thu Jan 05 2006 - 03:50:34 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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,
     "Autosave" AS AUTO_LOG,
     "Command Monitoring" AS CMND_MON,
     "Kernel Trace" AS KERNEL_TRACE
   FROM INFO_STATE

Can you help me where to find them?

Dusan

On Thu, 05 Jan 2006 09:09:33 +0100, Zabach, Elke <elke.zabachsap.com>
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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]