Utilities for logging and testing

To help you manage system performance, there are utilities that you can use for testing and debugging purposes. When you are satisfied with your deployment, you can disable these logging utilities.

Utilities that track system performance

By default, the mbocount logging utility, the logSQLTimeLimit logging utility, and the fetchResultLogLimit logging utility are enabled in the properties file. By using these utilities, you can track the following possible system performance issues while you configure an initial system deployment:

To disable the logging utilities, change the debugging properties that are described in the table.

Table 1. Debugging properties
Property Description Default value
mail.debug

Used to troubleshoot email connectivity, configuration, and formatting problems. The property is a JavaMail API debug property.

To enable, change the value to true.

false
mxe.mbocount

Displays the number of business objects that the server created.

To disable, change the value of the property to 0.

1
mxe.db.logSQLTimeLimit

Represents the SQL statements that take longer than the specified time limit are logged. The time is measured in milliseconds.

To disable, change the value of the property to 0.

1000
mxe.db.fetchResultLogLimit

When this property is enabled, a stack trace is printed in the log for every business object set that fetches beyond the set limit of rows. The stack trace log is also repeated for every multiple of such fetches.

To disable, change the value of the property to 0.

1000 rows
mxe.db.logSQLPlan (Oracle only)

Setting this property to true logs the execution plan for all SQL statements that contain a full table scan.

If you define mxe.db.sqlTableScanExclude, all tables, except for the ones you intentionally exclude, are logged.

If you do not define mxe.db.sqlTableScanExclude, only the SQL statements that exceed the time limit that is set in mxe.dblogSQLTimeLimit are logged.

0
mxe.db.sqlTableScanExclude= ACTION,MAXROLE,SCCONFIG,MAXUSER (Oracle only)

You can define the table names that you want to exclude from the log. The table names must be uppercase.

If you define mxe.db.sqlTableScanExclude, all tables, except for the ones that you list, are logged.

If you do not define mxe.db.sqlTableScanExclude and you set mxe.db.logSQLPlan=true, only the SQL statements that exceed the time limit that is set in mxe.dblogSQLTimeLimit are logged.

0
mxe.logging.CorrelationEnabled

Represents the correlation ID that is logged if a percentage of the queue is specified in the logger layout.

1
mxe.logging.disableLoggingPropFile

Disables the logging.properties file for logging.

0
mxe.logging.rootfolder

Represents the default root folder to where Maximo generated log files are written.

 


Feedback