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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
