IBM® Tivoli® Maximo® database-related properties
| Property | Value | Comment |
|---|---|---|
| mxe.db.schemaowner | dbo | Database schema owner. "dbo" is an example; enter the appropriate schema for your database. |
| mxe.db.driver | This value varies
depending on the database, for example: DB2® com.ibm.db2.jcc.DB2Driver Oracle: Oracle JDBC Thin driver oracle.jdbc.driver.OracleDriver SQL Server: i-net Opta driver com.inet.tds.TdsDriver |
JDBC driver specification |
| mxe.db.url | This value varies
depending on the database, for example: DB2 jdbc:db2://<host_name>:<host_port>/<database_name> Oracle: Oracle JDBC Thin driver jdbc:oracle:thin:@<host_name>:<host_port>: <host_sid> SQL Server 7.0-: i-net Opta driver (or higher) jdbc:inetdae7:<host_name>:<host_port>?database= <database_name> |
JDBC database URL |
| mxe.db.user | Database login name. | |
| mxe.db.systemdateformat | This value varies
depending on the database; for example, White House raises doubts over SOPA current timestamp SQL Server getdate() Oracle sysdate |
Specifies the database function used to retrieve the current time stamp. |