Miscellaneous Changes
The following miscellaneous changes are included in Ingres 10.
New Way to Specify Unicode Literals
To specify a Unicode literal value within a non-Unicode command string compatible with Microsoft SQL server, the following syntax is now available:
N'unicode_string'
For more information, see Unicode Literals in the SQL Reference Guide.
New Terminal Type Added
The PuTTY terminal type is added. For more information, see Terminal Names in the Character-based Querying and Reporting Tools User Guide.
ingstop -f Command Parameter Updated
The –f (force immediate shutdown) parameter of the ingstop command (to shut down an Ingres instance) is updated to be more effective. This parameter typically is used with the –k (kill instance) parameter.
For more information about the ingstop –f parameter, see the ingstop command description in the Command Reference Guide.
IPM Lock List Display More_Info Screen Updated
The Interactive Performance Monitor Lock List Display More_Info screen now displays the following new information for a selected lock list:
• Internal session ID number
• External operating system process ID number
For more information about the updates to this screen, see Lock List Display More_Info Screen in the Interactive Performance Monitor User Guide.
CBF and VCBF Log Writer Update
In Configuration-By-Forms or Visual Configuration-By-Forms, the Recovery Server will accept a configuration of log_writer=0. A useful setup to ensure that there is only one log writer in the installation for log write optimization configures the DBMS log_writer=1 and the Recovery Server log_writer=0.
Type and Function Names Logged in II_DBMS_LOG
If the DBMS Server is linked with user-defined types or functions, the type or function names are logged in the DBMS log (II_DBMS_LOG).
dmf_tcb_limit Parameter Extended
The dmf_tcb_limit parameter in config.dat extends to all Table Control Blocks (TCBs), including partition TCBs. The default dmf_tcb_limit is now 10,000.
This is documented in Partitioning Schemes in the SQL Reference Guide.
Enhancement to Data Handlers for Large Objects (Embedded SQL)
The COPYHANDLER API requires that the user return the number of bytes written through a given parameter. This enhancement adds the bytes_written argument to the COPY INTO PROGRAM statement.
For details, see the put_row routine in the section Handler Code Examples under the Copy From | Into Program statement description in the SQL Reference Guide.