Libarary QPFRDATA too big on the system

[Former Member]

Hi Guys,

We have this library QPFRDATA on our iSeries(i5/OS), which is occupying 10% of our disk space. Its size has grown to almost 231 GB.

we were wondering if we can use the command :

DLTPFRDTA MBR(*SELECT) LIB(QPFRDATA) JOBD(QPFRJOBD)

to lower the size of the system.

Our QPFRADJ(Performance adjustment) parameter is set to 0(0=No adjustment).

Is that Ok to do or is it going to affect our system in any way? I would guess not, but still want to confirm.

Pls advice.

Thanks

Abhi

[Former Member · Accepted solution]

Hi Abhi,

You can and should get rid of the Performance Data )

Yes, QPFRADJ=0 is correct in an SAP environment, if this is combined with a useful setting of QMCHPOOL (about 10% of the main memory) and more or less the rest in Pool 2 ...

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member · Accepted solution]

Hi Volker

Can we do a CLRLIB on that library QPFRDATA?

We are asking because doing :

DLTPFRDTA MBR(*SELECT) LIB(QPFRDATA) JOBD(QPFRJOBD)

did not reduce the size of the library that much. When we executed the above command, it came back with the select screen where we had to select the members Q<nnnnnnnn> and submit the job.

Will doing a CLRLIB OK for this performance library?

Thanks

Abhi

[Former Member · Accepted solution]

Hi,

you can do so ....

... but mostly this is NOT successful, because of special locks ... but if you kill all these jobs, you should be successful (might be SAPOSCOL as well to kill ...)

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member · Accepted solution]

Hi Volker,

Thanks a lot for it.

I came across a another link as well on iSeries Forumn which says you can, but just wanted to confirm it.

http://searchenterpriselinux.techtarget.com/tip/0,289483,sid3_gci901234,00.html

Anyway, I will also put the CRTPFRDTA JOB in QSYSWRK on hold before I do clear the library.

Let me try

Thanks a lot

Abhi

[Former Member]

QPFRDATA is the default library for Collection Services. You might want to try turning off Collection Services if you are having locking problems when trying to clear the library.

After you have deleted some of the data in the library you should configure Collection Services to avoid the situation where it is allowed to grow to such a large size. Collection Services can be configured to automatically delete performance data after a certain period of time as well as not collect as much data to begin with. Collection Service can also be turned off, though I think SAPOSCOL uses the Collection Services data.

Collection Services can be configured by going to menu GO PERFORM, selecting option 2 "Collect Performance Data" and then selecting option 2 again "Configure Performance Collection".

Kolby

[Former Member]

Hi Kolby,

That helped us out a lot. We checked the retention period and it was set to *PERM and hence there was data from 2005 and all, Changed that to 24 hrs

Thanks a lot for that great info.

Thanks

Abhi

[Former Member]

Hi Kolby,

as SAPOSCOL uses that and you can - as I think - activate that without having the "tool on board", my question would be hot to change the configuration if the "go perform" menu is not installed ?

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[jorgen_johansen]

Hi Volker,

collect performance data is part of the base operating system. You can configure the behaviour of "create collections" with iSeries Navigator under "Configuration and Services / Collection Services", right click and select properties. Here you find an expiration date on collections. You can also navigate to performance data if you configure your collectionservice so that performance tables are created from collections. When viewing performance data you optionally delete them.

Regards

Jørgen

[Former Member]

Hi Jörgen,

that's really a great and easy to use feature of OpsNav ))

btw: Plancache Dump of V5R4 is really a great feature as well and works really good and similiar to ST04, that often "creates headache" at customers.

Thanks

Volker