You can use system properties to help manage the database.
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 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. |
|
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:
|
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:
|
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. |
|
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 If
you have an Oracle database |
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 |