ca.portal.admin

Re:Re: automating journal file concatenation

Discussion created by ca.portal.admin on Feb 16, 2010
we tried this for 5 years - but we had to abandon - throughout the day
on especially on heavy CVs - the offload + append job would take longer
and longer to run as the aggrgate would get bigger and bigger (this was
tape which was probably a mistake) - at times all journals would fill
becuase it took to long to run one offload job and they were of course
singltthreaded

we now offload journals and logs as they fill - and then run an idcams
to get the GDGs created during the day and build a daily tape and then
delete the GDGs just merged

chris

Petra LaFrese wrote:
We use a much simpler method. When offloading journals, we add the
offloaded journal file to an aggregate journal file. Once a day in the
evening backup job, we dump the aggregate file to tape and then
recreate
the aggregate file so we essentially have a day's worth of journals on
one tape. It is not exactly a real-time day because of when the job is
run, but since it is run at about the same time every day, it is what
I
could call a 'processing' day.

Hope this helps,
Petra
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
turning off stats
"for those who have turned off statistics collection to reduce CPU
overhead:

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?

thanks,
Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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 which 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
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
turning off stats
"for those who have turned off statistics collection to reduce CPU
overhead:

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?

thanks,
Chris Hoelscher
IDMS/DB2 Database Architect
Humana Inc
502-476-2538
choelscher@humana.com

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 which 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 Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: turning off stats
"Qualifier - my experience only - however from a number of installations ove=
r 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 togethe=
r - 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 o=
ne 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 s=
aves about 9% - as mentioned.

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

HTH - cheers - Gary =20


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
MailTo:gary.cherlet@sa.gov.au

This e-mail message and any attachments are qualified as follows: Addressin=
g: If you have received this e-mail in error, please advise by reply e-mai=
l to the sender. Please also destroy the original transmission and its con=
tents. Confidentiality: This e-mail may contain confidential information w=
hich also may be legally privileged. Only the intended recipient(s) may ac=
cess, use, distribute or copy this e-mail. Individual Views: Unless otherw=
ise indicated, the views expressed are those of the sender, not Justice Tec=
hnology Services. Computer Viruses: It is the recipient's responsibility t=
o check the e-mail and any attached files for viruses.

Outcomes