× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



--
This is nothing to be with 'magic' and 'sins'. The list of logical files was 
created by SSA Acclaim ( I also worked in SSA for 5 years ) in UK. And, as I 
said in my
previous e-mail, this was NOT created for a specific customer. The job was  
check the biggest processes in BPCS and review which SQLs were using and 
whether the access path is covered by a logical file or not. If not, create a 
logical covering the SQL and reducing the acces time.
The sources are also in the savefile, you can check what logicals/keys are 
created. It is made following the Basis methodology.

And again, as I said in the previous e-mail, a job of investigating in each 
instalation has to be done, this is standard. I also traveled a lot correcting 
BPCS installs, and most of the time the problems were due to the software. If 
anybody has suffered an implementation of  BPCS on v6.02 or 04 , especially at 
the first releases, knows what I am talking about.

Regards,

Albert.


-----Mensaje original-----
De:     Nick Camino [SMTP:ncamino@attglobal.net]
Enviado el:     viernes, 23 de noviembre de 2001 17:09
Para:   'bpcs-l@midrange.com'
Asunto: RE: Poor Response Times ... BPCS INV

--
I strongly recommend against using a list of logical files from any other 
client.  Each installation of BPCS is unique, an access pasth that helps one 
client can bring another client to a grinding halt.  This topic has been 
covered extensively in previous BPCS-L discussion threads the result being 
there is a best practice from SSA/IBM for getting to the bottom of this problem.

Please download Chapters 10 and 11 from the IBM Redbook Implementing SSA's 
eBPCS on the AS/400 System 
<http://www.redbooks.ibm.com/abstracts/sg245410.html>, SG24-5410-00.  The 
download is free and the process is fairly straight forward.  You can also 
purchase the book from IBM (around $40 I think).

During my career at SSA I soent quite a lot if time flying around the world 
correcting BPCS installs that were running slow after a "magic" list of logical 
files was applied.  I am no longer with SSA so I have no stake in this at all, 
I just hate to see past sins repeated.

Regards,

Nick Camino





-----Original Message-----
From:   Albert Lopez [SMTP:alblopezc@yahoo.es]
Sent:   Friday, November 23, 2001 10:07 AM
To:     'bpcs-l@midrange.com'
Subject:        RE: Poor Response Times ... BPCS INV

--

I have a savefile that contains a library with a command that creates a set of 
logical files for BPCS 6.04
which improves the performance of the programs. This set of logical files was 
created after investigating
the most used programs/files and the acces key used in the programs.
I installed this logicals in several  companies in Spain .Anyway, the way each 
customer
executes the programs is different ( eg. is not the same pick by line than by 
order, the key to access file IPP
is different), so after installing the logicals in the customers we did a work 
of investigation to see what was
improved and what not. And for the processes we still needed to improve, the 
way was easy:
do a PRTSQLINF for the programs, and check wich SQL's are creating access path 
or have high estimated query execution
time; then create a logical that covers this querys.

If anybody wants this library I can send it via e-mail. Is stored in V4R2.

Alber López
IBS Spain
Tfn:   + 34 91 383 43 20
Fax : + 34 91 383 50 25

www.ibsesp.com
_



-----Mensaje original-----
De:     Danny Monselise [SMTP:dannym@agis-group.co.il]
Enviado el:     miércoles, 21 de noviembre de 2001 18:26
Para:   bpcs-l@midrange.com
Asunto: Re: Poor Response Times ... BPCS INV


>From version 6.04 and onwards the package is written enterally in
AS/Set+embeded SQL
therefore the performance is worse .
with subfile you can not go back once you positioned you have to
reposition...
like i said if you build the right logical ith ecl ech sih and so on the
package will start to react like you know from version 4 i have been thru
that in December 1998 when i upgraded v4.2 to 6.04 .
also think of upgrading the machine by disk size ( source are huge inv500d2
can not be seen thru regular seu because it is more then 32764 lines..) and
memory i did that in all 3 sites.
good luck
Danny




                    dweaver1@mmm.co
                    m                      To:     bpcs-l@midrange.com
                    Sent by:               cc:
                    bpcs-l-admin@mi        Subject:     Re: Poor Response Times 
... BPCS INV
                    drange.com


                    21/11/2001
                    18:53
                    Please respond
                    to bpcs-l






Al Mac - many thanks for a comprehensive reply.
I've got a few things to check now.

BEWARE - V6 seems to read ITH in a different way to V4 (we upgraded from
this).
V4 seems to get a 'screenfull' of data & read more when the user request
another page - response-times were OK here with this....
V6 seems to get everything (for that part number) & gives little delay when
the user requests another page - just a huge delay initially....



_______________________________________________
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.




_______________________________________________
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.
--
[ Content of type application/ms-tnef deleted ]
--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

_______________________________________________
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.
--
[ Content of type application/ms-tnef deleted ]
--

_______________________________________________
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.
--
[ Content of type application/ms-tnef deleted ]
--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.