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.
Hey Gang,
Does anyone know if there is a way to encrypt messages(inbound/outbound records) using WebServices with the MIF.
thanks,
John
Run on HTTPS
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of John Ballnik
Sent: 19 February 2013 20:54
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Security through WebServices
Hey Gang,
Does anyone know if there is a way to encrypt messages(inbound/outbound records) using WebServices with the MIF.
thanks,
John
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
I have a client that is missing key OOTB indexes in SQL Server. It also seems that they are missing from maxsysindexes and maxsyskeys tables.
Does anyone have any creative ways to fix this?
I have tried integritychecker without success.
Thank you in advance,
One of dirty way.... try run updated.bat
On Feb 20, 2013 6:30 PM, "Lonnie Stone" <lonnie_s_stone@yahoo.com> wrote:
> **
>
>
> I have a client that is missing key OOTB indexes in SQL Server. It also
> seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
>
Not sure if this is a fresh install, if so you could restore db from another backup..
On Feb 20, 2013, at 7:30 PM, Lonnie Stone <lonnie_s_stone@yahoo.com> wrote:
> I have a client that is missing key OOTB indexes in SQL Server. It also seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
Nice idea but it did not work. Since my last db and current db values are up to date it did not do anything.
________________________________
From: Vasu Kiran Chilukuri <vasukiranch@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, February 20, 2013 7:32 PM
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
One of dirty way.... try run updated.bat
On Feb 20, 2013 6:30 PM, "Lonnie Stone" lonnie_s_stone@yahoo.com> wrote:
> **
>
>
> I have a client that is missing key OOTB indexes in SQL Server. It also
> seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
>
Hi Lonnie,
Open maxdemo.sqs from the maximo\tools\maximo\ directory
Pull out the commands for creating indexes (create index… create unique index … etc) and the section for inserting the indexes back into maxsyskeys and maxsysindexes …
Run that; have SQL Server update statistics; you should be good to go … slap the person that deleted the indexes (HARD)….
I’ve done this dozens of times in the past on other versions of Maximo – if it errors because the index is there… so what – it’s supposed to be there … <grin>…
I prefer the MaxDemo file as it has a better set of indexes than the Maximo one… or at least it used to and I’ve not had time to double check the new releases…
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lonnie Stone
Sent: Wednesday, February 20, 2013 6:59 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Nice idea but it did not work. Since my last db and current db values are up to date it did not do anything.
________________________________
From: Vasu Kiran Chilukuri vasukiranch@gmail.com<mailto:vasukiranch%40gmail.com>>
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Sent: Wednesday, February 20, 2013 7:32 PM
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
One of dirty way.... try run updated.bat
On Feb 20, 2013 6:30 PM, "Lonnie Stone" lonnie_s_stone@yahoo.com<mailto:lonnie_s_stone%40yahoo.com>> wrote:
> **
>
>
> I have a client that is missing key OOTB indexes in SQL Server. It also
> seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
>
This looks great. I will test it out in tomorrow and report back to the group.
Thank you,
Lonnie Stone
lonnie_s_stone@yahoo.com
IBM Certified Solution Advisor:
Maximo Enterprise Asset Management Solutions V2
Tivoli Service Delivery & Process Automation Solutions V2
IBM Certified Solution Designer:
Maximo Asset ManagementV7.1
IBM Certified Deployment Professional:
Maximo Asset Management V6
Maximo Asset Management V7.1
Tivoli Asset Management for IT V7.2
IBM Certified System Administrator:
WebSphere Application Server Network Deployment V6.0
WebSphere Application Server Network Deployment V7.0
IBM Certified Application Developer:
TRIRIGA Application Platform V3.2
________________________________
From: Will Hampton <will.hampton@exxtremeconsulting.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Wednesday, February 20, 2013 8:14 PM
Subject: RE: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Hi Lonnie,
Open maxdemo.sqs from the maximo\tools\maximo\ directory
Pull out the commands for creating indexes (create index… create unique index … etc) and the section for inserting the indexes back into maxsyskeys and maxsysindexes …
Run that; have SQL Server update statistics; you should be good to go … slap the person that deleted the indexes (HARD)….
I’ve done this dozens of times in the past on other versions of Maximo – if it errors because the index is there… so what – it’s supposed to be there … …
I prefer the MaxDemo file as it has a better set of indexes than the Maximo one… or at least it used to and I’ve not had time to double check the new releases…
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lonnie Stone
Sent: Wednesday, February 20, 2013 6:59 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Nice idea but it did not work. Since my last db and current db values are up to date it did not do anything.
________________________________
From: Vasu Kiran Chilukuri vasukiranch@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, February 20, 2013 7:32 PM
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
One of dirty way.... try run updated.bat
On Feb 20, 2013 6:30 PM, "Lonnie Stone" lonnie_s_stone@yahoo.com> wrote:
> **
>
>
> I have a client that is missing key OOTB indexes in SQL Server. It also
> seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
>
I really hate this arm chair quarterbacking . . . are you sure there was no
reason for those indexes to have been removed? performance? taylorings?
customizations?
Has something changed that now requires one or more of them to exist
again? What does the dba say?
Creating and inserting indexes is not difficult to do, determining exactly
what indexes should and need to be in place is the challenge . . .
Make sure your dba is onboard before you make any significant changes.
John
On Wed, Feb 20, 2013 at 9:48 PM, Lonnie Stone <lonnie_s_stone@yahoo.com>wrote:
> **
>
>
> This looks great. I will test it out in tomorrow and report back to the
> group.
>
>
> Thank you,
>
> Lonnie Stone
> lonnie_s_stone@yahoo.com
> IBM Certified Solution Advisor:
> Maximo Enterprise Asset Management Solutions V2
> Tivoli Service Delivery & Process Automation Solutions V2
> IBM Certified Solution Designer:
> Maximo Asset ManagementV7.1
> IBM Certified Deployment Professional:
> Maximo Asset Management V6
> Maximo Asset Management V7.1
> Tivoli Asset Management for IT V7.2
> IBM Certified System Administrator:
> WebSphere Application Server Network Deployment V6.0
> WebSphere Application Server Network Deployment V7.0
> IBM Certified Application Developer:
> TRIRIGA Application Platform V3.2
>
> ________________________________
> From: Will Hampton will.hampton@exxtremeconsulting.com>
> To: "MAXIMO@yahoogroups.com" MAXIMO@yahoogroups.com>
> Sent: Wednesday, February 20, 2013 8:14 PM
> Subject: RE: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
>
>
>
>
> Hi Lonnie,
>
> Open maxdemo.sqs from the maximo\tools\maximo\ directory
>
> Pull out the commands for creating indexes (create index� create unique
> index � etc) and the section for inserting the indexes back into maxsyskeys
> and maxsysindexes �
>
> Run that; have SQL Server update statistics; you should be good to go �
> slap the person that deleted the indexes (HARD)�.
>
> I�ve done this dozens of times in the past on other versions of Maximo �
> if it errors because the index is there� so what � it�s supposed to be
> there � �
>
> I prefer the MaxDemo file as it has a better set of indexes than the
> Maximo one� or at least it used to and I�ve not had time to double check
> the new releases�
>
> R/
> Will
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Lonnie Stone
> Sent: Wednesday, February 20, 2013 6:59 PM
> To: MAXIMO@yahoogroups.com
> Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
>
> Nice idea but it did not work. Since my last db and current db values are
> up to date it did not do anything.
>
> ________________________________
> From: Vasu Kiran Chilukuri vasukiranch@gmail.com>
> To: MAXIMO@yahoogroups.com
> Sent: Wednesday, February 20, 2013 7:32 PM
> Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
>
> One of dirty way.... try run updated.bat
> On Feb 20, 2013 6:30 PM, "Lonnie Stone" lonnie_s_stone@yahoo.com> wrote:
>
> > **
> >
> >
> > I have a client that is missing key OOTB indexes in SQL Server. It also
> > seems that they are missing from maxsysindexes and maxsyskeys tables.
> >
> > Does anyone have any creative ways to fix this?
> > I have tried integritychecker without success.
> >
> > Thank you in advance,
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
--
John C C Sullivan
Project Controls Professional Services, Inc.
jccspcps@gmail.com
775 315-0119
IF YOU DON'T STAND BEHIND OUR TROOPS FEEL
FREE TO STAND IN FRONT OF THEM.
IN GOD WE TRUST!
Its not that big a job to do them manually through the front end, at BP we used to script them then run configdb
But if you want the scripts that create the database then
\\yursever\e$\apps\ibm\SMP\maximo\tools\maximo\en\maximo.sqs<file:///\\yursever\e$\apps\ibm\SMP\maximo\tools\maximo\en\maximo.sqs>
You should be able to find the full list of indexes and pick out the ones you are missing
Just look for
"insert into maxsysindexes"
"insert into maxsyskeys"
"create unique index"
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lonnie Stone
Sent: 21 February 2013 00:30
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
I have a client that is missing key OOTB indexes in SQL Server. It also seems that they are missing from maxsysindexes and maxsyskeys tables.
Does anyone have any creative ways to fix this?
I have tried integritychecker without success.
Thank you in advance,
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Sorry I see others got there before me I was answering my mail from the bottom up :)
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Ian Wright
Sent: 21 February 2013 08:34
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Its not that big a job to do them manually through the front end, at BP we used to script them then run configdb
But if you want the scripts that create the database then
\\yursever\e$\apps\ibm\SMP\maximo\tools\maximo\en\maximo.sqsfile:///<file:///\\>\\yursever\e$\apps\ibm\SMP\maximo\tools\maximo\en\maximo.sqs>
You should be able to find the full list of indexes and pick out the ones you are missing
Just look for
"insert into maxsysindexes"
"insert into maxsyskeys"
"create unique index"
Rgds Ian
From: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>] On Behalf Of Lonnie Stone
Sent: 21 February 2013 00:30
To: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
Subject: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
I have a client that is missing key OOTB indexes in SQL Server. It also seems that they are missing from maxsysindexes and maxsyskeys tables.
Does anyone have any creative ways to fix this?
I have tried integritychecker without success.
Thank you in advance,
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Pulling the inserts and creates from the maxdemo.sqs worked.
I also used the following to rebuild the indexes and then update the stats.
select 'dbcc dbreindex ('tablename')
go' from maxtable
select 'update statistics 'tablename'
go' from maxtable
Further, now that I had the maxsyskeys and maxsysindexes tables populated I was able to run the integrity checker to fill in any holes.
Thank you all for the help,
Lonnie Stone
lonnie_s_stone@yahoo.com
IBM Certified Solution Advisor:
Maximo Enterprise Asset Management Solutions V2
Tivoli Service Delivery & Process Automation Solutions V2
IBM Certified Solution Designer:
Maximo Asset ManagementV7.1
IBM Certified Deployment Professional:
Maximo Asset Management V6
Maximo Asset Management V7.1
Tivoli Asset Management for IT V7.2
IBM Certified System Administrator:
WebSphere Application Server Network Deployment V6.0
WebSphere Application Server Network Deployment V7.0
IBM Certified Application Developer:
TRIRIGA Application Platform V3.2
________________________________
From: Lonnie Stone <lonnie_s_stone@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Wednesday, February 20, 2013 9:48 PM
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
This looks great. I will test it out in tomorrow and report back to the group.
Thank you,
Lonnie Stone
lonnie_s_stone@yahoo.com
IBM Certified Solution Advisor:
Maximo Enterprise Asset Management Solutions V2
Tivoli Service Delivery & Process Automation Solutions V2
IBM Certified Solution Designer:
Maximo Asset ManagementV7.1
IBM Certified Deployment Professional:
Maximo Asset Management V6
Maximo Asset Management V7.1
Tivoli Asset Management for IT V7.2
IBM Certified System Administrator:
WebSphere Application Server Network Deployment V6.0
WebSphere Application Server Network Deployment V7.0
IBM Certified Application Developer:
TRIRIGA Application Platform V3.2
________________________________
From: Will Hampton will.hampton@exxtremeconsulting.com>
To: "MAXIMO@yahoogroups.com" MAXIMO@yahoogroups.com>
Sent: Wednesday, February 20, 2013 8:14 PM
Subject: RE: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Hi Lonnie,
Open maxdemo.sqs from the maximo\tools\maximo\ directory
Pull out the commands for creating indexes (create index… create unique index … etc) and the section for inserting the indexes back into maxsyskeys and maxsysindexes …
Run that; have SQL Server update statistics; you should be good to go … slap the person that deleted the indexes (HARD)….
I’ve done this dozens of times in the past on other versions of Maximo – if it errors because the index is there… so what – it’s supposed to be there … …
I prefer the MaxDemo file as it has a better set of indexes than the Maximo one… or at least it used to and I’ve not had time to double check the new releases…
R/
Will
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Lonnie Stone
Sent: Wednesday, February 20, 2013 6:59 PM
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
Nice idea but it did not work. Since my last db and current db values are up to date it did not do anything.
________________________________
From: Vasu Kiran Chilukuri vasukiranch@gmail.com>
To: MAXIMO@yahoogroups.com
Sent: Wednesday, February 20, 2013 7:32 PM
Subject: Re: [MAXIMO List] Maximo 7.1 SQL Server Indexes Missing
One of dirty way.... try run updated.bat
On Feb 20, 2013 6:30 PM, "Lonnie Stone" lonnie_s_stone@yahoo.com> wrote:
> **
>
>
> I have a client that is missing key OOTB indexes in SQL Server. It also
> seems that they are missing from maxsysindexes and maxsyskeys tables.
>
> Does anyone have any creative ways to fix this?
> I have tried integritychecker without success.
>
> Thank you in advance,
>
>
>
>
>