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

Software/Hardware used:
5722PT1
ASKED: February 2, 2010  9:51 PM
UPDATED: February 9, 2010  10:10 PM

Answer Wiki:
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. Tom
Last Wiki Answer Submitted:  February 4, 2010  1:28 am  by  DanD   2,865 pts.
All Answer Wiki Contributors:  DanD   2,865 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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 pts.

 

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

 110,165 pts.

 

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

 110,165 pts.