Contents

Copyright Notice FairCom Typographical Conventions System Architecture Positioning the c-tree Server in the System Architecture Single c-tree Server Architecture Multiple c-tree Server Architecture Selecting c-tree Server 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 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 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 File Mirroring When to Use Mirrored Files Creating Mirrored 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 Summary of c-tree Server Features System Implementation and Testing Testing c-tree Server Operation Testing c-tree Server Backup Testing c-tree Server Restore Backing Up and Restoring c-tree Files Determining Files to Include in Backup TRNLOG Files PREIMG Files Non-Transaction Files Server Administration Files Files for Which Backup Is Required Files for Which Backup May Be Required Files That Do Not Require Backup Online Backup Options Dynamic Dump Dumping TRNLOG Files Dumping PREIMG Files Dumping Non-Transaction Files Segmented Dump Stream Files Online Disk Snapshot Offline Backup Options Offline Backup with Server Shut Down Offline Backup with Server Operational c-tree Server Recovery and Restoration Facilities Recovery of TRNLOG Files Using Automatic Recovery Restoring from Dynamic Dump Backup Restoring from Online Disk Snapshot Restoring from Offline Backup Rolling Forward from Backup Rolling Back from Backup Rebuilding Indexes and Compacting Data Files c-tree Server Recovery Checklist Testing c-tree Server Failure System Operation and Support Starting the c-tree Server Initial c-tree Server System Setup c-tree Server Startup Procedure Starting the c-tree Server on Unix Systems Starting the c-tree Server on Windows Systems Safely Copying c-tree Server Controlled Files Shutting Down the c-tree Server Shutting Down the c-tree Server Using the ctadmn Utility Shutting Down the c-tree Server Using the ctstop Utility Shutting Down the c-tree Server for Windows Using the Control Menu Shutting Down the c-tree Server When Run as a Windows Service Shutting Down the c-tree Server Using the StopServer Function Shutting Down the c-tree Server Using System Utilities Emergency c-tree Server Shutdown Using System Utilities Additional c-tree Server Shutdown Details Performing c-tree Server Backup and Recovery Operations Backup Procedures Dynamic Dump Backup Online Disk Snapshot Offline Backup Recovery and Restore Procedures Recovering Using Automatic Recovery Recovering Using Rebuild and Compact Restoring from Dynamic Dump Backup Restoring Using Forward Roll or Rollback Restoring from Online Disk Snapshot Restoring from Offline Backup Verifying the State of the System After Restoration Monitoring the c-tree Server and Its Data Monitoring System Resource Usage Monitoring CPU Usage Monitoring Disk Usage Monitoring Memory Usage Monitoring Network Usage Other System Monitoring Options Monitoring c-tree Server Internal Resource Usage Monitoring c-tree Server Using Snapshot Support Snapshot Configuration File Options Snapshot API Function Options Monitoring c-tree Server Using ctstat Utility Monitoring c-tree Server Using SystemConfiguration API Monitoring c-tree Server Memory Use Monitoring c-tree Server 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-tree Server Transaction Activity Server Configuration Options SnapShot API Options Monitoring c-tree Server File Usage Server Configuration Options SystemConfiguration API Options Monitoring c-tree Server Dynamic Dumps Monitoring c-tree Server Automatic Recovery Monitoring c-tree Server Cache Usage Monitoring c-tree Server Status Log Messages Monitoring c-tree Server Process State c-tree Server Monitoring Checklist c-tree Server Troubleshooting Failures During c-tree Server 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 Failures During c-tree Server 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 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-tree Server 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 ctstat Utility Reference ctstat - Statistics Utility Admin-System Report Example Tivoli-System Report Example Admin-File Report Example Tivoli-File Report Example Admin-User Report Example Function Timing Report Example Text Report Example I/O Time Statisics Example I/O Statisics per File Example Existing Connections Userinfo Example ISAM Statistics Example Enable Function Call Times by File Function call Times by File Example Memory File Usage Example ctsysm Utility Reference c-tree Server Status Log Monitoring Utility ctsysm Configuration File ctsysm Output ctsysm Command-Line Usage Index