ENDJRNAP is the command .
Augie Palumbos
312-735-3723
702-826-2836
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
Sent: Sunday, June 14, 2020 9:55:21 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How-to Remove "Access Path Journal" on DDS PF ?
Joe,
You apparently have a PF with a unique key. The system automatically creates and maintains an access path to enforce that constraint.
There are several things that can cause an access path to be implicitly journaled:
SMAPP - system managed access path protection
implicitly shared access paths (due to other LFs sharing the same keys)
and perhaps other reasons
Try to find out where this access path is journaled (to what journal), and why, before you just try to "end journaling" ...
Q: Why do you want to "end journaling" on this particular access path? For what purpose or reason? Perhaps if we knew why, we can suggest some alternatives to achieve that goal or accomplish that task in another way?
For example, you could save the PF and any LFs over that PF in a save file, and specify ACCPTH(*NO) on the SAVOBJ command, then delete the LFs and the PF, then restore them from the save file, with STRJRN(*NO) on the RSTOBJ command ... (just one possibility; no guarantee this will "resolve" your particular issue or accomplish what you wanted...)
Hope that helps,
Mark S. Waterbury
On Sunday, June 14, 2020, 12:03:32 PM EDT, <jm@xxxxxxxxxxxxxxxx> wrote:
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:
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
Joe McDonald
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-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
midrange.com
