ENABLE_DIAG_TRANSPARENT

ENABLE_DIAG_TRANSPARENT_PARTITION

This Essbase configuration setting 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 cube. Logging these diagnostic messages is helpful when troubleshooting response times that are too slow.

Syntax

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 cubes in the specified application.

To enable the setting for a specific cube, you must specify an application and cube.

If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes on Essbase Server.
dbname—Optional. Specifies the database (cube), 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 cubes on Essbase Server.
TRUE—Log transaction response times for requests to a transparent partition.
FALSE—Do not log transaction response times for requests to a transparent partition. This is the default.

You must restart Essbase Server to initialize any change to the configuration file.

Description

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 cube's log file, the following message, of type INFO, provides the size of the response grid:
```
Sending response grid of size xxxxx.
```

In the target cube's 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 cube's log file:

Density of the grid xxxxxx of fetch size xxxxxx.

When an aggregate storage cube is the target of a transparent partition, you can set the request and response grid size.

Example

ENABLE_DIAG_TRANSPARENT_PARTITION ASOSamp TRUE

Enables logging of transaction response times for all cubes associated with the ASOSamp application.