Contents

 
Knowledgebase
Copyright Notice
FairCom Typographical Conventions
c-treeACE Architectural Concepts
Server Advantages vs. Multiuser Standalone
c-treeACE Storage System Support
Positioning the c-treeACE in the System Architecture
Single c-treeACE Architecture
Multiple c-treeACE Architecture
System Requirements
Platform Support
Minimum Software Requirements for c-treeACE
Using Java 1.7 or Later on Windows
Minimum Hardware Requirements for c-treeACE
Java Version
.NET Framework Requirements
.NET Tools for VS2010 - All projects updated to use .NET Framework v4.0
.NET - Removed STRONGSIGN from assemblies
ADO.NET Entity Framework V2 - V4 Support
c-tree OLTP Solutions
Background
Hardware Component Sizing
c-tree Customer Performance Metrics
Best Practices
Selecting c-treeACE Features Used in the System
Data and Index Caching Options
Caching of Data Records
Caching of Index Nodes
Properties of Cached Files
Configuring Caching
Transaction-Controlled Files
PREIMG Transaction Files
Properties of PREIMG Files
Backup and Restore Options for PREIMG Files
When to Use PREIMG Files
Creating and Using PREIMG Files
TRNLOG Transaction Files
Properties of TRNLOG Files
Backup and Restore Options for TRNLOG Files
When to Use TRNLOG Files
Creating and Using TRNLOG Files
TRNLOG Transaction Files with LOGIDX Indexes
Properties of LOGIDX Index Files
When to Use LOGIDX Index Files
Creating and Using LOGIDX Index Files
Delayed Durability
6-Byte Transaction Numbers
Transaction Number Limitations Prior to V8
c-tree Server V8 Transaction Number Enhancements
When to Use 6-Byte Transaction Number Files
Creating 6-Byte Transaction Number Files
Configurable Transaction Number Overflow Warning Limit
Non-Transaction Files
Properties of Non-Transaction Files
Backup and Restore Options for Non-Transaction Files
When to Use Non-Transaction Files
Creating Non-Transaction Files
WRITETHRU Files
Properties of WRITETHRU Files
Backup and Restore Options for WRITETHRU Files
When to Use WRITETHRU Files
Creating WRITETHRU Files
Large File Support
Huge Files
When to Use Huge Files
Creating Huge Files
Segmented Files
When to Use Segmented Files
Creating Segmented Files
Memory Files
Properties of Memory Files
When to Use Memory Files
Creating Memory Files
Partitioned Files
When to Use Partitioned Files
Creating Partitioned Files
File Mirroring
When to Use Mirrored Files
Creating Mirrored Files
Summary of c-treeACE Features
c-tree Files to Include in a Dynamic Dump
Automatic Recovery
Restrict Access to c-treeACE Server Files
External Third-Party Utilities
Safely Copying c-treeACE Controlled Files
File Rebuilds
Java Requirements for c-treeACE SQL
Better Performance with NXTVREC() vs GTVREC()
8 Steps to a Fast Data Load
Calculating Memory Usage
Controlling Server Memory
Calculating File Storage Space
Calculating Index Sizes
Migrating Data Between Platforms and Operational Models
Single-User Standalone
Multi-User Standalone
Client/Server
File Migration
Migrating Your Application Between Operational Models
Single-User to Multi-User Standalone or Client/Server
Multi-user Standalone to Client/Server
Adding Transaction Processing
Single-Threaded to Multi-Threaded
SQL Data Load Tips
Helpful Examples
c-treeACE SQL - Microsoft SQL Server Integration
Connect Microsoft 64-bit SQL Server 2005 to c-treeACE SQL
ctKEEPOPEN File Mode to Retain Cached Server Data
Notification Example
Moving a HP-UX c-treeACE SQL Database to Windows
convert.sh
Keep a CTUSER Library Open
Utility To Search Logs For Open Transactions
c-treeACE OEM Installation Notes - V9 through V11
c-treeACE Database Engine
c-treeACE SQL ADO.NET Data Provider
c-treeACE SQL ODBC Driver
c-treeACE SQL JDBC Driver
Script to Start and Stop the Server
Configuration and Tuning
V10 and V11 Configuration Recommendations
c-treeACE Server Configuration Recommendations
SKIP_MISSING_FILES
KEEP_LOGS
FORCE_LOGIDX
Large Page Support to Improve Large Cache Performance
64-bit Windows Filesystem Behavior
Configuring 32-bit ODBC Drivers on 64-bit Windows Versions
Relocating Transaction Logs
Maximum Number of Indices Per Data File
Monitoring Performance
Monitoring System Resource Usage
Monitoring CPU Usage
Monitoring Disk Usage
Monitoring Memory Usage
Monitoring Network Usage
Other System Monitoring Options
Monitoring c-treeACE Internal Resource Usage
Monitoring c-treeACE Using Snapshot Support
Snapshot Configuration File Options
Snapshot API Function Options
Monitoring c-treeACE Using ctstat Utility
Monitoring c-treeACE Using SystemConfiguration API
Monitoring c-treeACE Memory Use
Monitoring c-treeACE Lock Table
LockDump API Options
SnapShot API Options
SystemConfiguration API Options
Monitoring c-tree Client Activity
Server Configuration Options
ctadmn Utility Options
SystemConfiguration Options
Monitoring c-treeACE Transaction Activity
Server Configuration Options
SnapShot API Options
Monitoring c-treeACE Transaction Numbers and Transaction File Numbers
Monitoring c-treeACE File Usage
Server Configuration Options
SystemConfiguration API Options
Monitoring c-treeACE Dynamic Dumps
Monitoring c-treeACE Automatic Recovery
Monitoring c-treeACE Cache Usage
Monitoring c-treeACE Status Log Messages
Monitoring c-treeACE Process State
Monitoring c-treeACE Server with strace
Troubleshooting and Debugging
Failures During c-treeACE Startup
Server Fails to Start
Unactivated c-tree Server
Missing or Incorrect Configuration File
Unrecognized Keyword in Server Configuration File
Server Fails to Open Server Administrative Files
Missing Server Binary or Communication DLLs
Server Cannot Initialize Communication Protocol
Missing or Corrupt Server Settings File
Automatic Recovery Fails
A Server is Already Running in the Working Directory
Dynamic Dump Cannot Be Scheduled
Server Startup Terminates Abnormally
Server Startup Hangs or Takes Excessive Time
Java 1.7 uses large amount of virtual memory at startup
Failures During c-treeACE Operation
Clients Cannot Connect to Server
c-tree Error 10: SPAC_ERR
c-tree Error 84: MUSR_ERR
c-tree Error 127: ARQS_ERR
c-tree Error 128: ARSP_ERR
c-tree Error 133: ASKY_ERR
c-tree Error 150: SHUT_ERR
c-tree Error 162: SGON_ERR
c-tree Error 450: LUID_ERR
c-tree Error 451: LPWD_ERR
c-tree Error 452: LSRV_ERR
c-tree Error 470: LGST_ERR
c-tree Error 530: LMTC_ERR
c-tree Error 579: LIVL_ERR
c-tree Error 584: LRSM_ERR
c-tree Error 585: LVAL_ERR
c-tree Error 589: LADM_ERR
c-tree Error 593: XUSR_ERR
c-tree Error 609: LTPW_ERR
Clients Lose Connection to Server
c-tree Error 7: TUSR_ERR
c-tree Error 127: ARQS_ERR
c-tree Error 128: ARSP_ERR
c-tree Error 150: SHUT_ERR
c-tree Error 162: SGON_ERR
Number of Active Transaction Logs Unexpectedly Increases
Server Is In A Non-Responsive State
Some Clients Are In A Non-Responsive State
Errors Occur When Opening c-tree Files
Enabling Low-Level File I/O Diagnostics
c-tree Error 12: FNOP_ERR
c-tree Error 14: FCRP_ERR
c-tree Error 417: SPAG_ERR
c-tree Error 456: SACS_ERR
c-tree Error 457: SPWD_ERR
Errors Occur When Reading or Writing c-tree Files
c-tree Error 35: SEEK_ERR
c-tree Error 36: READ_ERR
c-tree Error 37: WRITE_ERR
c-tree Error 39: FULL_ERR
c-tree Error 40: KSIZ_ERR
c-tree Error 49: FSAV_ERR
c-tree API Call Fails With Unexpected Error
Server Writes Unexpected Messages to Status Log
Server Exhibits Atypical Performance
Server Exhibits Unexpected Resource Usage
Dynamic Dump Fails
Data or Index File Sizes Grow Unexpectedly
Server Terminates Abnormally
Recovering From Abnormal Server Termination
Failures During c-treeACE Shutdown
Server Shuts Down Improperly
Server Shutdown Hangs or Takes Excessive Time
Monitoring c-tree Server Shutdown Progress
Forcibly Terminating the c-tree Server During Shutdown
Failures During System Recovery
Automatic Recovery Fails
Recovering from Automatic Recovery Failure
c-tree File Open Errors During Recovery
Automatic Recovery Terminates Abnormally
Automatic Recovery Takes Excessive Time
Dynamic Dump Restore Fails
File Rebuild Fails
File Compact Fails
LockDump Output
Types of Locks
How do I clean and reset the transaction numbers for my files?
Pending File ID Overflow: Error 534 in CTSTATUS.FCS
Timeout Error Diagnosis
Heap Debugging on Solaris 9+ Operating Systems
prstat and Performance Monitoring on Solaris Operating Systems
Using Windows Process Explorer to Obtain Thread Call Stacks
Generating Dump Files on 64-bit Windows
Transaction Log Increases
Additional Transaction Log Number Messages
Dynamic Dump Restore FMOD_ERR (48)
FUSE_ERR (22) During Automatic Recovery
Activation Failures (Error 26) on AIX 6
Analyzing ctsemrqs() Calls on AIX systems
CPUs Report Different Times on Linux, Causing Unexpectedly Long sleep() Times
Prevent FPUTFGET LNOD_ERR Error (50) from OpenIFile()
Troubleshooting Replication Issues
Replication and Low-Level Operations - Error 919
gdb Remote Debugging
"ctntio error" Entries in Status Log File CTSTATUS.FCS
"WARNING: ct_lflsema livelock" Entries in Status Log File CTSTATUS.FCS
Disappearing c-treeACE Core Files on Linux
c-treeACE Memory Use and glibc malloc per-thread Arenas
c-treeACE SQL Troubleshooting
Java Configuration for c-treeACE SQL Stored Procedures, Triggers and User Defined Functions
Setting/Enabling Advanced Features in SQL Explorer
SRLSEG not Available in c-treeACE SQL When ROWID is Used
What are .fdk Files in the SQL_SYS Directory?
What is __Master.dbs?
Error While Creating SQL Database
DBLOAD Debugging Help
Debugging Java Stored Procedures
Stored Procedure Error: Could not initialize class sun.util.calendar.ZoneInfoFile
Stored Procedure Java Class Resolution
When do I have to specify the owner of a table?
How do I convert tables in a database to be case insensitive?
Analyzing JVM Memory usage with c-treeACE SQL Java Stored Procedures
Compiling c-treeACE SQL PHP on Linux/Unix
COBOL Help
COBOL Compilers Supported by c-treeRTG COBOL Edition
Troubleshooting Data Conversion Errors
Error: Requested def blk is empty
c-treeRTG SQL Access Errors
Reference Material
mtmake Command Line
mtmake Advanced Options
Typical Unix Errors From errno.h Header File
c-treeACE Server Files
c-treeACE Utilities
NULL Handling
ISAM Parameter Files (Legacy)
ISAM Parameter File Organization
Parameter File Contents
Initialization Record
Data File Description Record
Index File Description Record
Optional Index Member Record
Key Segment Description Record
Fixed-Length Parameter File Examples
Variable-Length Parameter File Example
Multiple Data File Parameter Setup
Parameter Files in Client Server Models
Prototyping
2xx Internal Error Codes
Internal 749X Error Codes
Operating System Specific
Microsoft Windows
Installation Error Due to XML Encoding
Windows Vista Network AutoTuning Parameters
Configuring 32-bit ODBC Drivers on 64-bit Windows Versions
Connect Microsoft 64-bit SQL Server 2005 to c-treeACE SQL
Slow Windows Network Traffic
Linux
CPUs Report Different Times on Linux, Causing Unexpectedly Long sleep() Times
Compiling c-treeACE SQL PHP on Linux/Unix
Memory Use of Linux Processes
Solaris
Heap Debugging on Solaris 9+ Operating Systems
AIX
IBM AIX Multicore/CPU Performance Tuning Options
IBM AIX Large Page Support
IBM AIX Mutex Performance Tuning Options
Analyzing ctsemrqs() Calls on AIX systems
Activation Failures (Error 26) on AIX 6
HP-UX
Moving a HP-UX c-treeACE SQL Database to Windows
convert.sh
Function Name Cross Reference
Full Names
Abbreviated (short) Names
Function API Listing
Initialization API
ctThrd API
Instance Control API
ISAM Initialization API
Low-level Initialization API
Data Definition API
ISAM Data Definition API
Low-level Data Definition API
Data Manipulation API
ISAM Data Manipulation API
Batch API
Context API
Sets API
Low-level Data Manipulation API
Utility Functions
Server Administration API
Transaction Processing API
Common Entry Point Functions
Forced Single Entry Point Capability
Extended Feature Parameter Blocks
Logon Block
ISAM Block
IFIL Block
Create File Block
Open File Block
Key Estimate Block
Function Calls
Important Technical Updates
Highly Concurrent c-treeACE SQL Updates Involving Floating Point Conversions
Prevent FPUTFGET Data Corruption with Concurrent Updates
Potential Variable Length Data Corruption Prevented During Automatic Recovery
Prevent Termination of c-treeACE from LRU Cache Miss Limitations
Potential c-tree Server Automatic Recovery Failures with the LOGIDX Feature
Avoid Index Errors Caused by memcpy() Implementation on Latest Operating Systems
Correct Handling of Segmented Files During Automatic Recovery
Microsoft Vista Locks Out FPUTFGET
Transaction Number Rollover
Upgrading from Previous Editions
Steps to Upgrade c-treeACE Server
Upgrade Notes for Developers
Upgrade Notes for Administrators
More about Upgrading c-treeACE
Let Your Existing ISAM Applications Co-Exist With c-treeSQL
Upgrading V6 Applications
Duplicate Keys
#defines
Converting c-tree V4.1F-V4.3C Applications
Application Conversion Details
Backward Compatibility
Index