Adaptive Server IQ 12.4.0 | Changed functionality in Adaptive Server IQ 12.4.0 |
In version 11.x, you could output the query plan using the command IQ SET QUERYINFO ON. In Adaptive Server IQ 12.0, run the following command to output the query plan:
SET TEMPORARY OPTION Query_Plan = ’on’
The plan will be in the .IQMSG file.
If you want additional detail or are sending the plan to Technical Support you can use:
SET TEMPORARY OPTION Query_Detail = ’ON’
6. Changed functionality in this version
The following sections describe changes since the Adaptive Server IQ documentation set was updated.
6.1 Changed functionality in Adaptive Server IQ 12.4.0
This section summarizes new features and other changes to Adaptive Server IQ
12.4.0.Details of most of these features are provided in “Documentation updates and clarifications” on page 14.
• Improved handling of
•Adaptive Server IQ now reserves space so you can issue a create dbspace command. You can control the amount of space reserved by setting two new options, Reserved_Main_DBSpace_MB and Reserved_Temp_DBSpace_MB. For details on these options, see “New options for reserving space” on page 34.
•The error message now specifies the amount of space you need to add in megabytes, and matches the syntax in create dbspace.
It is extremely unlikely that you will ever need to bring down the server to add space. For revised documentation on what to do if you run out of space, see “Insufficient disk space” on page 35.
• Forced recovery and leaked space recovery Adaptive Server IQ
12.4.0adds better support for recovering from crashed and potentially corrupt databases. It also adds support for recovering leaked storage space. For details of these features, see “Forced recovery and leaked space recovery” on page 36.
Release Bulletin for Digital UNIX | 7 |