How to Turn Off Journalling Programmatically

Question

Question

Evgeny Shvarov · Jul 27, 2021

#Journaling #InterSystems IRIS

I need to turn off Journalling for a particular database programmatically.

How can I make it happen?

Product version: IRIS 2020.4

Discussion (12)1

Log in or sign up to continue

Lucas Fernandes · Jul 27, 2021

In Caché I use this:

set path = ##class(Config.Databases).Open("USER").Directory

set database = ##class(SYS.Database).%OpenId($get(path))

do database.DisableJournaling()
set status = database.%Save()

do database.EnableJournaling()
set status = database.%Save()

3 1

score 1 · Answer 1 · 2021-07-27T06:51:07-04:00

I have used the following inside one of the classes before executing a huge ingest process.

do DISABLE^%SYS.NOJRN

Then turned journalling back on again after the ingestion was complete.

do ENABLE^%SYS.NOJRN

score 0 · Answer 2 · 2021-07-27T07:14:26-04:00

Thanks, Kinshuk!

This is helpful but this is a SYSTEM wide call. Do you know a way how to turn off journalling for a particular database?

score 1 · Answer 3 · 2021-07-27T07:24:22-04:00

Evgeny,

Fortunately, I had a simple setup and so the consequence of disabling jounalling across the system was imperceptible to me. Hoping someone else has a better answer.

score 1 · Answer 4 · 2021-07-27T11:37:22-04:00

Hello Evgeny,

The ^%SYS.NOJRN tags are actually not system-wide, and just at the process level. That being said, for changing the actual database journaling status, perhaps Lucas' solution makes sense.

For more info on disabling journaling, I think Tani's article series is great. Here's his chapter on some methods to disable journaling. Perhaps you'll find something useful to you now or later:

https://community.intersystems.com/post/preventing-globals-getting-journaled-continued-how-do-i-minimize-my-journals

score 2 · Answer 5 · 2021-07-27T07:06:23-04:00

consider also that even when you use the DISABLE^%SYS.NOJRN if you are within a transaction globals will be saved (e.g when doing a %Save() on an object).

To prevent this you may use:
$system.OBJ.SetTrandsactionMode(0) - to disable transaction
$system.OBJ.SetTrandsactionMode(1) - to enable transaction (leter)

score 1 · Answer 6 · 2021-07-27T09:14:47-04:00

Evgeny Shvarov Jul 27, 2021 to Lucas Fernandes

Thanks, Lucas!

This is what I'm looking for!

1 0

score 0 · Answer 7 · 2022-03-24T11:57:06-04:00

James Woo Mar 24, 2022 to Lucas Fernandes

Where can I find the Config.Database class?

Config.DatabasesConfig.Database class

0 0

score 0 · Answer 8 · 2022-03-24T12:12:54-04:00

James Woo Mar 24, 2022 to James Woo

It's in the %SYS namespace

0 0

score 0 · Answer 9 · 2021-07-27T17:08:03-04:00

Eduard Lebedyuk · Jul 27, 2021

Process-wide call:

do DISABLE^%NOJRN

0 0

score 0 · Answer 10 · 2022-03-26T07:33:18-04:00

Hi!

In older versions of Caché, this command works:

Do DISABLE^%NOJRN
Do ENABLE^%NOJRN

I hope it can help you.

Hug
Rica

score 0 · Answer 11 · 2022-03-27T04:57:18-04:00

Evgeny Shvarov Mar 27, 2022 to Ricardo Baehr

Thanks @Ricardo Baehr

0 0