1
  • Missing file description for a physical file

    We copied data from one environment to another. One file is causing problems. The data exists, the object exists, the database relations exist but the file description (DSPFD) is missing so no journalling. I can't rename the object and copy a new version, and I can't CRTDUPOBJ because the object...

    AbbyBurroughs15 pointsBadges:
  • DSPFD and DSPDBR

    Hi, Difference in the no of physical file count in a library using the DSPFD command and DSPDBR. DSPFD FILE(/) TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(/File1) OUTMBR(*FIRST *ADD) When I try to take the count of this outfile for type ='P' the value is 1000(For eg). But when I store the results of DSPDBR...

    Prashanth123255 pointsBadges:
  • How to get the maximum access path size value in a program?

    Hi Friends, My requirement is to get the Maximum access Path size value in the program, I have the value as 1TB and 4GB in 2 different PF in different machine by DSPFD command. But I could not get the details when I OUTFILE using DSPFD, Even I tried RTVOBJD, RTVMBRD, I could not find it or I may...

    as400dev505 pointsBadges:
  • AS400 Level Check

    I am receiving a Level Check on a CL. The DSPPGMREF and DSPFD show matching Record Level Identifiers. I cannot figure out the cause or the fix. Can someone help me, please? Thanks.

    MPCM10 pointsBadges:
  • Getting the number of deleted records from Physical file

    My requiremnt is to get the number of deleted records from a physical file. This will clear more.When we give DSPFD File name, at bottom we can see the number of records deleted from the so how to pull that field which consist of the value of number of deleted records

    ankit2002770 pointsBadges:
  • Reading all pfs in production lib. using cl pgm

    Dear all, I want to write a cl program under following scenario. 1. Use the command DSPFD to build a list of files existing in LIBA.(which is Prod Lib.) 2. Read the file. 3. Use Command RGZPFM to reorganize Every File that has more than 1000 deleted records Run the job and then DSPFD again to check...

    6r1,590 pointsBadges:
  • I want to dump the contents of the DSPFD command to file and then use FNDSTRPDM to find certain text strings

    I am doing some testing with file attributes that I want to automate.  I have been using the DSPFD command to print the attributes of the file.  I would now like to automate that.  I tried dumping the output of the command to an outfile and then using FNDSTRPDM to find out if the attribute was...

    Qa40045 pointsBadges:
  • DSPFD – Asking for some explainin about a field in DSPFD output

    Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.

    QPFRADJ165 pointsBadges:
  • Display only the PFs and the number of records in each PF, from a library

    Get the library name from a different user , accept the library name , then send the list of only the Physical files in that library , along with the number of records in each PF , to that user.

    Athulcs5 pointsBadges:
  • Searching out and eliminating unuse files on AS/400

    We have over 1700 files & members in a production library, and we know that there are many that are no longer used or pertinent. We thought we could clean these up by running DSPFD to a physical file and checking such parameters as "last used date", but this seems to be ambiguous and fraught with...

    Stoogenut10 pointsBadges:
  • AS/400 File Maint.

    I have a library that I would like to view all the files with the number of records and the number of deleted records on one report. DSPFD does this, but you must select each file one by one. This library has hundreds of files so that's not going to happen. Thank You, Douglas L McDuffie

    DLM2007285 pointsBadges:
  • To get a perticular string details from all the members of a file

    Here i am doing get all the member names from the perticular file. for that use dspfd command and pertilular MBRLST and the output instead of displaying saving in a file and reading that file in aloop CL program using RCVF command and overriding the file with the each memberthen call the program in...

    It doubts85 pointsBadges:
1

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