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 ]
--