Memory Management

Request Queue Size

The report server places all requests in the queue before executing them. This property is to set maximum number of requests that can be queued. After the queue is filled, server ignores all client requests, until number of requests in queue is reduced to a number less than the property value.

Specify an integer value that is greater than zero.

The new value set for this property will come into effect after the server restart.

Default: 1000

Example: QUEUE_SIZE=1000

Data Source Fetch Size (rows per fetch)

This is the number of records fetched from the data source simultaneously (in one read).  Specify a positive integer.

Default: 50

Example: DATA_SOURCE_FETCH_SIZE=50

Sort Area Size Per Exec (rows)

This property sets the number of records that can reside in memory for all report threads.  It can be given a value greater than 0.

Default: 600

Example: SORT_AREA_SIZE_PER_EXEC=600

Scheduler Job Dispatch Queue Size

This property sets the maximum number of jobs that can be spawned at a time. A valid value is zero or any positive integer.

The new value set for this property will come into effect after the server restart.

Default: 50

Example: SCHD_JOB_DISPATCH_QUEUE_SIZE=50

Chunks in Memory

A number of report page chunks that can reside in memory. The report server will stream each chunk to the viewer as soon as it is rendered. Specify a value that is more than 2.

Default: 4

Example: CHUNKS_IN_MEMORY=4

Output Buffer Size (nKB or MB)

The maximum size of MEMORY to be used to store report output chunks. Specify in terms of MB or KB.

Default: 2.5 MB

Example: OUTPUT_BUFFER_SIZE=2.5MB

Clone User System Params

This property is defined as turning on/off the cloning of User and System Parameters across the detail sections. The cloning is required only if this installation is upgraded from version 3—Configure Disable for newer installations for memory efficiency.

Default: Enable

Example: CLONE_USER_SYSTEM_PARAMS=Enable

Repeat Report Exec Request

This property defines what to do if the server receives request of a report that is being presently served.  If the property is set to Allow All then it will allow all the report execution requests.  If it is Deny New, then server will not accept the newly received request.  If it is Prompt Cancel portal will prompt the user to cancel new request or request that is presently being served.

Default: prompt_cancel

Example: REPEAT_REPORT_EXEC_REQUEST=prompt_cancel

IRL Cache Size

This is the maximum memory that can be used for the IRL (report layout) cache.  It can be specified in terms of the number of IRLs or memory size (KB, MB).

Default: 10

Example: IRL_CACHE_SIZE=10

Sort Threads Per Exec

This is the number of threads to be created (per report request) at runtime to sort records. This property is hot deployed.

Default: 4

Example: SORT_THREADS_PER_EXEC=4

Utility Thread Pool Initial Size

Kyvos Reporting Report Server uses utility threads to carry out internal processes. This property defines the initial size of utility threads.

Default: 5

Example: UTILITY_THREAD_POOL_INITIAL_SIZE=5

Utility Thread Pool Purge Time (seconds)

This property defines the waiting time for an extended thread (created on demand post-initialization) from the pool before it is purged. Specify a value in seconds.

Default: 50

Example: UTILITY_THREAD_POOL_PURGE_TIME=50

Field Lookup Max Values

The count of Maximum Lookup values fetched from the database for a Query Object column is configurable. This will reduce the loading time of a query object in Ad hoc wizard/Run and of lookup Values.

Default Value=2000

Example: FIELD_LOOKUP_MAX_VALUES=2000