Mon, 15 Jul 2019 14:28:39 GMT
I am having some problems to identify last access on my databases;
I am trying with:
oncheck -pT to know last disk access;
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,
Mon, 15 Jul 2019 16:31:33 GMT
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.
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
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 :)