How to determine most recent access to a database

Posted in 2015

LES NELSON — Tue, 29 Dec 2015 19:45:18 — source: IIUG Forums & Mailing Lists

We have an informix instance with 11 databases and it's been live since 2002. The application team that uses them have no recollection for what 4 of the databases are used for and how long it's been since they've been updated or accessed. How can I determine how recent any of them had activty? This is a production level environment. Thanks

↪ replying to LES NELSON

LES NELSON — Tue, 29 Dec 2015 19:52:15 — source: IIUG Forums & Mailing Lists

allow me to add it's IDS 8.21.ud2x2 running on AIX 4.3

↪ replying to LES NELSON

Art Kagel — Tue, 29 Dec 2015 20:21:44 — source: IIUG Forums & Mailing Lists

Version 8.1 isn't IDS but XPS. That said, there is mo way to determine when a database or a table in it was last accessed. Art On Dec 29, 2015 14:45, "LES NELSON" <lnels03@searshc.com> wrote: > We have an informix instance with 11 databases and it's been live since > 2002. > The application team that uses them have no recollection for what 4 of the > databases are used for and how long it's been since they've been updated or > accessed. How can I determine how recent any of them had activty? This is a > production level environment. Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f9a8ce58b9f05280f2a13