Hello everyone,
I've been trying recently to create some sort of event monitor (not sure if this is a correct solution) in DB2 to try to keep tracks of a view's usage (each time it i used it in a SELECT statement, for instance).
I've seen multiple solutions existing for T-SQL, but can't seem to find a good answer for DB2.
------------------------------------------------------------------------------
Example of T-SQL solutions:
- Forum answers:
https://dba.stackexchange.com/questi...et-usage-stats
- Microsoft answers:
https://docs.microsoft.com/en-us/sql...ql-server-2017
I've seen a possible solution for DB2 here, although I'm not sure I can trigger it on a view:
https://www.ibm.com/support/knowledg.../r0055061.html
------------------------------------------------------------------------------
I'm trying to use this view in an excel document later on, but putting my view inside a stored procedure (to insert each usage in a table) severely limitates usage possibilities in the future (not possible to select specific rows)
Anyone ever tried this before?
Any help would be appreciated.
- Emile
I've been trying recently to create some sort of event monitor (not sure if this is a correct solution) in DB2 to try to keep tracks of a view's usage (each time it i used it in a SELECT statement, for instance).
I've seen multiple solutions existing for T-SQL, but can't seem to find a good answer for DB2.
------------------------------------------------------------------------------
Example of T-SQL solutions:
- Forum answers:
https://dba.stackexchange.com/questi...et-usage-stats
- Microsoft answers:
https://docs.microsoft.com/en-us/sql...ql-server-2017
I've seen a possible solution for DB2 here, although I'm not sure I can trigger it on a view:
https://www.ibm.com/support/knowledg.../r0055061.html
------------------------------------------------------------------------------
I'm trying to use this view in an excel document later on, but putting my view inside a stored procedure (to insert each usage in a table) severely limitates usage possibilities in the future (not possible to select specific rows)
Anyone ever tried this before?
Any help would be appreciated.
- Emile
Comment