How do I view information about access path in AS400 System?

1215 pts.
Tags:
AS/400 Access Paths
AS/400 administration
AS400 physical file
How to view information about access path in AS400 System? How is the system differentiating access paths for file1 and file2 in AS400?

Software/Hardware used:
AS400

Answer Wiki

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

I’m not sure if this is what you wanted:

The command DSPDBR (display database relations) on the physical file/table will show all the related logical files (indexes/views).

Discuss This Question: 3  Replies

 
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
  • TomLiotta
    How to view information about access path in AS400 System? What do you need to know? Usually, you'd simply run DSPFD <filename> TYPE(*ACCPTH). That displays info for the access path associated with the file description that you name. How is the system differentiating access paths for file1 and file2 in AS400? It differentiates them by the name that you supply. But the question might be more complicated depending on what you want to know. Native I/O can be different from SQL in how "access paths" can be involved. And "shared access paths" might confuse things. Can you explain what you are trying to learn? Tom
    125,585 pointsBadges:
    report
  • rajeshece
    I wanted to know how the AS400 System is differentiating Access Paths? Is it by name? I am haviong 1 PF and 3 LF with different Key Fields. I wanted 2 see Access path of these PF and LFs. How to see?
    1,215 pointsBadges:
    report
  • TomLiotta
    Is it by name? As noted above, "It differentiates them by the name that you supply." And again, it can depend on what you want to know. SQL might choose an access path different from the name that you supply; it can vary depending on clauses such as the WHERE and ORDER BY clauses. SQL might also use a different access path depending what query attributes are set for the job, e.g., time limits might change what SQL chooses. I am haviong 1 PF and 3 LF with different Key Fields. I wanted 2 see Access path of these PF and LFs. How to see? As noted above, "you’d simply run DSPFD <filename> TYPE(*ACCPTH)." If you want to see attributes of all four access paths, you would run DSPFD four times. Tom
    125,585 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