Managing CSV data files
To obtain the best performance from the CICS® PA plug-in, you can manage your CSV data files in various ways.
The CICS monitoring facility can produce a significant volume of output, which can produce large data files. Every time you download data or open a file in the CICS PA plug-in, you use workstation memory. The larger the data selection, or file size, the more memory is used. Opening a large file for analysis might considerably slow your workstation depending on the amount of memory available. Following these suggestions helps to manage your data files in a more efficient way.
- Divide the CSV data between different projects
- Keeping related sets of data in different projects makes data easier to manage. Projects that are not in use can be closed. Closing a project frees up workstation memory.
- Save each CSV file in a separate folder
- Every time a folder is opened, the CICS PA plug-in analyzes all the files in the folder, and saves the information in workstation memory. If you have multiple files in a folder, more memory is used. The memory is not released until the project is closed or until the CICS Explorer® is closed. If each folder contains only one file, the memory usage is kept at a minimum.
- Create CSV files with 17000 records or fewer
- If you are using CSV files, be selective with the size of file that you create. A 17,000 record CSV file is around 15 MB in size. Opening larger files increases the memory usage and might offset the performance of your workstation. If you have a large amount of data, create multiple CSV files instead of one large file.