Dynamic reconfiguration refers to the ability to re-configure Adaptive Server Enterprise without having to reboot the server in order for the configuration changes to become effective. Prior to version 12.5, there are 5 memory pools used to contain various CIS resources:
SRVDES - pool size is independent of other configuration values;
OMNI_DES - pool size dependent upon value of "open objects" - one OMNI_DES is allocated per ’open object’ (DES);
OMNI_PSS - pool size is dependent upon value of "user connections" - one OMNI_PSS is allocated per user connection (PSS).
OMNI_CURSOR - pool size is dependent upon value of "user connections" - one OMNI_CURSOR is allocated per SDES; 16 SDES’s are allocated per user connection.
RDES - pool size is dependent upon value of "user connections" - there are four RDES’s allocated for each user connection.
With versions before 12.5, if insufficient resources were configured to accommodate actual server usage, the configuration had to be changed and rebooted. With the changes to version 12.5, resource pools will be dynamic, allowing expansion as needed.
The CIS dbcc command dbcc cis("rusage") has been replaced by the Adaptive Server Enterprise command: dbcc mempools.