The following tables provide information about features that were added to IBM Informix Dynamic Server, Version 9.4.
Version 9.4 included several features to help you monitor and improve the performance of your database.
| New Features | Reference |
|---|---|
| CDR_MAX_DYNAMIC_LOGS | For details, refer to your IBM Informix Dynamic Server Enterprise Replication Guide. |
| onmode -Y | This new onmode option allows you to dynamically change the SQEXPLAIN setting. For more information, see Dynamically Setting of SET EXPLAIN. |
| oncheck -pP | This oncheck option has been enhanced to allow users to optionally specify the number of pages to be dumped. For more information, see Display the Contents of a Logical Page with -pp and -pP. |
| > 2 GB chunks, offsets with onmode -BC 1 and onmode -BC 2 | This option allows a significantly large increase in the size of chunks, offsets, and total number of chunks. For more information, see page Allow Large Chunk Mode. |
| B-tree scanner with onstat -C | This option allows the new B-tree scanner to automatically delete the most used index items. For more information, see onstat -C. |
| PLOG_OVERFLOW_PATH | PLOG_OVERFLOW_PATH. |
Version 9.4 included the following enhancements to the onstat utility.
| New Features | Reference |
|---|---|
| onstat -g env | This new onstat -g option displays the settings for all environment variables know to the server. For more information, see The onstat -g env Option. |
| onstat -g ses | The onstat -g ses option has been enhanced to provide additional session information used to diagnose shared memory dumps. For more information, see The onstat -g ses Option. |
| onstat -g sql | For more information, see The onstat -g sql Option. |