Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 7)

Adaptive Server IQ 12.4.0 Changed functionality in Adaptive Server IQ 12.4.0
Release Bulletin for Digital UNIX 7
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 out-of-space conditions If you run out of disk
space, Adaptive Server IQ now provides better assurance that you will be
able to add space where you need it.
•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.0 adds 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.