Open full view…

Last database access

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

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

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...

Mon, 15 Jul 2019 21:16:53 GMT

Hi Andreas,

Mon, 15 Jul 2019 21:17:44 GMT

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

Mon, 15 Jul 2019 21:18:15 GMT

That maybe one RFC :)