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.
I have not used anything other than optim from IBM and even that is touchy and the licensing is expensive.
My challenge would be why? Are you archiving to save legitimate space or just trying to improve performance. There are ways to do both other than archiving.=
Lon,
Performance for the most part.
Thought about using security restrictions to limit data from view but just
want to check what other users are doing with large databases. I don't
think our database is considered big, just being pro-active and planning
ahead.
Regards,
Dennis B
Lon Stone <lonnie_s_stone@yahoo.com>
Sent by: MAXIMO@yahoogroups.com
07/25/2012 04:30 PM
Please respond to
MAXIMO@yahoogroups.com
To
"MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
cc
Subject
RE: [MAXIMO List] Archive Maximo database
I have not used anything other than optim from IBM and even that is touchy
and the licensing is expensive.
My challenge would be why? Are you archiving to save legitimate space or
just trying to improve performance. There are ways to do both other than
archiving.=
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Adding userrestriction will not solve your issue !! It will add more load on the performance
I think you better take a look at tweaking your DB first
Sent from my iPhone
On 25 Jul 2012, at 21:54, dennis_belandres@denso-diam.com wrote:
> Lon,
>
> Performance for the most part.
>
> Thought about using security restrictions to limit data from view but just
> want to check what other users are doing with large databases. I don't
> think our database is considered big, just being pro-active and planning
> ahead.
>
> Regards,
>
> Dennis B
>
>
>
>
> Lon Stone <lonnie_s_stone@yahoo.com>
> Sent by: MAXIMO@yahoogroups.com
> 07/25/2012 04:30 PM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> cc
>
> Subject
> RE: [MAXIMO List] Archive Maximo database
>
>
>
>
>
>
>
> I have not used anything other than optim from IBM and even that is touchy
> and the licensing is expensive.
>
> My challenge would be why? Are you archiving to save legitimate space or
> just trying to improve performance. There are ways to do both other than
> archiving.=
>
>
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
There may come a time when you've squeezed as much as juice as you can from database improvments, as well as, adding resources, not to mention code improvements.
I have not heard of any other tools besides OPTIM, but....
A. I've heard it can be done.
B. I haven't done it but estimated the work to build a custom solution just as expensive as OPTIM, if not more. Not to mention its lack of support from IBM.
--- In MAXIMO@yahoogroups.com, Lon Stone <lonnie_s_stone@...> wrote:
>
> I have not used anything other than optim from IBM and even that is touchy and the licensing is expensive.
>
> My challenge would be why? Are you archiving to save legitimate space or just trying to improve performance. There are ways to do both other than archiving.=
>
>
>
We support a Maximo instance that supports 17 independent organizations.
These organization generate a large number of work orders and the records
that support them (PR, PO, transactions etc.) due to performance issues we
only maintain the current year plus 2 in the production environment. Other
data is archived and available for analysis or other reasons that require
historic information. We have spent considerable resources determining what
records need to be removed from the system as a part of the archive process.
Basically we start with the work order and remove all records that are
associated with the work orders that are archived. It is not a simple
process and we have found a variety of orphaned records and modified our
process to address them. over time but with due diligence you can develop an
effective archive process. The increase in system performance is well worth
the effort.
Kevin
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
foundationboarder187
Sent: Wednesday, July 25, 2012 5:31 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Archive Maximo database
There may come a time when you've squeezed as much as juice as you can from
database improvments, as well as, adding resources, not to mention code
improvements.
I have not heard of any other tools besides OPTIM, but....
A. I've heard it can be done.
B. I haven't done it but estimated the work to build a custom solution just
as expensive as OPTIM, if not more. Not to mention its lack of support from
IBM.
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> , Lon Stone
<lonnie_s_stone@...> wrote:
>
> I have not used anything other than optim from IBM and even that is touchy
and the licensing is expensive.
>
> My challenge would be why? Are you archiving to save legitimate space or
just trying to improve performance. There are ways to do both other than
archiving.=
>
>
>