RE: Question regarding Share Open data path

We have had our share of ECM performance problems; we are on version 6.02 
(heavily modified). We did not try to share open data paths - so I won't 
comment. I am not sure what is running slow in ECM, but I will comment on some 
of the things we did:


For the first few times we posted orders, we posted at about 1 every 3 or 4 
minutes. Given we can process up to 800 orders, you see can see we had some 
huge run times. We followed the performance tuning guide that was at the bpcs 
ssa web site and ensured we had only 2 or 3 open jobques for the order post 
jobs.

We reviewed sql access plans (prtsqlinf command) and through experience of 
watching the jobs for inbound orders we added the appropriate logicals for the 
order entry system. We applied the BPCS performance APAR's issued by IBM.

We post about 4 orders per minute now.

The other modification we did was to run inbound and outbound processes 
concurrently within ECM. It took a rather sharp consultant about 3 or 4 weeks 
to design, code, implement and test. I was not thrilled about doing this 
initially because we looped ECM about once a week (duplicate guids). I have to 
say we have had some very positive results here since it was implemented about 
1 1/2 years ago. Throughput was improved considerably.



-----Original Message-----
From: FWSoftware@aol.com [mailto:FWSoftware@aol.com]
Sent: Tuesday, April 16, 2002 5:01 PM
To: bpcs-l@midrange.com
Subject: Question regarding Share Open data path


Hello,

Our current BPCS environment is experiencing ECM performance problems. We are 
debating many different enhancement alternatives, One is Overriding all ECM 
open files with a Database Share Open data paths *yes.

My concern is that by Sharing the open data paths that might open the door to 
file pointer corruption problems.

Any thoughts on the side effects of Share open data path override *YES?

Thanks
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.