If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
We do use commitment control on our DB2 files. In order for CC to work, we need to have journaling turned on for the affected data files. My question is whether I have to have journaling turned on for the VV files or not?
All Valence programs update VV files with a commit isolation level of *NONE (meaning COMMIT(*NONE) for SQL, and no COMMIT on any F-specs for native IO), so it's not necessary to journal the VV files. Though you can certainly activate journaling over them if you want to.
Tweet
Comment