Prevent specific table data from being rolled back

InterSystems FAQ rubric

There is data, such as execution log data, that you do not want to return to its previous state even if a rollback occurs during a transaction. The above requirement can be met by placing that data in the IRISTEMP database, which will not be rolled back.

Temporary Globals and the IRISTEMP Database

By mapping the table entities you do not want to roll back to this database, you can retain the information after the rollback.

However, the contents of this database will be cleared when IRIS is restarted, so if you want to keep it permanently, you will need to copy it to a permanent table at some point (after a rollback, etc.).

Alternatively, you can make a table operation non-transactional by stopping journaling for the process before the operation and then restarting journaling after the operation is complete.

However, this method cannot be used when using mirroring.

Managing journaling at the process level with %NOJRN

Developer Community Article