|
-- 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 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.
midrange.com
