This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Good day,
I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
PM WO Generation process was run for:
ACTIVE PM Records - 200
# of Days used - (365+98) + 365 days
Start Time - 02:05pm
Finish Time - 04:05pm
# of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
Please note that no other users were on the system while it was running.
Is this typical?
Thank you.
Hi,
First off you should have set up a separate report and cron task server and run the PMWoGenCronTask cron task only on that server.
When you generated the PMs you used an entire year? That seems like a lot.
We generate about 100 PM work orders a day and each has about ten tasks. So about 1,000 a day. The cron task runs at 0145 and usually finishes about 15 to 20 minutes later.
In the Organization application in the Select Action > PM Options I put in a where clause for each site. So for a site like HN that generates PMs for the next 45 days I use
status = 'ACTIVE' and siteid = 'HN'
and nextdate - IsNull(leadtime,0) - 45 <= getdate()
So the cron task is only looking at those PMs that are due. We have over 11,000 PMs and this greatly reduced the time it takes to run the cron task.
Hope this helps.
Dave Bone
--- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@...> wrote:
>
> Good day,
>
> I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
>
> PM WO Generation process was run for:
>
> ACTIVE PM Records - 200
> # of Days used - (365+98) + 365 days
>
> Start Time - 02:05pm
> Finish Time - 04:05pm
>
> # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
>
> These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
>
> Please note that no other users were on the system while it was running.
>
> Is this typical?
>
> Thank you.
>
Sonia,
When I run the PMWOGen Crontask in (Maximo 6.2.5)it automatically kicked off at 0400 and ran to 0600. It generated about 18000 records including task work orders.
--- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@...> wrote:
>
> Good day,
>
> I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
>
> PM WO Generation process was run for:
>
> ACTIVE PM Records - 200
> # of Days used - (365+98) + 365 days
>
> Start Time - 02:05pm
> Finish Time - 04:05pm
>
> # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
>
> These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
>
> Please note that no other users were on the system while it was running.
>
> Is this typical?
>
> Thank you.
>
+1 for what David said. try to filter out PMs that don't need to be processed so that the cron task doesn't need to call the generate work method on PMs needlessly. That may cut down on your time some. You may also try to trace the database and see if possibly there is some opportunity for database tuning as far as indexes and statistics go.
--- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@...> wrote:
>
> Good day,
>
> I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
>
> PM WO Generation process was run for:
>
> ACTIVE PM Records - 200
> # of Days used - (365+98) + 365 days
>
> Start Time - 02:05pm
> Finish Time - 04:05pm
>
> # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
>
> These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
>
> Please note that no other users were on the system while it was running.
>
> Is this typical?
>
> Thank you.
>
Hi Dave, Thanks so much for your response. Yes your answer was very helpful. Sorry for my late reply.
--- In MAXIMO@yahoogroups.com, "in2data" <in2data@...> wrote:
>
> Hi,
>
> First off you should have set up a separate report and cron task server and run the PMWoGenCronTask cron task only on that server.
>
> When you generated the PMs you used an entire year? That seems like a lot.
>
> We generate about 100 PM work orders a day and each has about ten tasks. So about 1,000 a day. The cron task runs at 0145 and usually finishes about 15 to 20 minutes later.
>
> In the Organization application in the Select Action > PM Options I put in a where clause for each site. So for a site like HN that generates PMs for the next 45 days I use
>
> status = 'ACTIVE' and siteid = 'HN'
> and nextdate - IsNull(leadtime,0) - 45 <= getdate()
>
> So the cron task is only looking at those PMs that are due. We have over 11,000 PMs and this greatly reduced the time it takes to run the cron task.
>
> Hope this helps.
>
> Dave Bone
>
> --- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@> wrote:
> >
> > Good day,
> >
> > I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
> >
> > PM WO Generation process was run for:
> >
> > ACTIVE PM Records - 200
> > # of Days used - (365+98) + 365 days
> >
> > Start Time - 02:05pm
> > Finish Time - 04:05pm
> >
> > # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
> >
> > These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
> >
> > Please note that no other users were on the system while it was running.
> >
> > Is this typical?
> >
> > Thank you.
> >
>
Hi. Thank you.
Do you cron tasks run on a separate server?
--- In MAXIMO@yahoogroups.com, "dancue23" <dancue2008@...> wrote:
>
> Sonia,
>
> When I run the PMWOGen Crontask in (Maximo 6.2.5)it automatically kicked off at 0400 and ran to 0600. It generated about 18000 records including task work orders.
>
> --- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@> wrote:
> >
> > Good day,
> >
> > I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
> >
> > PM WO Generation process was run for:
> >
> > ACTIVE PM Records - 200
> > # of Days used - (365+98) + 365 days
> >
> > Start Time - 02:05pm
> > Finish Time - 04:05pm
> >
> > # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
> >
> > These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
> >
> > Please note that no other users were on the system while it was running.
> >
> > Is this typical?
> >
> > Thank you.
> >
>
Thank you for your response.
--- In MAXIMO@yahoogroups.com, ahohnstein@... wrote:
>
> +1 for what David said. try to filter out PMs that don't need to be processed so that the cron task doesn't need to call the generate work method on PMs needlessly. That may cut down on your time some. You may also try to trace the database and see if possibly there is some opportunity for database tuning as far as indexes and statistics go.
>
> --- In MAXIMO@yahoogroups.com, "Sonia" <salkhal@> wrote:
> >
> > Good day,
> >
> > I am trying to determine if the PM Work order generation process is indeed taking too long to run on our Maximo 7.5 system. The users have complained about how long it is taking so I am trying to find out how if it is comparable to other companies' Maximo installations.
> >
> > PM WO Generation process was run for:
> >
> > ACTIVE PM Records - 200
> > # of Days used - (365+98) + 365 days
> >
> > Start Time - 02:05pm
> > Finish Time - 04:05pm
> >
> > # of Records Created - 24201 (This figure includes all Work Orders and their corresponding TASK records)
> >
> > These records were created at a pace of approx. 202 records per minute or just over 3 records per second.
> >
> > Please note that no other users were on the system while it was running.
> >
> > Is this typical?
> >
> > Thank you.
> >
>