P31225 Manufacturing Scheduling WorkBench

scott_parker

Reputable Poster
Greetings,

The Program P31225 seems to be causing some MAJOR delays on our system. It is normal for a 10 to 60 second delay after taking this menu option for the data to actually come up on the screen.

Also, I have noticed that when our system is "Crawling" there are 2 people who are trying to use this program. Both Interactive sesions seem to be trying to build the same logical file. Our CPU usage may only be at 40%-60% at the time but any screens can take around 10 to 60 seconds to come up during this time.

I don't have the command WRKSYSACT so I can not see what system type jobs are running at this time. (and that sucks)

The based on file of this program is *NONE, but if I do a '5' to display the Cover sheet it does show some data selections and sequence Options. Selections are set to Order type = *all and Sequence by Order Type.

This just does not seem right to me. I always thought that in order to have Data selections and or Sequence you HAD to have a based on file. In this case I would think it would be the F4801. There is not an OVRDBF in the CL anyway so any selections or sorts in that DW would not matter anyway.

The Processing Option # 9 has a 1 in it to sort the records by Requesed Date.

I guess what I am getting at is.

Has anyone else noticed any performance hit when 2 or more users are trying to enter this program at the same time? Or does anyone have any suggestions on what to look for to fix this.

Thank you in advance.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
 
Re: P31225 Manufacturing Scheduling WorkBench

We also have a significant time delay opening this screen - and had almost
the same delay on our old box (9402-200 CISC) as we do on our new box,
(9406-720 dual processor.) I notice the delay even with only one person
opening it. Any thoughts on improved performance would also be
appreciated.

David Bryant
Maxco Supply, Inc.
 

curryj

Well Known Member
This program seems to want some default information filled in in the
Processing Options. We put a default item number in processing option 17,
and the time to come up on the screen went from 60+ seconds to a couple of
seconds.

It's easy then for the user to change the criteria in the header screen, and
performance seems fine. We definitely had the same issue if only one user
trying to use the program.
 

MGrejtak

Member
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07F38.72B0CF20
Content-Type: text/plain

We discovered this long ago and found out using a default branch and planner
code seemed to help out.

Michael Grejtak
Systems Analyst
Raw Material/Inventory/Manufacturing
Hancor, Inc.
(419)424-8253

>
 

gapaff

Member
Scott,
I agree with you that the dreamwriter selections and sequence do not effect the based on file. It has been a while since I've looked at the response problem for the Workbench.
What I have noticed is that depending on the selections made Manufacturing Scheduling Workbench, the program (P31225) will access different logicals over F4801.
Certain selections (on the left hand side of the screen) will do a SETLL and then do a READE and the rest of selections made will simply act as filters. The response time on these type of selections should be ok, depending on number of records satisfying the READE and the number of hits (depending on if there are other filter selections).
We have done a few programmatic changes to speed up the response time. If the Branch/Plant is entered, and the following are left blank

Process/Item . . .
Customer . . . . .
Planner. . . . . .
Parent W.O. No . .

Then, we changed the logic to do a setll and a reade with VDMMCU.
We also added a processing option (and also created a logical file with a selection WASRST RANGE(' ' '95'). When the processing option is taken, and the new logical is used, many records do not have to be read in.
One more programming change that we did is that if the VDMMCU is filled in, then, just check the Business Unit Security one time while reading in the records. (BU security calls a functional server and there is a lot of overhead involved.)
This is a brief description of what we did. If you want, I can get more familiar and detailed with this. Greg
 

DCard

Member
This program does a record read when it initializes that can take a long
time. A real simple temporary solution/work-around is to put an item number
in processing option 17. I usually use an invalid item number such as 1.
What happens is that you get an error condition, but the video displays much
more quickly. Then the user can clear the bogus item number and enter the
data they would like to search for. Not a real elegant solution, but it
works.

Dave
 

MBrooks

Member
Re: P31225 Manufacturing Scheduling WorkBench

I experienced this same problem at another client site. They made a
decision to limit the processing options that were used and create a
logical that was keyed accordingly. This helped them tremendously.


--------------------------------
Michael E. Brooks
Business Consultant
DataProfit Corporation
Office: 412.201.1592 x 132
mbrooks@dataprofit.com
 

prumschlag

Active Member
Re: P31225 Manufacturing Scheduling WorkBench

Response time improved significantly for us by simply leaving the Status Code
From and To values blank. Apparently the program reads the files in an
inefficient sequence when these parameters are filled in.

Phil








scott parker <scott.parker@grote.com> on 01/15/2001 02:58:49 PM

Please respond to jdeworld@jdelist.com








To: jdeworldml@jdelist.com

cc: (bcc: Phil Rumschlag/PHD)



Subject: P31225 Manufacturing Scheduling WorkBench ~~0:3986








Greetings,

The Program P31225 seems to be causing some MAJOR delays on our system. It is
normal for a 10 to 60 second delay after taking this menu option for the data to
actually come up on the screen.

Also, I have noticed that when our system is "Crawling" there are 2 people who
are trying to use this program. Both Interactive sesions seem to be trying to
build the same logical file. Our CPU usage may only be at 40%-60% at the time
but any screens can take around 10 to 60 seconds to come up during this time.

I don't have the command WRKSYSACT so I can not see what system type jobs are
running at this time. (and that sucks)

The based on file of this program is *NONE, but if I do a '5' to display the
Cover sheet it does show some data selections and sequence Options. Selections
are set to Order type = *all and Sequence by Order Type.

This just does not seem right to me. I always thought that in order to have
Data selections and or Sequence you HAD to have a based on file. In this case
I would think it would be the F4801. There is not an OVRDBF in the CL anyway so
any selections or sorts in that DW would not matter anyway.

The Processing Option # 9 has a 1 in it to sort the records by Requesed Date.

I guess what I am getting at is.

Has anyone else noticed any performance hit when 2 or more users are trying to
enter this program at the same time? Or does anyone have any suggestions on
what to look for to fix this.

Thank you in advance.


Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=3986
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

mackip

Member
--------------916ABBE781A169EE74748D08
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Scott,

Our P31225 is VERY slow to get into also, but once a user is in they are OK. Do you get the message that you have read an excessive number of records. We have started purging our work orders and this has helped some. You may want to consider that if you aren't woing it already. As for the Based on File being
*NONE, this is the way most interactive DWs are set up, so that's not the problem. Ours looks the same.

Good Luck,

Pam MacKinnon

scott parker wrote:

> Greetings,
>
> The Program P31225 seems to be causing some MAJOR delays on our system. It is normal for a 10 to 60 second delay after taking this menu option for the data to actually come up on the screen.
>
> Also, I have noticed that when our system is "Crawling" there are 2 people who are trying to use this program. Both Interactive sesions seem to be trying to build the same logical file. Our CPU usage may only be at 40%-60% at the time but any screens can take around 10 to 60 seconds to come up during this time.
>
> I don't have the command WRKSYSACT so I can not see what system type jobs are running at this time. (and that sucks)
>
> The based on file of this program is *NONE, but if I do a '5' to display the Cover sheet it does show some data selections and sequence Options. Selections are set to Order type = *all and Sequence by Order Type.
>
> This just does not seem right to me. I always thought that in order to have Data selections and or Sequence you HAD to have a based on file. In this case I would think it would be the F4801. There is not an OVRDBF in the CL anyway so any selections or sorts in that DW would not matter anyway.
>
> The Processing Option # 9 has a 1 in it to sort the records by Requesed Date.
>
> I guess what I am getting at is.
>
> Has anyone else noticed any performance hit when 2 or more users are trying to enter this program at the same time? Or does anyone have any suggestions on what to look for to fix this.
>
> Thank you in advance.
>
> Scott Parker
> Grote Industries, LLC.
> WorldSoftware Version 8.1.2 AS/400 V4R5
> --------------------------
> Visit the forum to view this thread at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=3986
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************

--------------916ABBE781A169EE74748D08
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Scott,


Our P31225 is VERY slow to get into also, but once a user is in they
are OK. Do you get the message that you have read an
excessive number of records. We have started purging our work orders
and this has helped some. You may want to consider that if you aren't
woing it already. As for the Based on File being *NONE, this is the
way most interactive DWs are set up, so that's not the problem. Ours
looks the same.


Good Luck,


Pam MacKinnon


scott parker wrote:
<blockquote TYPE=CITE>Greetings,


The Program P31225 seems to be causing some MAJOR delays on our system.
It is normal for a 10 to 60 second delay after taking this menu option
for the data to actually come up on the screen.


Also, I have noticed that when our system is "Crawling" there are 2
people who are trying to use this program. Both Interactive sesions
seem to be trying to build the same logical file. Our CPU usage may
only be at 40%-60% at the time but any screens can take around 10 to 60
seconds to come up during this time.


I don't have the command WRKSYSACT so I can not see what system type
jobs are running at this time. (and that sucks)


The based on file of this program is *NONE, but if I do a '5' to display
the Cover sheet it does show some data selections and sequence Options.
Selections are set to Order type = *all and Sequence by Order Type.


This just does not seem right to me. I always thought that in
order to have Data selections and or Sequence you HAD to have a based on
file. In this case I would think it would be the F4801.
There is not an OVRDBF in the CL anyway so any selections or sorts in that
DW would not matter anyway.


The Processing Option # 9 has a 1 in it to sort the records by Requesed
Date.


I guess what I am getting at is.


Has anyone else noticed any performance hit when 2 or more users are
trying to enter this program at the same time? Or does anyone have
any suggestions on what to look for to fix this.


Thank you in advance.


Scott Parker

Grote Industries, LLC.

WorldSoftware Version 8.1.2 AS/400 V4R5

--------------------------

Visit the forum to view this thread at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=3986

*************************************************************

This is the JDEList World Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************</blockquote>
</html>

--------------916ABBE781A169EE74748D08--
 
Top