How-to Remove "Access Path Journal" on DDS PF ? -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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:

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.