Online spec. tables.
Posted in 1992
Hey out there ! I am writing a special version of tbmonitor for internal use with Informix online. On this job it would be nice if any of you have info on the special online tables with "monitor" information. I am designing a program that needs information from the Informix ONLINE system, the program will (When finished) be an advanced version of the tbmonitor program. After makeing the 'master' database using the script $INFORMDIR/etc/makeps.sql, which has given me some of the information i wanted. I would now like to know how these tables should be used. I.e. A user is waiting with lock mode set to wait, this will give a value in sysusrtab.wttime ( start time for wait ?) and a value in sysusrtab.lkwait. My guess is that the value in lkwait could be used to get the name of the table for which the user is waiting for. Please HELP me ..... Thanks ---------------------------------------------------------------------- Databaseadministrator Poul Pedersen Kuwait Petroleum (Denmark) A/S Hummeltoftevej 49 Mail: pp@q8.dk 2830 Virum Voice: +45 45 98 45 94 Denmark Fax: +45 42 85 14 18 ----------------------------------------------------------------------