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.
Hi,
We are encountering Maximo Slowdown/Frozen very often. We found that there were database blockings while the users were experiencing Maximo Slowdown/Frozen. Sometime the blockings were cleared by themselves in a couple of minutes but sometimes it may take longer. Sometimes we need to manually remove the blockings in the database. Once the blockings were removed, Maximo were back to normal. Here are some examples of the blockings.
Most Recent Blocking
Date Stamp
Database
Time(ss)
Victim SPID
Victim Login
Victim SQL Text
Blocking SPID
Blocking Login
Blocking SQL Text
Dec 4 2015 7:04AM
mxprod75
70.14
62
MAXIMO
select * from workorder where (owner is not null and historyflag=0 and assetnum = 'A0002' and datediff(mi,(select max(owndate) from woownerhistory h where h.wonum=workorder.wonum and h.siteid=workorder.siteid and h.owner=workorder.owner),getdate()) < 3) and changedate <= { ts '2015-12-04 07:02:50.111' } OPTION (FAST 1000)
111
MAXIMO
select * from workorder where (wonum = 'W15L25739' and siteid = 'GH') and (exists ( select siteid from siteauth a,groupuser b where a.groupname=b.groupname and b.userid = 'MALORACH' and a.siteid = workorder.siteid)) OPTION (FAST 1000)
Most Recent Blocking
Date Stamp
Database
Time(ss)
Victim SPID
Victim Login
Victim SQL Text
Blocking SPID
Blocking Login
Blocking SQL Text
Dec 4 2015 7:03AM
mxprod75
40.14
62
MAXIMO
select * from workorder where (owner is not null and historyflag=0 and assetnum = 'A0002' and datediff(mi,(select max(owndate) from woownerhistory h where h.wonum=workorder.wonum and h.siteid=workorder.siteid and h.owner=workorder.owner),getdate()) < 3) and changedate <= { ts '2015-12-04 07:02:50.111' } OPTION (FAST 1000)
111
MAXIMO
select * from multiassetlocci where recordkey= 'W15L25691' and recordclass= 'ACTIVITY' and assetnum is not null and worksiteid= 'GH' and multiid =(select min(multiid) from multiassetlocci multi2 where multi2.recordkey=multiassetlocci.recordkey and multi2.recordclass=multiassetlocci.recordclass and multi2.worksiteid=multiassetlocci.worksiteid and multi2.assetnum=multiassetlocci.assetnum and multi2.siteid=multiassetlocci.siteid) and assetnum in (select assetnum from asset where siteid= 'GH' and itemnum is not null) OPTION (FAST 1000)
Most Recent Blocking
Date Stamp
Database
Time(ss)
Victim SPID
Victim Login
Victim SQL Text
Blocking SPID
Blocking Login
Blocking SQL Text
Dec 4 2015 7:00AM
mxprod75
141.23
109
MAXIMO
select * from workorder where (owner is not null and historyflag=0 and assetnum = 'A0002' and datediff(mi,(select max(owndate) from woownerhistory h where h.wonum=workorder.wonum and h.siteid=workorder.siteid and h.owner=workorder.owner),getdate()) < 3) and changedate <= { ts '2015-12-04 06:58:09.122' } OPTION (FAST 1000)
111
MAXIMO
select * from invreserve where wonum= 'W15L25410' and siteid= 'GH' and itemnum in (select itemnum from wpmaterial where wonum= 'W15L25410' and siteid= 'GH' ) OPTION (FAST 1000)
We are running on Maximo 7.5.0.6 with SQL Server 2008.
Do you experience any similar problem? How do you resolve it?
Thanks,
Samson