Maximo Wire - The IBM Maximo Help & Discussion Forum
May 22, 2012, 09:45:42 pm *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Preferred database for Maximo  (Read 1492 times)
0 Members and 2 Guests are viewing this topic.
RL
Newbie
*

Karma: 0
Posts: 2


View Profile
« on: February 13, 2009, 03:54:55 pm »
We are in the process of purchasing Maximo 7 and need to decide on a database platform.  We have in house expertise in both Oracle and SQL Server.  Do any of you have a strong preference either way in relation to which database best supports the Maximo application?

Logged
amdisuk
Administrator
Full Member
*****

Karma: -1
Posts: 199


allandonaldson@hotmail.com
View Profile WWW
« Reply #1 on: February 20, 2009, 08:07:38 am »
Both databases are tried and tested so I guess its down to cost. You might find that for smaller systems that the SQL server is the better option with lower skillset required and lower maintenance.

Al
Logged
Big Al
JohannesT
Newbie
*

Karma: 0
Posts: 4


View Profile
« Reply #2 on: April 10, 2009, 03:41:38 am »
I would have to say go with Oracle. There seems to be more limitations from SQL Server. These are based on known issues from Microsoft rather than issues with Maximo. For example:

1. Fulltext Search in MS SQL Server - Maximo makes use of the fulltext search feature in MS SQL Server. MS article 910067 report database restoration error when DB is with FullText.

2. Clustered index - it is noted that the database design does not make use of Clustered Index feature (by default) in MS SQL Server. Not using 
clustered index will result in the documented bug to happen. please refer to MS article http://support.microsoft.com/?id=913399 regarding this bug.
Logged
Smartway
Newbie
*

Karma: 0
Posts: 4


View Profile
« Reply #3 on: August 06, 2009, 04:34:51 pm »
I think db2 is the best choice with Maximo. Simply for the reasons,
1 - bundled with Maximo - No additional licenses required
2 - IBM's product - Better to have the same vendor supported products
Logged
Pages: [1]   Go Up
  Print  
Maximo Wire - The IBM Maximo Help & Discussion Forum > Everything Else > General Discussion > Topic: Preferred database for Maximo
 « previous next »
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!