RE: Remove Access Path Journal on PF not journaled

" Are you running one of the high availability solutions like HA ..."

No


This thread is restarted in the L-Group midrange-l@xxxxxxxxxxxxxxxxxx

I tried duplicating the Journaling status of the file as found in WRKF
(shown below) Its not possible!
You can not have #1 off (File Journal) with #3 on (Access path Journal).
Access Path Journal (#3)
must be turned off 1st before you can turn off File Journal (#1).

-----------------------------------------------

L-Group,

How do you stop/end the access path from being journaled on DDS PF as shown
in #3 below???

Basically, how to change #3 below from
"Access path journaled . . . . . . . . : Yes"
To
"Access path journaled . . . . . . . . : No"


WRKF shows journal stats in three different places for the DDS PF as shown
below,
#3 is the one of interest, need to flip it to "No" ("Access path journaled .
. . . . . . . : Yes")

#1.
Maximum record length . . . . . . . . . . . : 276
Volatile . . . . . . . . . . . . . . . . . : No
Keep in memory . . . . . . . . . . . . . . : KEEPINMEM *NO
File is currently journaled . . . . . . . . : No

#2.
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE Yes
Access path journaled . . . . . . . . . . . : No

#3.
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . : 45,725,680
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . : 2080415744
Number of access path entries . . . . . : 40991764
Access path valid . . . . . . . . . . . : Yes
Implicit access path sharing . . . . . : Yes
Access path journaled . . . . . . . . : Yes





-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
DFreinkel
Sent: Sunday, June 14, 2020 2:13 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Remove Access Path Journal on PF not journaled

Are you running one of the high availability solutions like HA (high
availability ). Some use journaling to replicate to another system and so
create journals for the purpose.


--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com