Database properties

You can use system properties to help manage the database.

Table 1. Database properties
Property Description Default value
mxe.db.autocommit

Represents the autocommit mode used for the Write connections.

This property can be either true or false. The default is false, and you cannot change the default value.

0
mxe.db.closelongrunconn

A Boolean flag that indicates that the long running connection needs to be closed.

false
mxe.db.DB2jdbcCollection

Represents the DB2® Java™ database connectivity (JDBC) collection. The NULLIDR1 value activates query optimization REOPT ONCE.

 
mxe.db.DB2LD
TextCaseInsensitiveSearch

When set to 1, the DB2 search on Long Description field is not case-sensitive. Might cause performance delay.

0
mxe.db.DB2sslConnection

Represents the secure socket layer (SSL) connection.

False
mxe.db.
DB2sslTrustStoreLocation

Represents the DB2 SSL truststore location.

 
mxe.db.
DB2sslTrustStorePassword

Represents the DB2 SSL truststore password.

 
mxe.db.detectlongrunconninterval

Checks the long running connection. The interval is reflected in minutes. A value of (0, 30] is treated as 30.

0
mxe.db.disableservercursor

Used to disable the server cursor.

1
mxe.db.driver

Represents the database driver.

This property must be defined in maximo.properties file.

com.microsoft.sqlserver.
jdbc.SQLServerDriver
mxe.db.fetchResultLogLimit

Determines the typical or largest fetch count for every object.

A stack trace is created in the log file of the application server logs every time a multiple of the fetch log limit is reached. For example, if you set the property to 1000, the stack trace is logged at the 1000th record, the 2000th record, and so on.

5000
mxe.db.fetchResultStopLimit

Represents the fetch stop limit used when checking that the fetch stop limit is enabled. The limit applies to all objects for which a specific fetch stop limit property is not specified.

A value of -1 means that there is no limit.

5000
mxe.db.fetchsize

Represents the size of the database fetch.

40
mxe.db.fetchsizeuse

Represents the flag that indicates whether to use the fetch size.

1
mxe.db.fetchStopExclusion

Provides a comma-separated list of object names. If an object name is in the list, the fetch stop limit check is disabled for the object. If an object name is in the list and the same object is specified in an
mxe.db.fetchResultStopLimit.OBJECTNAME
property, the exclusion overrides the other property.

The values are represented in a comma-separated object name list in the MAXOBJECT table.

 
mxe.db.fetchStopLimitEnabled

Enables or disables the checking of the fetch stop limit.

Use 0 to disable and use 1 to enable.

1
mxe.db.format.date

Determines the database date function.

A value of none tells the system to pass through the date value.

You cannot change this value.

 
mxe.db.format.nullvalue

Represents the database-specific format of the null value function.

  • For IBM® DB2, the value is
    COALESCE, and you
    cannot change the default value.
  • For Oracle, the value is
    NVL, and you
    cannot change the default value.
  • For SQL Server, the value
    must be set to
    ISNULL.
mxe.db.format.time

Represents the database time function.

A value of none indicates that the time value is passed through.

You cannot change the default value.

 
mxe.db.format.timestamp

Represents the database time stamp function.

A value of none indicates that the time stamp value is passed through.

You cannot change the default value.

 
mxe.db.format.upper

Defines the database uppercase function for the system.

You cannot change this value.

Upper
mxe.db.initialConnections

Represents the number of database connections that are created when the application server is started.

8
mxe.db.logCorrelationid

Disables database cursor sharing. You can add the correlation ID as an SQL comment. Use the property only in debug mode.

0
mxe.db.logSQLPlan

Represents the log execution plan for full table scans.

0
mxe.db.longruntimelimit

Indicates the time limit, in minutes, to close the long running connection.

180
mxe.db.logSQLTimeLimit

Represents the log that contains the SQL operations that exceed the time limit in milliseconds.

1000
mxe.db.lookupMaxRow

Represents the maximum number of records queried from database for lookups.

1000
mxe.db.lookupMultiplier

Used in conjunction with the mxe.db.lookupMaxRow property to show items.

5
mxe.db.maxFreeConnections

Represents the maximum number of free database connections that are available in the connection pool.

8
mxe.db.minFreeConnections

Represents the minimum number of free database connections that are available in the connection pool.

5
mxe.db.
MLQBELooseSearchWOJoin

Used for Oracle only. Do not use outer join for search on a multiple language enabled field.

0
mxe.db.newConnectionCount

Represents the number of new connections to be created when the minimum free connections are available in the connection pool.

3
mxe.db.optionnum

Represents the size of the option.

1000
mxe.db.optionuse

Represents the flag that indicates whether to use the option.

1
mxe.db.password

Represents the native database password for the Maximo® connection.

This property must be defined in maximo.properties file.

XXXXXX
mxe.db.proxyauthentication.
mode

Represents the Oracle proxy authentication mode.

This mode is only valid when you use Oracle Proxy DataBase Manager.

The values for this property are:

  • 1 = username
  • 2 = username + password
  • 3 = distinguished name (DN)
  • 4 = certificate
mxe.db.QueryTimeout

Represents the amount of time in seconds before the SQL query times out and is stopped.

300
mxe.db.refcount

Represents the reference count for the connection log.

100
mxe.db.resultsettype

The constant indicates the type for a result set object with the following characteristics:

  • The cursor can move only forward. For example:
    TYPE_FORWARD_ONLY
    public static final in TYPE_FORWARD_
    ONLY
  • The result set type that is scrollable, but not sensitive to changes that other users make. For example:
    TYPE_SCROLL_INSENSITIVE
    public static final int TYPE_SCROLL_
    INSENSITIVE
  • The result set type that is scrollable and sensitive to changes that other users make. For example:
    TYPE_SCROLL_SENSITIVE
    public static final int TYPE_SCROLL_
    SENSITIVE
TYPE_FAST_FORWARD
mxe.db.retrydbconnection

Reconnects to the database when you start the application server.

0
mxe.db.rowcount

Represents the SQL Server row count value.

0
mxe.db.schemaowner

Indicates the database schema owner.

This property must be defined in maximo.properties file.

DBO
mxe.db.sqlinjection

Indicates whether the SQL injection check is enabled.

1
mxe.db.sqlserverPrefetchRows

Represents the setting to reduce lock contention and is only for SQL Server.

The optimal setting is 200 rows. Setting a value larger than 500 can degrade performance.

0
mxe.db.sqlTableScanExclude

Indicates tables that should not have an execution plan logged.

 
mxe.db.systemdateformat

Represents the system date format.

  • For IBM DB2, the value is
    current timestamp
  • For Oracle, the value is
    sysdate, and you
    cannot change the default value.
  • For SQL Server, the value is
    getdate.
mxe.db.transaction_isolation

The installation sets the value to: TRANSACTION_READ_COMMITTED.

You cannot change this value.

TRANSACTION_READ_COMMITTED
mxe.db.
updateWithoutRowstamp

Indicates that you can allow updates on tables that do not contain a rowstamp column.

0
mxe.db.url

Represents the database URL.

This property must be defined in maximo.properties file.

jdbc:sqlserver:
//qadb02.swg.usma.ibm.com:1433;
databaseName=SQL2K8R2B;
integratedSecurity=false;
mxe.db.user

Represents the native database user for a Maximo connection.

This property must be defined in maximo.properties file.

maximo
mxe.db.UseSiteListInQuery

Represents the use literal list for site and organization restrictions.

0
mxe.dbmanager

References the Java class of the Maximo database manager.

This property also requires that you specify the jdbc database connection string as the Oracle call interface (OCI) connection string, and that you make the OCI driver accessible to the system web component Java virtual machine (JVM).

The default value is
psdi.server.DBManager.

If you have an Oracle database
that requires proxy authentication,
set this property to
psdi.server.OracleProxyDBManager.

mxe.dbwatchdog.adminemail

Represents the administrator email address used to send the database connection watchdog mail.

 
mxe.dbwatchdog.logInterval

Represents the interval time in minutes between when each database connection watchdog log is created. The database connection watchdog log is written to the database connection logger.

10
mxe.dbwatchdog.mailinterval

Represents the interval in minutes before a watchdog email is sent to the administrator.

60


Feedback