turning off stats

Discussion created by ca.portal.admin on Feb 19, 2010
Latest reply on Feb 19, 2010 by ca.portal.admin
for those who have turned off statistics collection to reduce CPU

where were the biggest savings found:

turning off PERFMON externalization?
turning off PERFMON collection?
turning off DCSTATS externalization?
turning off DCSTATS collection?

and for those who run stats only infrequently - how often and for how long?

Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc

you only need to test the programs that you want to work correctly

The information transmitted is intended only for the person or entity to wh=
ich it is addressed and may contain CONFIDENTIAL material. If you receive =
this material/information in error, please contact the sender and delete or=
destroy the material/information.
IDMS 3rd-party providers forum


Re: turning off stats
"Qualifier - my experience only - however from a number of installations over a great many years - all were single region IDMS-DB/DC architecture with heavy ADS/O and some DC-Cobol.

turning off PERFMON externalization? If you mean writing to SMF - no saving - if you mean turning off PMAM with or without SMF about 2-3%

turning off PERFMON collection? I think we turned off PMIM and PMAM together - so about 2-3%

turning off DCSTATS externalization? If stats are already being collected (a pre-requisite) then zip for going to SMF - don't even think about DC-Log in anything but a low use test system.

turning off DCSTATS collection? If you have STAT TASK COLLECT USER you can save about 17-19% by turning the whole lot OFF - by changing USER to NOUSER you can save about 9-10% and still COLLECT stats.

and for those who run stats only infrequently - how often and for how long? We have a charge back ""model"" based on the days when we ran stats all the time. We now refresh the model with 1 week of stats in every 4 weeks, and one month of stats every now and then - when we do turn stats COLLECT on we specify NOUSER as that contributes nothing to the charge back model - and saves about 9% - as mentioned.

Figures are based on a dodgy memory as I am at the beach enjoying sun and surf so this is off the top of my head - these figures are pretty good as a guide though.

HTH - cheers - Gary

Gary Cherlet
Justice Technology Services
Department of Justice, SA Government
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613

This e-mail message and any attachments are qualified as follows: Addressing: If you have received this e-mail in error, please advise by reply e-mail to the sender. Please also destroy the original transmission and its contents. Confidentiality: This e-mail may contain confidential information which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. Individual Views: Unless otherwise indicated, the views expressed are those of the sender, not Justice Technology Services. Computer Viruses: It is the recipient's responsibility to check the e-mail and any attached files for viruses.