Journal size

Question

Question

Sylvie Greverend · Mar 19, 2020

#Journaling #Caché

Sorry about my newbie question.

How do you decide the size to give to journal1 and journal2?

PS: I am still in version 2016

Thank you

Discussion (2)1

Log in or sign up to continue

Erik Hemdal · Mar 26, 2020

Sylvie, you didn't specify the exact version you are using; in v2016.1.1 and later, the limit of 999 journal files per day was removed.

If you are creating a lot of journal activity, and the 999 limit applies to you, you can also increase the size of each journal file so fewer are created each day. As Eduard posted, testing your workload is the way to determine the journal space you need.

0 0

score 0 · Answer 1 · 2020-03-20T07:00:55-04:00

If you can rebalance later, the easiest way is to run the workload and see how much journals are generated.

Otherwise run workload tests in a DEV environment.

The more write-intensive the system is the more journals you need.