Knowledgebase

Knowledgebase FairCom DB Architectural Concepts Server Advantages vs. Multiuser Standalone FairCom DB Storage System Support Positioning the FairCom DB in the System Architecture OLTP Solutions Hardware Component Sizing FairCom DB Customer Performance Metrics Best Practices Selecting FairCom DB 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 File Mirroring When to Use Mirrored Files Creating Mirrored Files Summary of FairCom DB Features FairCom DB Files to Include for a Successful Backup Strategy Automatic Recovery Restrict Access to FairCom DB Server Files External Third-Party Utilities Safely Copying FairCom DB Controlled Files File Rebuilds Java Requirements for FairCom DB 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 FairCom DB SQL - Microsoft SQL Server Integration Connecting to Microsoft 64-bit SQL Server 2005 using a 32 bit ODBC driver ctKEEPOPEN File Mode to Retain Cached Server Data Notification Example Keep a CTUSER Library Open Utility to Search Logs for Open Transactions FairCom DB OEM Installation Notes FairCom Database Engine FairCom ADO.NET Data Provider FairCom ODBC Driver FairCom JDBC Driver Linux systemd Scripts to Start and Stop FairCom DB Adding FairCom DB JDBC to a Third-Party JDBC Tool Configuration and Tuning V10 and V11 Configuration Recommendations FairCom DB 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 Transaction Log Reset Procedure Maximum Number of Indexes 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 FairCom DB Internal Resource Usage Monitoring FairCom DB Using Snapshot Support Snapshot Configuration File Options Snapshot API Function Options Monitoring FairCom DB Using ctstat Utility Monitoring FairCom DB Using SystemConfiguration API Monitoring FairCom DB Memory Use Monitoring FairCom DB Lock Table LockDump API Options SnapShot API Options SystemConfiguration API Options Monitoring FairCom DB Client Activity ctadmn Options for Monitoring Client Activity Server Configuration Options SystemConfiguration Options Monitoring FairCom DB Transaction Activity Server Configuration Options SnapShot API Options Monitoring FairCom DB Transaction Numbers and Transaction File Numbers Monitoring FairCom DB File Usage Server Configuration Options SystemConfiguration API Options Monitoring FairCom DB Dynamic Dumps Monitoring FairCom DB Automatic Recovery Monitoring FairCom DB Cache Usage Monitoring FairCom DB Status Log Messages Monitoring FairCom DB Process State Monitoring FairCom Server with strace Troubleshooting and Debugging Failures During FairCom DB Startup Server Fails to Start Unactivated c-tree Server (DEPRECATED SUPPORT) 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 Workaround - Failed to Bind SHMEM Server Startup Hangs or Takes Excessive Time Java 1.7 uses large amount of virtual memory at startup Failures During FairCom DB Operation Clients Cannot Connect to Server FairCom DB Error 10: SPAC_ERR FairCom DB Error 84: MUSR_ERR FairCom DB Error 127: ARQS_ERR FairCom DB Error 128: ARSP_ERR FairCom DB Error 133: ASKY_ERR FairCom DB Error 150: SHUT_ERR FairCom DB Error 162: SGON_ERR FairCom DB Error 450: LUID_ERR FairCom DB Error 451: LPWD_ERR FairCom DB Error 452: LSRV_ERR FairCom DB Error 470: LGST_ERR FairCom DB Error 530: LMTC_ERR FairCom DB Error 579: LIVL_ERR FairCom DB Error 584: LRSM_ERR FairCom DB Error 585: LVAL_ERR FairCom DB Error 589: LADM_ERR FairCom DB Error 593: XUSR_ERR FairCom DB Error 609: LTPW_ERR Clients Lose Connection to Server FairCom DB Error 7: TUSR_ERR FairCom DB Error 127: ARQS_ERR FairCom DB Error 128: ARSP_ERR FairCom DB Error 150: SHUT_ERR FairCom DB 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 FairCom DB Files Enabling Low-Level File I/O Diagnostics FairCom DB Error 12: FNOP_ERR FairCom DB Error 14: FCRP_ERR FairCom DB Error 417: SPAG_ERR FairCom DB Error 456: SACS_ERR FairCom DB Error 457: SPWD_ERR Errors Occur When Reading or Writing FairCom DB Files FairCom DB Error 35: SEEK_ERR FairCom DB Error 36: READ_ERR FairCom DB Error 37: WRITE_ERR FairCom DB Error 39: FULL_ERR FairCom DB Error 40: KSIZ_ERR FairCom DB 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 FairCom DB Shutdown Server Shuts Down Improperly Server Shutdown Hangs or Takes Excessive Time Monitoring FairCom DB Shutdown Progress Forcibly Terminating FairCom DB During Shutdown Failures During System Recovery Automatic Recovery Fails Recovering from Automatic Recovery Failure FairCom DB 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 Locating a Record in LockDump Output How do I clean and reset the transaction numbers for my files? Pending File ID Overflow: Error 534 in CTSTATUS.FCS Understanding the "Pending File ID Overflow" Message Determining the Current File ID Recommended Actions Transaction Log Reset 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 CPUs Report Different Times on Linux, Causing Unexpectedly Long sleep() Times Prevent FPUTFGET LNOD_ERR Error (50) from OpenIFile() Connection and Startup 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 FairCom DB Core Files on Linux FairCom DB Memory Use and glibc malloc per-thread Arenas How to Reproduce a Problem Using TRAPCOMM.FCS FairCom DB SQL Troubleshooting Java Configuration for FairCom DB SQL Stored Procedures, Triggers and User Defined Functions Setting/Enabling Advanced Features in SQL Explorer SRLSEG not Available in FairCom DB 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 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 FairCom DB SQL Java Stored Procedures Compiling FairCom DB SQL PHP on Linux/Unix IoT and FairCom Edge Help Core Files on the Raspberry Pi Backing up the Raspberry Pi COBOL Troubleshooting COBOL Compilers Supported by FairCom RTG COBOL Troubleshooting Data Conversion Errors Error: Requested def blk is empty FairCom RTG SQL Access Errors Reference Material mtmake Command Line Typical Unix Errors from errno.h Header File FairCom DB Server Files FairCom DB 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 749X Internal Error Codes Google Chrome Tips for Developers Operating System Specific Tips Microsoft Windows Installation Error Due to XML Encoding Windows Vista Network AutoTuning Parameters Configuring 32-bit ODBC Drivers on 64-bit Windows Versions Connecting to Microsoft 64-bit SQL Server 2005 using a 32 bit ODBC driver Slow Windows Network Traffic Linux CPUs Report Different Times on Linux, Causing Unexpectedly Long sleep() Times Compiling FairCom DB 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 32-bit FairCom Servers Require EXTSHM ON for Correct Shared Memory Usage IBM AIX Large Page Support IBM AIX Mutex Performance Tuning Options Activation Failures (Error 26) on AIX 6 HP-UX Moving a HP-UX FairCom DB 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 Delete Node Reuse List Default Behavior Change Pre-V11 Issues Highly Concurrent FairCom DB 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 FairCom DB from LRU Cache Miss Limitations Potential FairCom DB 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 V12 Issues Older .NET configurations detected correctly Upgrading from Previous Editions Steps to Upgrade FairCom Server Upgrade Notes for Developers Upgrade Notes for Administrators Adjusting PAGE_SIZE More about Upgrading Let Existing ISAM Applications Co-Exist with SQL Upgrading V6 Applications Duplicate Keys #defines Converting c-tree V4.1F-V4.3C Applications Application Conversion Details ctin43 - Create flat key file from V4.3 index file ctitop - Create OTP and Parameter Files ctpotp - Parameter to OTP conversion ctptoi - Parameter to IFIL conversion ctpkey - Print key utility FairCom Typographical Conventions Copyright Notice Index