Programmatically (CLP) delete performance data.

15 pts.
How do I programmatically (CLP) delete all performance data except the current month's data?

Software/Hardware used:

Answer Wiki

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

You don’t really want to try to delete performance data yourself. The are in a normalized file system with multiple members across many files. If you Go Perform then option 2, collect performance data then 2 again, configure performance collection, you will be able set the retention period by number of hours or days and the system will purge old collections for you.


Without knowing how you have it configured, it’s impossible to say. In general, review your performance collection configuration in order to learn how your data is organized. The naming convention might be most useful, particularly for the members that get created. Then construct the appropriate DLTPFRDTA command string(s) to delete the member(s) that you no longer want.

Potentially useful commands are GO PERFORM to use a menuing system to review your stuff, DSPPFRDTA to see lists of members, DLTPFRDTA to delete members that you choose.

If you understand the structure, you can retrieve a list of members from a performance data file that you use and compare their creation dates against your criteria. Then issue DLTPFRDTA for the member names that are no longer wanted. The member names will be consistent across all of the various performance data files, so the names of members is what’s important.

As DanD alluded to, you won’t be issuing DLTF nor RMVM commands directly. Use the commands supplied by Performance Tools.


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.
  • Clathan
    We have a secondary performace data library, from which I am wanting to delete data older than the current month. How can this be done in a CL program.
    15 pointsBadges:
  • TomLiotta
    We have a secondary performace data library, ... The same way it was already described -- review one or two physical performance data files in your secondary performance data library to get a feel for the naming convention of the members, then use the performance commands (in a CL program) to delete the members that you want to delete. The DLTPFRDTA command deletes the performance data that your CL program tells it to delete. I don't have access to your system, so I don't know what members you created, when you created them, what data you collected. You can run GO PERFORM and take option 7, Display performance data, to see what data is in the library that you tell it to display. Member names with dates and times are listed. Tom
    125,585 pointsBadges:
  • TomLiotta
    Note that DSPFD TYPE(*MBRLIST) OUTPUT(*OUTFILE) can list members for one of your performance data files, with creation dates to a temporary output file. You can read those records to compare creation dates to see which members are older than your chosen criteria. Tom
    125,585 pointsBadges:

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.


Share this item with your network: