V11.5 Update Guide

Index

Symbols & Numeric A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Symbols & Numeric

*_FLUSH_SEC background flush rate reduces contention

.NET stored procedure plug-in updated for Visual Studio 2015 and 2017

Ability to promote INT8U columns to NUMERIC

Add a new file to a running replication environment

Added "Max Rows" control to Scripts and Statements panels

Added scripting feature to Convert/Import

Adding Hot Alter Table support to existing files

Additional Improvements

ADDREC DELFLG_ERR (31) following recovery

Notable Compatibility Changes

Administrative Utilities

c-treeACE V11.5 at a Glance

ADO.NET Provider - Updated list of reserved words

ADO.NET Support for TLS

ADO.NET tutorial projects upgraded to Framework 4.5

Advances in the Core Engine

c-treeACE V11.5 at a Glance

Automatic restore point logging

Background file flush threads optimized

Check for out-of-range value of FILES configuration option

Checking if ctThrdInit() has been called

Communications Layer

Notable Compatibility Changes

COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD

Notable Compatibility Changes

Conditional expression functions to convert Unix time_t fields to c-tree Date and Time types

Configurable file sync interval on dynamic dump

connectionidletimeout connection option for ADO.NET provider

Considerations

CRITICAL_SECTION_SPIN - Configurable mutex spin for Unix/Linux

ctdbCreateMRTTable behavior change

Notable Compatibility Changes

ctdbGetRecordCount behavior on MRT Table modified

Notable Compatibility Changes

ctdbTimeMsecToString and ctdbStringToTimeMsec

ctdmpidx Index Dump Utility

ctfilblkif - Manual Reopen

ctinfo - File Information Utility

ctquiet options to support incremental backup restore points

ctRecordUpdateCallbackControl - Option to update all existing records

c-treeACE Explorer (Java Version)

c-treeACE Gauges (Windows Version)

c-treeACE Hot Alter Table

c-treeACE V11.5 at a Glance

Replication User-Defined Extensions

c-treeACE ISAM

c-treeACE ISAM Explorer Encoding Option

c-treeACE JDBC

c-treeACE Monitor

c-treeACE Performance Monitor DLL changed

Notable Compatibility Changes

c-treeACE PHP 7 Support

c-treeACE Python

c-treeACE Query Builder

c-treeACE Replication Solutions

c-treeACE V11.5 at a Glance

c-treeACE setup error 126 during ODBC installation phase

c-treeACE SQL ADO.NET

c-treeACE SQL Explorer (Windows Version)

c-treeACE SQL Import

COMPATIBILITY SQLIMPORT_ADMIN_PASSWORD

c-treeACE SQL Import

Notable Compatibility Changes

c-treeACE SQL Instant Performance Enhancements

Instant Improvements

c-treeACE V11.5 at a Glance

c-treeDB - New ctdbAddRowIdSegment function

c-treeDB Instant Performance Enhancements

Instant Improvements

c-treeDB NAV API

c-treeDB new flags for CTDB_BINARY_FLAG

c-treeDB performance enhanced

ctscmp - Superfile Compact Utility

ctsqlimp removed synonyms and grants on table removal

CTSQLIMPOPTS structure prior to V11.2.3

ctstat Statistics Monitoring Utility

cttrnmod - Change Transaction Mode Utility

Cursor.rowcount now returns the number of returned rows from "select" before fetching

Data Integrity - Dynamic Dump & Restore

c-treeACE V11.5 at a Glance

Data Integrity - Dynamic Dump & Restore

dbdump, dbload Unicode support

dbload allows ";" after NEXT RECORD command in command file

Default Replication Agent conflict detection

Notable Compatibility Changes

DELSTK_COMMIT_SEC improves performance of TRNLOG operations

Notable Compatibility Changes

Direct SQL

DISK_FULL_ACTION (SUBSYSTEM)

Dr. c-tree

DSQL - New ctsqlGetParameterIndexByName function

DSQL no longer allows using ctsqlGetChar() to retrieve long variable columns

Notable Compatibility Changes

DSQL partial support for scrollable cursors

Dump rows when multi-line control has focus

Dynamic Dump now stops when client callback function returns an error

Notable Compatibility Changes

Dynamic Dump status and error messages

Enable ctCHECKLOCK for specified data files at runtime

Environment variable to enable c-tree advanced encryption

Escape field name matching reserved words in c-tree expressions

Extended c-treeACE Features

c-treeACE V11.5 at a Glance

Extended c-treeACE Features

FairCom Low-Level

FairCom Server

FairCom Server lock wait-for graph now uses less memory

FairCom Server physical CPU counting method on AIX

Notable Compatibility Changes

FairCom.Isam.dll - Added ctVerifyFile API to isam.net.cs DLL

File Management

Forward Roll - ctfdmp now creates directory

Full-Text Search

c-treeACE V11.5 at a Glance

Full-Text Search

Graphical Administrative Tools

c-treeACE V11.5 at a Glance

Graphical Administrative Tools

GUI tools now set the "Node Name" identification attribute

GUI Tools now support IPv6

GUI Tools now support SSL

Hibernate support adds a persistence layer to Java applications

High-Velocity c-treeACE APIs

c-treeACE V11.5 at a Glance

High-Velocity c-treeACE APIs

Hot Alter Table supports changing lengths of string fields

-I option

Improved Auto Restore Point performance with checkpoints

Improved log message when PAGE_SIZE does not meet encryption block size requirements

Improved Replication Agent logging on Unix systems

Improved scrollable cursor support

Improvements in Dynamic Dump immediate restore

Improvements to Sequence API operation involving active transactions

Index Range Support for Virtual Segment Groups

Notable Compatibility Changes

Index rebuild options enhance performance

Rebuild performance increased

Indexing

Instant Improvements

Interface Technology

c-treeACE V11.5 at a Glance

Interface Technology

Introduction to c-treeACE V11.5

-isam header changed to avoid misunderstanding

Notable Compatibility Changes

Java Stored Procedures and Triggers Require JDK V1.7 or Newer

JDBC connection URL new format

JDBC tutorials updated to use the current URL format

Notable Compatibility Changes

JDBC Support for TLS

JDBC tutorials updated to use the current URL format

List all users for non-DBA users

Local/master replication model diagnostic logging of errors during two-phase transaction commit

Notable Compatibility Changes

Log additional detail on server shutdown

LOPN_ERR (96) - allow Automatic Recovery to continue

More Advances in the FairCom Replication Solutions

MRT Table support added to Java interfaces

Multi-Record Type (MRT Tables) Updates

NO_FIXED_OFFSET_CHECK - Prevent reads/writes to arbitrary offsets for fixed-length files

Notable Compatibility Changes

c-treeACE V11.5 at a Glance

Notable Compatibility Changes

ODBC

ODBC Support for SSL

OpenSSL Headers for Linking c-treeACE Client Applications

Operating System cache flush suppressed for non-TRANLOG files

Notable Compatibility Changes

Operating System cache flush suppressed for non-TRANLOG files

OPNRFILX() modification

Notable Compatibility Changes

OPNRFILX() modification

Option to specify external library name in platform-independent format

Passing Replication Agent Command-Line Options to Its Internal Server

Performance enhancement of Replication Agent log read

Performance enhancement using ctdbFindRecord on variable-length records

Performance Gains

c-treeACE V11.5 at a Glance

Performance Gains

Performance Improvement - Transaction commit of many files

Performance improvement in parameterized query

Performance improvements in ctdbOpenTable

Notable Compatibility Changes

Performance improvements in ctdbOpenTable

Performance-Boosting Features

Background file flush threads optimized

Performance-Boosting Features

Preventing Possible Data Loss with Compact & Rebuild Operations

Python support expands beyond Windows and Linux

Rebuild optimized when an index already exists

Rebuild performance increased

Index rebuild options enhance performance

Rebuild performance increased

Rebuilding data files with Hot Alter Table support

Record update callback

RECOVER_MEMLOG improves ctrdmp recovery performance

Reduced minimal index cache size requirements

Notable Compatibility Changes

Reduced minimal index cache size requirements

Reduced overhead in password file decryption

Relational c-treeACE SQL

c-treeACE V11.5 at a Glance

Relational c-treeACE SQL

repadm option to list IDs for a Replication Agent process

Replication administration utility (repadm) upgraded to latest statistics version

Replication Agent function profiling

Replication Agent Monitor default server name changed

Notable Compatibility Changes

Replication Agent Monitor default server name changed

Replication Agent redirection rules consider slash & backslash to be equivalent

Replication file filter list

Replication of Hot Alter Table

Replication of Hot Alter Table operations

Replication ReSync

Replication User-Defined Extensions

Restore point file name now includes log number

Notable Compatibility Changes

Restore point file name now includes log number

Restore recovery options

Scripting feature: PK retrieval Stored Procedure

Security

c-treeACE V11.5 at a Glance

Security

Server broadcast feature enabled on all platforms

Server keyword to enable UNOD_ERR (51) diagnostic stack dump

Server Manager store file is now interchangeable between Windows and Java

Shared Memory Protocol Change

Speed improvement in forward roll

SQL - COUNT fix and new COUNT_BIG support

SQL - Create [if not exists] and Drop [if exists]

SQL - SET IDENTITY_INSERT support

SQL Drop Table on MRT Tables now removes physical file

SQL Language

SQL performance enhancement on Insert

SQL sequence support

SQL Sequences

SQL support for Python V3.x

Standalone FPUTFGET, index file open in exclusive mode

Stored procedure to retrieve SQL database version

Support c-treeACE quiesce state waiting for replication readers to process all committed transactions

Support for commenting out an entire SUBSYSTEM block in ctsrvr.cfg

Support for CT_TIME_MS and CT_TIMES_MS

Support for dynamically altering a table's schema on-the-fly

Support for older versions

Synchronize with repadm resync

SYSCFG() cfgCFGCHK bit to indicate if advanced encryption is enabled

Temporary Index RVHD_ERR (123)

Testing with Default c-treeACE Certificates

-text run by non-ADMIN user account reports memory use of -1

TLS Support for Replication

TLS/SSL Tutorials

TRAN_RECOVERY - Restore recovery diagnostic logging

Transaction log limit for replication and deferred indexing

Notable Compatibility Changes

Transaction log limit for replication and deferred indexing

Transport Layer Security Secures Data in Transit between Network c-treeACE Clients and Servers

Update list synchronization object management improvement

-userinfo to output the user connection communication protocol