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.
we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
classification table. It takes about 1 sec to show the window,
Ewald
--
Basis:
You have implemented a complete CLASSIFICATION system for use on ITEM MASTERS
which involves all the underlying tables which are sizeable. SQL is the backend
db.
Issue:
When you click the chevron (>>) next to Item field and select CLASSIFICATION,
it takes 30-45 sec for the pop-up window to appear. This is the window that has
the CLASSES on the left and the ATTRIBUTES to the right. The CLASSES are shown
in a hierarchial drill-style view.
Details:
Table indexing is enabled on the SQL db.
Question:
Are there other settings, possibly within Maximo, that impact the time it takes
to display the search box ?
Can you confirm if you index your database tables and/or if there are some other Maximo settings that control caching of tables, etc. ??
We're looking again at the indexing just in case.
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: Wednesday, December 03, 2014 10:51 AM
To: Maximo Group
Subject: re: [MAXIMO List] CLASSIFICATION SEARCH window takes 45 sec to render
we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
classification table. It takes about 1 sec to show the window,
Ewald
--
Basis:
You have implemented a complete CLASSIFICATION system for use on ITEM MASTERS
which involves all the underlying tables which are sizeable. SQL is the backend
db.
Issue:
When you click the chevron (>>) next to Item field and select CLASSIFICATION,
it takes 30-45 sec for the pop-up window to appear. This is the window that has
the CLASSES on the left and the ATTRIBUTES to the right. The CLASSES are shown
in a hierarchial drill-style view.
Details:
Table indexing is enabled on the SQL db.
Question:
Are there other settings, possibly within Maximo, that impact the time it takes
to display the search box ?
Hi,
Identify the query which is causing performance degradation. Perfmon might
work handy.
Here is the link to set up activity dashboard.
https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/performance_maximo_activity_dashboard_perfmon?lang=en
Hope this would help..!!!
On 3 December 2014 at 23:15, 'Klemenok, Eric' eric.klemenok@mallinckrodt.com
[MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> Can you confirm if you index your database tables and/or if there are some
> other Maximo settings that control caching of tables, etc. ??
> We're looking again at the indexing just in case.
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Wednesday, December 03, 2014 10:51 AM
> To: Maximo Group
> Subject: re: [MAXIMO List] CLASSIFICATION SEARCH window takes 45 sec to
> render
>
> we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
> classification table. It takes about 1 sec to show the window,
>
> Ewald
>
> --
>
> Basis:
>
> You have implemented a complete CLASSIFICATION system for use on ITEM
> MASTERS
> which involves all the underlying tables which are sizeable. SQL is the
> backend
> db.
>
> Issue:
>
> When you click the chevron (>>) next to Item field and select
> CLASSIFICATION,
> it takes 30-45 sec for the pop-up window to appear. This is the window
> that has
> the CLASSES on the left and the ATTRIBUTES to the right. The CLASSES are
> shown
> in a hierarchial drill-style view.
>
> Details:
>
> Table indexing is enabled on the SQL db.
>
> Question:
>
> Are there other settings, possibly within Maximo, that impact the time it
> takes
> to display the search box ?
>
>
>
>
>
>
>
--
Yours;
Vijay Kumar Giliyar
Check to see if one (or more) of the fields that are in your index have been set to UPPER. If so, the index may NOT be used. This has been a performance glitch since Maximo 3. Pat Morrow
pmorrow8@yahoo.com
From: "vijay kumar viji2kinna@gmail.com [MAXIMO]" <MAXIMO@yahoogroups.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, December 3, 2014 1:08 PM
Subject: Re: [MAXIMO List] CLASSIFICATION SEARCH window takes 45 sec to render
Hi,
Identify the query which is causing performance degradation. Perfmon might
work handy.
Here is the link to set up activity dashboard.
https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/performance_maximo_activity_dashboard_perfmon?lang=en
Hope this would help..!!!
On 3 December 2014 at 23:15, 'Klemenok, Eric' eric.klemenok@mallinckrodt.com
[MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> Can you confirm if you index your database tables and/or if there are some
> other Maximo settings that control caching of tables, etc. ??
> We're looking again at the indexing just in case.
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Wednesday, December 03, 2014 10:51 AM
> To: Maximo Group
> Subject: re: [MAXIMO List] CLASSIFICATION SEARCH window takes 45 sec to
> render
>
> we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
> classification table. It takes about 1 sec to show the window,
>
> Ewald
>
> --
>
> Basis:
>
> You have implemented a complete CLASSIFICATION system for use on ITEM
> MASTERS
> which involves all the underlying tables which are sizeable. SQL is the
> backend
> db.
>
> Issue:
>
> When you click the chevron (>>) next to Item field and select
> CLASSIFICATION,
> it takes 30-45 sec for the pop-up window to appear. This is the window
> that has
> the CLASSES on the left and the ATTRIBUTES to the right. The CLASSES are
> shown
> in a hierarchial drill-style view.
>
> Details:
>
> Table indexing is enabled on the SQL db.
>
> Question:
>
> Are there other settings, possibly within Maximo, that impact the time it
> takes
> to display the search box ?
>
>
>
>
>
>
>
--
Yours;
Vijay Kumar Giliyar
#yiv1492155204 #yiv1492155204 -- #yiv1492155204ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1492155204 #yiv1492155204ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1492155204 #yiv1492155204ygrp-mkp #yiv1492155204hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1492155204 #yiv1492155204ygrp-mkp #yiv1492155204ads {margin-bottom:10px;}#yiv1492155204 #yiv1492155204ygrp-mkp .yiv1492155204ad {padding:0 0;}#yiv1492155204 #yiv1492155204ygrp-mkp .yiv1492155204ad p {margin:0;}#yiv1492155204 #yiv1492155204ygrp-mkp .yiv1492155204ad a {color:#0000ff;text-decoration:none;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ygrp-lc {font-family:Arial;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ygrp-lc #yiv1492155204hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ygrp-lc .yiv1492155204ad {margin-bottom:10px;padding:0 0;}#yiv1492155204 #yiv1492155204actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1492155204 #yiv1492155204activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1492155204 #yiv1492155204activity span {font-weight:700;}#yiv1492155204 #yiv1492155204activity span:first-child {text-transform:uppercase;}#yiv1492155204 #yiv1492155204activity span a {color:#5085b6;text-decoration:none;}#yiv1492155204 #yiv1492155204activity span span {color:#ff7900;}#yiv1492155204 #yiv1492155204activity span .yiv1492155204underline {text-decoration:underline;}#yiv1492155204 .yiv1492155204attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1492155204 .yiv1492155204attach div a {text-decoration:none;}#yiv1492155204 .yiv1492155204attach img {border:none;padding-right:5px;}#yiv1492155204 .yiv1492155204attach label {display:block;margin-bottom:5px;}#yiv1492155204 .yiv1492155204attach label a {text-decoration:none;}#yiv1492155204 blockquote {margin:0 0 0 4px;}#yiv1492155204 .yiv1492155204bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1492155204 .yiv1492155204bold a {text-decoration:none;}#yiv1492155204 dd.yiv1492155204last p a {font-family:Verdana;font-weight:700;}#yiv1492155204 dd.yiv1492155204last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1492155204 dd.yiv1492155204last p span.yiv1492155204yshortcuts {margin-right:0;}#yiv1492155204 div.yiv1492155204attach-table div div a {text-decoration:none;}#yiv1492155204 div.yiv1492155204attach-table {width:400px;}#yiv1492155204 div.yiv1492155204file-title a, #yiv1492155204 div.yiv1492155204file-title a:active, #yiv1492155204 div.yiv1492155204file-title a:hover, #yiv1492155204 div.yiv1492155204file-title a:visited {text-decoration:none;}#yiv1492155204 div.yiv1492155204photo-title a, #yiv1492155204 div.yiv1492155204photo-title a:active, #yiv1492155204 div.yiv1492155204photo-title a:hover, #yiv1492155204 div.yiv1492155204photo-title a:visited {text-decoration:none;}#yiv1492155204 div#yiv1492155204ygrp-mlmsg #yiv1492155204ygrp-msg p a span.yiv1492155204yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1492155204 .yiv1492155204green {color:#628c2a;}#yiv1492155204 .yiv1492155204MsoNormal {margin:0 0 0 0;}#yiv1492155204 o {font-size:0;}#yiv1492155204 #yiv1492155204photos div {float:left;width:72px;}#yiv1492155204 #yiv1492155204photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1492155204 #yiv1492155204photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1492155204 #yiv1492155204reco-category {font-size:77%;}#yiv1492155204 #yiv1492155204reco-desc {font-size:77%;}#yiv1492155204 .yiv1492155204replbq {margin:4px;}#yiv1492155204 #yiv1492155204ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1492155204 #yiv1492155204ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1492155204 #yiv1492155204ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1492155204 #yiv1492155204ygrp-mlmsg select, #yiv1492155204 input, #yiv1492155204 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1492155204 #yiv1492155204ygrp-mlmsg pre, #yiv1492155204 code {font:115% monospace;}#yiv1492155204 #yiv1492155204ygrp-mlmsg * {line-height:1.22em;}#yiv1492155204 #yiv1492155204ygrp-mlmsg #yiv1492155204logo {padding-bottom:10px;}#yiv1492155204 #yiv1492155204ygrp-msg p a {font-family:Verdana;}#yiv1492155204 #yiv1492155204ygrp-msg p#yiv1492155204attach-count span {color:#1E66AE;font-weight:700;}#yiv1492155204 #yiv1492155204ygrp-reco #yiv1492155204reco-head {color:#ff7900;font-weight:700;}#yiv1492155204 #yiv1492155204ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ov li a {font-size:130%;text-decoration:none;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1492155204 #yiv1492155204ygrp-sponsor #yiv1492155204ov ul {margin:0;padding:0 0 0 8px;}#yiv1492155204 #yiv1492155204ygrp-text {font-family:Georgia;}#yiv1492155204 #yiv1492155204ygrp-text p {margin:0 0 1em 0;}#yiv1492155204 #yiv1492155204ygrp-text tt {font-size:120%;}#yiv1492155204 #yiv1492155204ygrp-vital ul li:last-child {border-right:none !important;}#yiv1492155204
> we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
> classification table. It takes about 1 sec to show the window,
Nothing immediately springs to mind. If you open a PMR for it maybe
IBM has an idea. You mentioned indexing; how certain are you the
indexing is sufficient? Could you try b-trees?
-C
By any chance, does your site use McAfee? We had this very issue. It used
to take 1.5 minutes to open the classification dialog in inventory. We
finally found the culprit was "script scanning" in McAfee.
Kevin Wertz
Grifols Therapeutics
Clayton, NC
On Thu, Dec 4, 2014 at 9:16 AM, maximo list owner maximal@wanko.com
[MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
>
> > we are on 7.5.0.4 (no optimizations) and have about 30000 records in the
> > classification table. It takes about 1 sec to show the window,
>
> Nothing immediately springs to mind. If you open a PMR for it maybe
> IBM has an idea. You mentioned indexing; how certain are you the
> indexing is sufficient? Could you try b-trees?
>
> -C
>
>
Hi Eric,
You could test this in our Petten Live Environment. Or wait until we actually have Classifications implemented into Production.
- Your Company's Maximo IS Team