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