Can we get a list of files with size of their access paths for iSeries data files?

1480 pts.
Tags:
AS/400
CL command
iSeries
Is there any command which can give a list of files with size of their access paths for iSeries data files?


Software/Hardware used:
CL 400
1

Answer Wiki

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

Purpose is to find the list of files whose access path size is nearing 4GB size.

Try using the command  

 DSPOBJD OBJ(DATALIB/*ALL) OBJTYPE(*FILE) OUTPUT(*OUTFILE) OUTFILE(QTEMP/LOGICALS)

This will send output to a file and then query it and look for logical files near that size.

Discuss This Question: 6  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.
  • TheRealRaven
    I don't think any "command" is on most systems for this, though it'd be pretty easy to create one. For nearly all systems, it's probably a one-time thing, so there isn't much reason to have a permanent command for it.

    The Admin Alert: The 4 GB Access Path Size Time Bomb article gives a pretty good description of steps you can take to locate all potential problem files. Since the default on creating files now is *MAX1TB, it's not likely that future files will be problems for a few years to come.
    33,730 pointsBadges:
    report
  • TheRealRaven
    The "Answer" needs more detail. First, "logical file" is not = "access path". Second, the size of the access path is only half of the required info; the missing important part is the ACCPTHSIZ() attribute which isn't part of the object description. A LF might be 3.999GB in size, but it wouldn't matter at all if it's set as *MAX1TB. That attribute is part of the member header in data files.
    33,730 pointsBadges:
    report
  • JohnsonMumbai

    Used below command to get list of physical files and ran query to get list of 4GB access path size files.  However for certain physical files access path size parameter is found with size and for some no such parameter exists. 

    How can we get the size of access path where the parameter is not found.  Why do some files have the parameter and others don't.

    Also noticed the files where access patch size parameter is not found are files with multiple member.

    1,480 pointsBadges:
    report
  • JohnsonMumbai

    The command is

    DSPFD FILE(*ALL/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF)
    OUTFILE(libname/PHYSFILES)

    1,480 pointsBadges:
    report
  • JohnsonMumbai

    Also noticed parameter saying access path activity Statistics do not show any value.

    1,480 pointsBadges:
    report
  • pdraebel
    @Johnson: some physical files are keyed, so the access path exists and has a size. One will also have to look at the logicals based on those physicals and list their size as well.
    7,545 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.

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

Following

Share this item with your network: