Methods used to maintain the access path of a file

pts.
Tags:
IBM DB2
Sarang wrote in with this question recently: "Can someone please name and define the three methods used to maintain the access path of a file?" Do you know the methods? -- Debra Tart, associate editor, Search400.com

Answer Wiki

Thanks. We'll let you know when a new response is added.

The 3 methods are defined on the Help for the MAINT parm from CRTPF, CHGPF, CRTLF, CHGLF.

I have never had any reason to use *REBLD or *DLY.

*IMMED
*REBLD
*DLY

*IMMED
The access path is continuously (immediately)
maintained for each physical file member. The path is
changed each time a record is changed, added to, or
deleted from the member. *IMMED is specified for all
files requiring unique keys to ensure uniqueness in
all inserts and changes.

*REBLD
The access path is rebuilt when a file member is
opened. The access path is continuously maintained
until the member is closed; then the access path
maintenance is ended. *REBLD is not valid for access
paths that contain unique key values.

*DLY
The maintenance of the access path is delayed until
the member is opened for use. Then the access path is
changed only for records that were added, deleted, or
changed since the file was last closed. (While the
file is open, all changes made to based-on members are
immediately reflected in the access paths of the
members of the opened files, no matter what is
specified for the Access path maintenance (MAINT)
parameter.) To prevent a lengthy rebuild time when
the file is opened, *DLY should be specified only when
the number of changes to the access path between a
close operation and the next open operation are small
(when key fields in records for this access path
change infrequently). *DLY is not valid for access
paths that require unique key values.
If the number of changes between a close operation and
the next open operation reaches approximately 10% of
the access path size, the system stops saving changes
and the access path is completely rebuilt the next
time the file is opened.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ricksmith
    Immediate, delayed, rebuild
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following