informix-community

Open full view…

Last database access

speres
Mon, 15 Jul 2019 14:28:39 GMT

Hi, I am having some problems to identify last access on my databases; I am trying with: oncheck -pT to know last disk access; or with select max(ustlowts) from systables. But, I have some doubts about these results, is this correct? is there any other way to know when the last connection was made? other than through the logs as we don't use them? Thanks for any help, SP

andreasl
Mon, 15 Jul 2019 16:31:33 GMT

Hi S. I think, if you're on 12.10.xC10 or newer, the best we'd have is 'oncheck -pt <database>' | grep "Last Lookup/Scan"' and find the latest (index) access. HTH, Andreas

andreasl
Mon, 15 Jul 2019 16:57:38 GMT

For future accesses you might rely on some simple sysdbopen() logic, maybe updating a data_access table with CURRENT each time a database gets opened...

speres
Mon, 15 Jul 2019 21:16:53 GMT

Hi Andreas,

speres
Mon, 15 Jul 2019 21:17:44 GMT

Thanks for your reply, I suspect that and just want to confirm

speres
Mon, 15 Jul 2019 21:18:15 GMT

That maybe one RFC :)