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.
Dear All ,
I have two independent maximo servers ,every one has its own database and application server.
these two server serve the same organization but in two different geographic locations so I had to make a merge synchronization on the database level (SQL Server 2008) to let users at both locations keep eyes on the data , after creating the sync i have faced a problem that whenever - for example - two persons perform two inventory transactions at two different site then when sync take place it gives me a conflict as invtransid cannot be duplicated.
my question is what is the risk of being disable all indexes for all primary key in all tables and depend on the index of (Site + primary key) only??
and if there is another way can be handle by the application server to perform the sync scenario , what would be that way?
Maximo 7.1.1.9
Websphere 6
SQL Server 2008
Best Regards
Amir Samir
Beshay Steel Egypt
Hi,
We have eight sites all in different geographic locations from the East coast to the West coast of U.S. All eight sites use the same application servers and all of the application servers use one database. All of these are located on the East coast.
I think you should take a look at why you do not have a similar set up. Do you not have a WAN set up between the two sites?
I would not do what you suggested. You could find that the application programs may check for the uniqueness of the fields and that causes issues.
Maybe you could do something like this?
You could set the value for the ID key at one site to the top range of values. In the maxsequence table the maxreserved field is where the application will look for the next values to reserve. For site A leave these where they are and then for site B set them to 1,000,000,000.
Site A will be incrementing up to that value while site B will increment up to the maximum. You would then have to monitor the maxreserved values since eventually the site A value will increment to the site B value and the site B value will reset to 0. Depending on the transactions that could be a few years or a hundred years.
At that point you would have to archive the old data and reset both site maxreserved values.
Dave Bone
--- In MAXIMO@yahoogroups.com, amir samir <amir_s_anwar@...> wrote:
>
> Dear All ,
> I have two independent maximo servers ,every one has its own database and application server.
> these two server serve the same organization but in two different geographic locations so I had to make a merge synchronization on the database level (SQL Server 2008) to let users at both locations keep eyes on the data , after creating the sync i have faced a problem that whenever - for example - two persons perform two inventory transactions at two different site then when sync take place it gives me a conflict as invtransid cannot be duplicated.
> my question is what is the risk of being disable all indexes for all primary key in all tables and depend on the index of (Site + primary key) only??
> and if there is another way can be handle by the application server to perform the sync scenario , what would be that way?
>
> Maximo 7.1.1.9
> Websphere 6
> SQL Server 2008
>
> Best Regards
> Amir Samir
> Beshay Steel Egypt
>
>
>
I would take a look at SRO Solutions data replicator solution, I have no
affiliation with SRO but have looked at their product and I think it does
what you are looking for in a much more robust manner. This assumes your
really need replication although I'd say you should look at running a
single Maximo for all your users and have multiple ORGS / SITES to map to
the geography.
Chris.
On Mon, Jun 4, 2012 at 11:46 AM, in2data <in2data@yahoo.com> wrote:
> **
>
>
> Hi,
>
> We have eight sites all in different geographic locations from the East
> coast to the West coast of U.S. All eight sites use the same application
> servers and all of the application servers use one database. All of these
> are located on the East coast.
>
> I think you should take a look at why you do not have a similar set up. Do
> you not have a WAN set up between the two sites?
>
> I would not do what you suggested. You could find that the application
> programs may check for the uniqueness of the fields and that causes issues.
>
> Maybe you could do something like this?
>
> You could set the value for the ID key at one site to the top range of
> values. In the maxsequence table the maxreserved field is where the
> application will look for the next values to reserve. For site A leave
> these where they are and then for site B set them to 1,000,000,000.
>
> Site A will be incrementing up to that value while site B will increment
> up to the maximum. You would then have to monitor the maxreserved values
> since eventually the site A value will increment to the site B value and
> the site B value will reset to 0. Depending on the transactions that could
> be a few years or a hundred years.
>
> At that point you would have to archive the old data and reset both site
> maxreserved values.
>
> Dave Bone
>
> --- In MAXIMO@yahoogroups.com, amir samir <amir_s_anwar@...> wrote:
> >
> > Dear All ,
> > I have two independent maximo servers ,every one has its own database
> and application server.
> > these two server serve the same organization but in two different
> geographic locations so I had to make a merge synchronization on the
> database level (SQL Server 2008) to let users at both locations keep eyes
> on the data , after creating the sync i have faced a problem that whenever
> - for example - two persons perform two inventory transactions at two
> different site then when sync take place it gives me a conflict as
> invtransid cannot be duplicated.
> > my question is what is the risk of being disable all indexes for all
> primary key in all tables and depend on the index of (Site + primary key)
> only??
> > and if there is another way can be handle by the application server to
> perform the sync scenario , what would be that way?
> >
> > Maximo 7.1.1.9
> > Websphere 6
> > SQL Server 2008
> >
> > Best Regards
> > Amir Samir
> > Beshay Steel Egypt
> >
> >
> >
>
>
>
Dear Dave,
Previously i have the scenario of one database and one application server but this won't work for me as my VPN connection is too slow to handle requests from all locations so i have to move to the other scenario where i have multiple independent installation and let the database manage the replications.
the problem with the setting the maxreserved field to different values is when replication takes place the values will be identical in the database unless i remove this table from the replication and that would be take in consideration as a good solution.
another opinion is to make the replication using the MIF and interface table but I'm not sure if this will help me or not as i'm not that much into MIF- if u can help me in this case that would be greate.
So what do you think?
Mr. Chris
For SRO , It might be the solution of my problem but we are now in a point that we can't purchase a new software.
Mr. Mohammed
I need to merge the data from two maximo databases that is simply what i need to do.
Best Regards
Amir Samir
Beshay Steel Egypt
From: in2data <in2data@yahoo.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, June 4, 2012 5:46 PM
Subject: [MAXIMO List] Re: Merge Sync vs indexes
Hi,
We have eight sites all in different geographic locations from the East coast to the West coast of U.S. All eight sites use the same application servers and all of the application servers use one database. All of these are located on the East coast.
I think you should take a look at why you do not have a similar set up. Do you not have a WAN set up between the two sites?
I would not do what you suggested. You could find that the application programs may check for the uniqueness of the fields and that causes issues.
Maybe you could do something like this?
You could set the value for the ID key at one site to the top range of values. In the maxsequence table the maxreserved field is where the application will look for the next values to reserve. For site A leave these where they are and then for site B set them to 1,000,000,000.
Site A will be incrementing up to that value while site B will increment up to the maximum. You would then have to monitor the maxreserved values since eventually the site A value will increment to the site B value and the site B value will reset to 0. Depending on the transactions that could be a few years or a hundred years.
At that point you would have to archive the old data and reset both site maxreserved values.
Dave Bone
--- In MAXIMO@yahoogroups.com, amir samir <amir_s_anwar@...> wrote:
>
> Dear All ,
> I have two independent maximo servers ,every one has its own database and application server.
> these two server serve the same organization but in two different geographic locations so I had to make a merge synchronization on the database level (SQL Server 2008) to let users at both locations keep eyes on the data , after creating the sync i have faced a problem that whenever - for example - two persons perform two inventory transactions at two different site then when sync take place it gives me a conflict as invtransid cannot be duplicated.
> my question is what is the risk of being disable all indexes for all primary key in all tables and depend on the index of (Site + primary key) only??
> and if there is another way can be handle by the application server to perform the sync scenario , what would be that way?
>
> Maximo 7.1.1.9
> Websphere 6
> SQL Server 2008
>
> Best Regards
> Amir Samir
> Beshay Steel Egypt
>
>
>