Knowledgebase

Index

6-Byte Transaction Numbers

Monitoring FairCom DB Transaction Numbers and Transaction File Numbers

749X Internal Error Codes

8 Steps to a Fast Data Load

A Server is Already Running in the Working Directory

Abbreviated (short) Names

Activation Failures (Error 26) on AIX 6

Adding FairCom DB JDBC to a Third-Party JDBC Tool

Adding Transaction Processing

Additional Transaction Log Number Messages

Adjusting PAGE_SIZE

AIX

Analyzing JVM Memory usage with FairCom DB SQL Java Stored Procedures

Application Conversion Details

Automatic Recovery

Automatic Recovery Fails

Server Fails to Start

Automatic Recovery Takes Excessive Time

Automatic Recovery Terminates Abnormally

Avoid Index Errors Caused by memcpy() Implementation on Latest Operating Systems

Backing up the Raspberry Pi

Backup and Restore Options for Non-Transaction Files

Backup and Restore Options for PREIMG Files

Backup and Restore Options for TRNLOG Files

Backup and Restore Options for WRITETHRU Files

Batch API

Best Practices

Better Performance with NXTVREC() vs GTVREC()

Caching of Data Records

Caching of Index Nodes

Calculating File Storage Space

Calculating Index Sizes

Calculating Memory Usage

Client/Server

Clients Cannot Connect to Server

Clients Lose Connection to Server

Clients Cannot Connect to Server

Clients Lose Connection to Server

COBOL Compilers Supported by FairCom RTG COBOL Edition

COBOL Troubleshooting

Common Entry Point Functions

Compiling FairCom DB SQL PHP on Linux/Unix

Configurable Transaction Number Overflow Warning Limit

Configuration and Tuning

Configuring 32-bit ODBC Drivers on 64-bit Windows Versions

FairCom DB SQL - Microsoft SQL Server Integration

Configuring Caching

Connecting to Microsoft 64-bit SQL Server 2005 using a 32 bit ODBC driver

Connection and Startup Issues

Context API

Controlling Server Memory

convert.sh

Converting c-tree V4.1F-V4.3C Applications

Core Files on the Raspberry Pi

Correct Handling of Segmented Files During Automatic Recovery

CPUs Report Different Times on Linux, Causing Unexpectedly Long sleep() Times

Create File Block

Creating 6-Byte Transaction Number Files

Creating and Using LOGIDX Index Files

Creating and Using PREIMG Files

Creating and Using TRNLOG Files

Creating Huge Files

Creating Memory Files

Creating Mirrored Files

Creating Non-Transaction Files

Creating Segmented Files

Creating WRITETHRU Files

ctadmn Options for Monitoring Client Activity

ctin43 - Create flat key file from V4.3 index file

ctitop - Create OTP and Parameter Files

ctKEEPOPEN File Mode to Retain Cached Server Data

ctpkey - Print key utility

ctpotp - Parameter to OTP conversion

ctptoi - Parameter to IFIL conversion

c-tree API Call Fails With Unexpected Error

c-tree Server V8 Transaction Number Enhancements

ctThrd API

Data and Index Caching Options

Data Definition API

Data File Description Record

Data Manipulation API

Data or Index File Sizes Grow Unexpectedly

DBLOAD Debugging Help

Delayed Durability

Delete Node Reuse List Default Behavior Change

Important Technical Updates

Determining the Current File ID

Disappearing FairCom DB Core Files on Linux

Duplicate Keys

Dynamic Dump Cannot Be Scheduled

Dynamic Dump Fails

Dynamic Dump Restore Fails

Dynamic Dump Restore FMOD_ERR (48)

Enabling Low-Level File I/O Diagnostics

Error While Creating SQL Database

Error: Requested def blk is empty

Errors Occur When Opening FairCom DB Files

Errors Occur When Reading or Writing FairCom DB Files

Extended Feature Parameter Blocks

External Third-Party Utilities

Failures During FairCom DB Operation

Failures During FairCom DB Shutdown

Failures During FairCom DB Startup

Failures During System Recovery

FairCom ADO.NET Data Provider

FairCom Database Engine

FairCom DB Architectural Concepts

FairCom DB Customer Performance Metrics

FairCom DB Error 10: SPAC_ERR

FairCom DB Error 12: FNOP_ERR

FairCom DB Error 127: ARQS_ERR

FairCom DB Error 128: ARSP_ERR

FairCom DB Error 133: ASKY_ERR

FairCom DB Error 14: FCRP_ERR

FairCom DB Error 150: SHUT_ERR

FairCom DB Error 162: SGON_ERR

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 417: SPAG_ERR

FairCom DB Error 450: LUID_ERR

FairCom DB Error 451: LPWD_ERR

FairCom DB Error 452: LSRV_ERR

FairCom DB Error 456: SACS_ERR

FairCom DB Error 457: SPWD_ERR

FairCom DB Error 470: LGST_ERR

FairCom DB Error 49: FSAV_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

FairCom DB Error 7: TUSR_ERR

FairCom DB Error 84: MUSR_ERR

FairCom DB File Open Errors During Recovery

FairCom DB Files to Include for a Successful Backup Strategy

FairCom DB Memory Use and glibc malloc per-thread Arenas

FairCom DB OEM Installation Notes

FairCom DB Server Configuration Recommendations

FairCom DB Server Files

FairCom DB SQL - Microsoft SQL Server Integration

FairCom DB SQL Troubleshooting

FairCom DB Storage System Support

FairCom DB Utilities

FairCom JDBC Driver

FairCom ODBC Driver

FairCom RTG SQL Access Errors

FairCom Typographical Conventions

Fixed-Length Parameter File Examples

FORCE_LOGIDX

Forced Single Entry Point Capability

Forcibly Terminating FairCom DB During Shutdown

Full Names

Function API Listing

Function Calls

Function Name Cross Reference

FUSE_ERR (22) During Automatic Recovery

gdb Remote Debugging

Generating Dump Files on 64-bit Windows

Google Chrome Tips for Developers

Hardware Component Sizing

Heap Debugging on Solaris 9+ Operating Systems

Helpful Examples

Highly Concurrent FairCom DB SQL Updates Involving Floating Point Conversions

How do I clean and reset the transaction numbers for my files?

How do I convert tables in a database to be case insensitive?

How to Reproduce a Problem Using TRAPCOMM.FCS

HP-UX

Huge Files

IBM AIX 32-bit FairCom Servers Require EXTSHM ON for Correct Shared Memory Usage

IBM AIX Large Page Support

IBM AIX Multicore/CPU Performance Tuning Options

IBM AIX Mutex Performance Tuning Options

IFIL Block

Important Technical Updates

Index File Description Record

Initialization API

Initialization Record

Installation Error Due to XML Encoding

Instance Control API

IoT and FairCom Edge Help

ISAM Block

ISAM Data Definition API

ISAM Data Manipulation API

ISAM Initialization API

ISAM Parameter File Organization

ISAM Parameter Files (Legacy)

Java 1.7 uses large amount of virtual memory at startup

Java Configuration for FairCom DB SQL Stored Procedures, Triggers and User Defined Functions

Java Requirements for FairCom DB SQL

Keep a CTUSER Library Open

KEEP_LOGS

Key Estimate Block

Key Segment Description Record

Knowledgebase

Large File Support

Large Page Support to Improve Large Cache Performance

Let Existing ISAM Applications Co-Exist with SQL

More about Upgrading

Linux

Monitoring System Resource Usage

Linux systemd Scripts to Start and Stop FairCom DB

Locating a Record in LockDump Output

LockDump API Options

LockDump Output

Monitoring FairCom DB Lock Table

Logon Block

Low-Level Data Definition API

Low-Level Data Manipulation API

Low-Level Initialization API

Maximum Number of Indexes Per Data File

Memory Files

Memory Use of Linux Processes

Microsoft Vista Locks Out FPUTFGET

Microsoft Windows

Migrating Data Between Platforms and Operational Models

Migrating Your Application Between Operational Models

Missing or Corrupt Server Settings File

Missing or Incorrect Configuration File

Missing Server Binary or Communication DLLs

Monitoring CPU Usage

Monitoring Disk Usage

Monitoring FairCom DB Automatic Recovery

Monitoring FairCom DB Cache Usage

Monitoring FairCom DB Client Activity

Monitoring FairCom DB Dynamic Dumps

Monitoring FairCom DB File Usage

Monitoring FairCom DB Internal Resource Usage

Monitoring FairCom DB Lock Table

Monitoring FairCom DB Memory Use

Monitoring FairCom DB Process State

Monitoring FairCom DB Shutdown Progress

Monitoring FairCom DB Status Log Messages

Monitoring FairCom DB Transaction Activity

Monitoring FairCom DB Transaction Numbers and Transaction File Numbers

Monitoring FairCom DB Using ctstat Utility

Monitoring FairCom DB Using Snapshot Support

Monitoring FairCom DB Using SystemConfiguration API

Monitoring System Resource Usage

Monitoring FairCom Server with strace

Monitoring Memory Usage

Monitoring Network Usage

Monitoring Performance

Monitoring System Resource Usage

More about Upgrading

Moving a HP-UX FairCom DB SQL Database to Windows

mtmake Command Line

Multiple Data File Parameter Setup

Multi-User Standalone

Multi-user Standalone to Client/Server

Non-Transaction Files

Notification Example

NULL Handling

Number of Active Transaction Logs Unexpectedly Increases

Older .NET configurations detected correctly

OLTP Solutions

Open File Block

Operating System Specific Tips

Optional Index Member Record

Other System Monitoring Options

Parameter File Contents

Parameter Files in Client Server Models

Partitioned Files

Pending File ID Overflow: Error 534 in CTSTATUS.FCS

Positioning the FairCom DB in the System Architecture

Potential FairCom DB Automatic Recovery Failures with the LOGIDX Feature

Potential Variable Length Data Corruption Prevented During Automatic Recovery

PREIMG Transaction Files

Pre-V11 Issues

Important Technical Updates

Pre-V11 Issues

Prevent FPUTFGET Data Corruption with Concurrent Updates

Prevent FPUTFGET LNOD_ERR Error (50) from OpenIFile()

Prevent Termination of FairCom DB from LRU Cache Miss Limitations

Properties of Cached Files

Properties of LOGIDX Index Files

Properties of Memory Files

Properties of Non-Transaction Files

Properties of PREIMG Files

Properties of TRNLOG Files

Properties of WRITETHRU Files

Prototyping

prstat and Performance Monitoring on Solaris Operating Systems

Recommended Actions

Recovering From Abnormal Server Termination

Recovering from Automatic Recovery Failure

Reference Material

Relocating Transaction Logs

Replication and Low-Level Operations - Error 919

Restrict Access to FairCom DB Server Files

Safely Copying FairCom DB Controlled Files

Segmented Files

Selecting FairCom DB Features Used in the System

Server Administration API

Server Advantages vs. Multiuser Standalone

Server Cannot Initialize Communication Protocol

Server Configuration Options

Server Exhibits Atypical Performance

Server Exhibits Unexpected Resource Usage

Server Fails to Open Server Administrative Files

Server Fails to Start

Server Is in a Non-Responsive State

Server Shutdown Hangs or Takes Excessive Time

Server Shuts Down Improperly

Server Startup Hangs or Takes Excessive Time

Automatic Recovery Fails

Monitoring FairCom DB Automatic Recovery

Server Startup Hangs or Takes Excessive Time

Server Startup Terminates Abnormally

Server Terminates Abnormally

Server Shuts Down Improperly

Server Terminates Abnormally

Server Writes Unexpected Messages to Status Log

Sets API

Setting/Enabling Advanced Features in SQL Explorer

Single-Threaded to Multi-Threaded

Single-User Standalone

Single-User to Multi-User Standalone or Client/Server

SKIP_MISSING_FILES

Slow Windows Network Traffic

Snapshot API Function Options

SnapShot API Options

Snapshot Configuration File Options

Solaris

Some Clients Are In A Non-Responsive State

SQL Data Load Tips

SRLSEG not Available in FairCom DB SQL When ROWID is Used

Steps to Upgrade FairCom Server

Stored Procedure Error: Could not initialize class sun.util.calendar.ZoneInfoFile

Stored Procedure Java Class Resolution

Summary of FairCom DB Features

SystemConfiguration API Options

SystemConfiguration Options

Timeout Error Diagnosis

Transaction Log Increases

Transaction Log Reset

Transaction Log Reset Procedure

Transaction Number Limitations Prior to V8

Transaction Number Rollover

Transaction Processing API

Transaction-Controlled Files

TRNLOG Transaction Files

TRNLOG Transaction Files with LOGIDX Indexes

Troubleshooting and Debugging

Troubleshooting Data Conversion Errors

Types of Locks

Typical Unix Errors from errno.h Header File

Unactivated c-tree Server (DEPRECATED SUPPORT)

Understanding the "Pending File ID Overflow" Message

Unrecognized Keyword in Server Configuration File

Upgrade Notes for Administrators

Upgrade Notes for Developers

Upgrading from Previous Editions

Upgrading V6 Applications

Using Windows Process Explorer to Obtain Thread Call Stacks

Utility Functions

Utility to Search Logs for Open Transactions

V10 and V11 Configuration Recommendations

V12 Issues

Variable-Length Parameter File Example

What are .fdk Files in the SQL_SYS Directory?

What is __Master.dbs?

When do I have to specify the owner of a table?

When to Use 6-Byte Transaction Number Files

When to Use Huge Files

When to Use LOGIDX Index Files

When to Use Memory Files

When to Use Mirrored Files

When to Use Non-Transaction Files

When to Use Partitioned Files

When to Use PREIMG Files

When to Use Segmented Files

When to Use TRNLOG Files

When to Use WRITETHRU Files

Windows Vista Network AutoTuning Parameters

Workaround - Failed to Bind SHMEM

WRITETHRU Files