View in ref guide.
Edit this option Publish this option Clear draft content
Published Option
Default Value: 100000 (SQL statements)
Valid Values: Integers greater than or equal to 100,000 and less than 2147483647 (231).
Changes Take Effect: After restart
Specifies the maximum number of SQL statements that Stat Server is allowed to maintain in memory. As soon as Stat Server's connection to the RDBMS is broken, Stat Server starts storing SQL statements in memory. These statements will be issued against the Stat Server database once the connection is restored. If the number of SQL statements in memory exceeds the value that is specified by this option, data loss might result.
To avoid data loss, Stat Server must remain connected to DB Server or to database for the entire period of the records submission to the RDBMS. If you use DB Server for connection to RDBMS, your addp timeout for connection from Stat Server to DB Server should be set as large as possible to prevent disconnection by addp. Refer to the Management Framework Deployment Guide for information about setting addp.
If the number of SQL statements in memory ever exceeds this option's value, data loss of the entire memory pool will result and the accumulation of SQL statements will begin anew.
Please be aware that setting this option's value too high might cause your system to run out of memory. Configure this option in conformance with the amount of RAM installed on the machine where Stat Server operates.
If you specify any value that is less than the default (100000), Stat Server resets it to 100000.
Draft Option
No draft option