Specifies whether to log transaction response times for requests sent from a data source to a transparent partition target. The target can be either a block storage or aggregate storage database. Logging these diagnostic messages is helpful when troubleshooting response times that are too slow.
ENABLE_DIAG_TRANSPARENT_PARTITION [appname [dbname]] TRUE | FALSE
appname—Optional. Specifies the application for which logging diagnostic messages is to be enabled.
If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application.
To enable the setting for a specific database, you must specify an application and database.
If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on Essbase Server.
dbname—Optional. Specifies the database, in the application specified by appname, for which logging diagnostic messages is to be enabled.
If you specify a value for dbname but do not specify a value for appname, your specification is ignored, and logging diagnostic messages is enabled for all applications and databases on Essbase Server.
TRUE | FALSE—Specifies whether to enable or disable logging transaction response times for requests to a transparent partition.
You must restart Essbase Server to initialize any change to the configuration file.
When logging is enabled, Essbase writes messages to the source and target database log files during querying.
For every partial response sent to the target from the source, Essbase logs these messages:
In the source database log file, the following message, of type INFO, provides the size of the response grid:
Sending response grid of size xxxxx.
In the target database log file, the following message provides the size of the request grid issued to the source and an estimated response time:
Waiting for data from source system:application:database grid size sizeOfRequestGrid. Approximately one second is needed to fetch a grid of size one million cells with non-missing cell density of 7% from the source.
For every partial grid received from the source, Essbase logs the following message about the density of the grid to the target database log file:
Density of the grid xxxxxx of fetch size xxxxxx.
When an aggregate storage database is the target of a transparent partition, you can set the request and response grid size.
ENABLE_DIAG_TRANSPARENT_PARTITION ASOSamp TRUE
Enables logging of transaction response times for all databases associated with the ASOSamp application.
MAX_REQUEST_GRID_SIZE configuration setting
MAX_RESPONSE_GRID_SIZE configuration setting