The following tables provide information about features that were added to IBM Informix Dynamic Server, Version 9.3.
Version 9.3 included the following enhancements to the DataBlade API.
| New Features | Reference |
|---|---|
| New PER_STMT_EXEC and PER_STMT_PREP memory durations | onstat -g mem in onstat -g Monitoring Options |
Version 9.3 included new features that make the database server easier to install, use, and manage.
| New Features | Reference |
|---|---|
| Ability to display the maximum number of connections | Maximum server connections number in Appendix E. Error Messages |
| Microsoft Transaction Server/XA support | onstat -x |
| Two modifiable shell scripts, alarmprogram.sh and alarmprogram.bat, to handle event alarms | Appendix C. Event Alarms |
| Several new configuration parameters: | DEF_TABLE_LOCKMODE
DYNAMIC_LOGS Enterprise Replication Configuration Parameters SBSPACETEMP |
Changed output for these commands:
|
onstat -l
onstat -x |
Version 9.3 included the following improvements in the area of extensibility.
| Sbspace enhancements | Reference |
|---|---|
| Temporary sbspaces and smart large objects | Create an Sbspace or Temporary Sbspace |
| Improved space allocation of user data and metadata in sbspaces | Sbspace Structure
Sbspace Metadata Messages |
Version 9.3 included many new features to help you monitor and improve the performance of your database.
| New Features | Reference |
|---|---|
| The onstat -g stm option | onstat -g stm on page onstat -g Monitoring Options |
| Dynamic addition of logical logs | DYNAMIC_LOGS
Add a Logical-Log File Dynamic Log Messages |
Version 9.3 included several new SQL statements to ease migration from non-IBM Informix databases to Dynamic Server, Version 9.3.
| New Features | Reference |
|---|---|
| Configurable default lock modes | DEF_TABLE_LOCKMODE |
The following lists significant changes to the IBM Informix Administrator's Reference.
| Changes to the Manual | Reference |
|---|---|
| Server Studio JE has replaced IBM Informix DB Administrator. | Server Studio JE |
| Use the VPCLASS configuration parameter instead of the AFF_NPROCS, AFF_SPROC, NOAGE, NUMAIOVPS, and NUMCPUVPS configuration parameters. | Appendix D. Discontinued Configuration Parameters. |
| The conversion and reversion error messages are now in this manual. | Conversion/Reversion Messages |