You can translate the question and the replies:

Denodo Monitor Logs External DB

Hi We are storing denodo monitor logs in external db(pgadmin).It is taking time to fetch details from request notification table.Is the table request notification, a system generated one. If so, how can we improve performance for this.
user
25-10-2023 07:39:39 -0400
code

1 Answer

Hi, I understand that there is a delay in fetching the logs from the request notification table which is stored in an external database(pgadmin). The "request_notification" table will not generated by default; It has to be manually created using the SQL statement located within the Denodo monitor's home directory and connection details needs to be configured in the Denodo Monitor configuration file.Then the generated logs in the Denodo Monitor logs directory will be copied to the external table as well. Therefore, in order to improve the performance of the PostgreSQL table, I recommend contacting your DBA team to optimize the "request_notification" tables present in Postgres. Hope this helps!
Denodo Team
27-10-2023 06:12:00 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here