angoca / log4db2

A logging utility like log4j for IBM Db2 SQL PL
https://angoca.github.io/log4db2/
BSD 2-Clause "Simplified" License
6 stars 2 forks source link

Logs table partitioned #208

Closed angoca closed 2 years ago

angoca commented 4 years ago

The table where the logs are written, could be partitioned. In this way, remove old logs is only by detaching a partition.

This could help to keep the size of the logs table, reduce the logging by not using delete.

Also, this could create another process, like export a file and then compress it.

angoca commented 2 years ago

Also, when inserting, it should validate the not range error, and create the partition.

angoca commented 2 years ago

The installer includes an option to create the LOGS table with a partition option. It was created at:

However, adding a new partition, it cannot be done within log4db2, because it generates a deadlock when logging in autonomous transactions.