Contents

Copyright Notice FairCom Typographical Conventions c-treeACE Server Administrator's Guide Server Quick Start Install Activate Execute Introduction c-treeACE Server Installation c-treeACE Server for Windows Operational Environment Automatic LANA Support Minimum Hardware Requirements c-treeACE Server for Windows Installation Installing the c-treeACE Server Service Installing Multiple Instances of the c-treeACE Server Tool Tray interface c-treeACE Server for Novell Operational Environment Minimum Hardware Requirements c-treeACE Server for Novell Installation Running Multiple NLM Servers on One Machine c-treeACE Server for Mac Operational Environment Minimum Hardware Requirements Mac Server Installation c-treeACE Unix-based Servers Overview Operational Environment Minimum Hardware Requirements c-treeACE Server Unix Installation Native Threads Unix Server Platform Hardware Requirements Hewlett Packard HP-UX IBM AIX Linux QNX and QNX RTP SCO OpenServer / Unixware Solaris - SPARC and Intel Running Multiple c-treeACE Servers on One Machine Windows Service Exception Netware NLM Exception GUI NLM Rename Utility Steps to Run Multiple Servers - Summary Operating the c-treeACE Server Server Memory Calculations Starting c-treeACE the First Time Starting c-treeACE Launching c-treeACE Server companion executable c-treeACE Service for Windows Server 2003/XP/Vista Installing the c-treeACE Service Installing Multiple Instances of c-treeACE Configuring the c-treeACE Service Starting the c-treeACE Service Displaying the current status of the c-treeACE Service Stopping the c-treeACE Service Removing the c-treeACE Service Troubleshooting Tips Problems starting the c-treeACE Service Problems connecting to the c-treeACE Service Problems stopping the c-treeACE Service Start Up Errors Stopping the c-treeACE Server Launching Server companion upon shutdown Server Operational Errors Communications Errors (127/128) 749X 8770 Stack Traces in Case of Critical Error Controlling c-treeACE Server Access Users, Files, Groups, and File Permission Masks Users User ID and Membership in Groups User ID and Ownership of Files User ID and Logon Limits Files Groups Two Kinds of Groups File Permission Masks c-treeACE Server Administrator Utility User Operations Group Definitions File Security Monitor Clients Server Information Server Configuration Stop Server Quiesce Server Monitor Server Activity Informing Users of their Security Options sa_admin - The command line system administrator utility ADMINISTRATOR OPTIONS USER OPTIONS GROUP OPTIONS FILE OPTIONS Dynamic Advanced Encryption Enabling Advanced Encryption Support ctcpvf Utility - Create Master Password Verification File Encrypting Files Using Advanced Encryption Monitoring the c-treeACE Server Performance Monitoring Using the ctstat Utility ctstat - Statistics Utility (emb) 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 Performance Monitoring Using Server Keywords Automatically Logging Performance Snapshots Automatic Logging to the Server System Event Log Automatic Logging to SNAPSHOT.FCS Performance Monitoring Using the SnapShot API SnapShot API Function Usage Automatic Snapshot Support Function Timing Support System Snapshot Support User Snapshot Support File Snapshot Support Combined Snapshot Support Snapshot Contents System Snapshot Structure User Snapshot Structure File Snapshot Structure SQL Snapshot Structure Function Timing c-treeACE Server Status Monitoring Utility, ctsysm Using the ctsysm Utility ctsysm Configuration File ctsysm Configuration File Sample Maintaining Database Integrity c-treeACE Server Files Automatic Recovery Dynamic Dump ctdump - Dynamic Dump Utility Script File for Defining Dynamic Dump Format Dynamic Dump Options Sample Script Scheduling a Dynamic Dump Using the Script Killing a Dynamic Dump Dump To Multiple Files - No Size Limit Segmented Dynamic Dump Wildcard Support for File Names Dump Files Without Transaction Control Non-ctree Files Included in a Dynamic Dump Automatic Restore of a Dynamic Dump for “Ready-to-Go” Files Dump Progress Messages Displayed in Function Monitor Files NOT to Include in the Dynamic Dump Dynamic Dump Recovery Additional Keywords for Recovery Script Running the Recovery Utility Define Alternative Restore Destinations System Rollback Script File for Rollback Running the Rollback Utility System Roll Forward Rolling Forward from Dynamic Dump Preparing for Using the Forward Dump Utility Running the Forward Dump Utility for System Recovery Transaction Log Dump Options for Transaction Log Dump Running a Transaction Log Dump Copying c-treeACE Server Controlled Files Server Unique File Detection - NetWork/Remote/UNC file names Configuring the c-treeACE Server Configuration File Format Running a Configuration Script File Scaling Factors for Configuration Keyword Values Alternative Configuration Methods Settings File Environment Variables for Configuration Server Command Line Parameters Basic Configuration Options COMMENTS CONNECTIONS or USERS DAT_MEMORY DUMP FILES IDX_MEMORY MAX_DAT_KEY MAX_KEY_SEG SERVER_NAME SERVER_PORT Advanced Configuration Options ADMIN_ENCRYPT ADMIN_MIRROR ADVANCED_ENCRYPTION APP_NAME_LIST AUTO_LOCK_RETRY AUTO_LOCK_RETRY_SLEEP AUTO_PREIMG AUTO_TRNLOG AUTO_TRNLOG_LIGHT BLOCKING_LOCK_TIMEOUT_SEC BROADCAST_DATA BROADCAST_INTERVAL BROADCAST_PORT BUFBLK_RATIO BUFFER_RUNLENGTH BUFR_MEMORY CACHE_LINE CHECKPOINT_FLUSH CHECKPOINT_IDLE CHECKPOINT_INTERVAL CHECKPOINT_MONITOR CHKPDFC_LOG_LIMIT COMM_PROTOCOL COMMIT_DELAY COMMIT_DELAY_BASE COMMIT_DELAY_SCALE COMMIT_DELAY_USEC COMMIT_LOCK_DEFER_MS CONSOLE CTRL_C_ENABLE CONSOLE NO_MESSAGEBOX CONSOLE NO_PWRDWNPASSWORD CONSOLE NO_SHUTDOWN_PROMPT CONSOLE TOOL_TRAY CONSOLE W9X_SERVICE CPU_AFFINITY CTSRVR_CFG CTSTATUS_MASK CTSTATUS_SIZE DATA_LRU_LISTS DEAD_CLIENT_INTERVAL DEADLOCK_MONITOR DEFAULT_CHANNELS DISK_FULL_LIMIT DISK_FULL_VOLUME DNODEQ_SHUTDOWN_LIMIT ADVANCED_ENCRYPTION FILE_CREATE_MODE FILE _HANDLES FILE_PERMISSIONS FIXED_LOG_SIZE FORCE_LOGIDX FUNCTION_MONITOR GUEST_LOGON GUEST_MEMORY HUGE_TO_SEG_MB IDLE_NONTRANFLUSH and IDLE_TRANFLUSH INHERIT_FILE_PERMISSIONS INDEX_LRU_LISTS ITIM_RETRY_DEFER ITIM_RETRY_LIMIT KEEP_LOGS LIST_MEMORY LOCAL_DIRECTORY LOCK_HASH LOCK_MONITOR LOG_ENCRYPT LOG_EVEN LOG_EVEN_MIRROR LOG_ODD LOG_ODD_MIRROR LOG_PAGE_SIZE LOG_SPACE LOG_TEMPLATES LOGON_FAIL_LIMIT LOGON_FAIL_TIME LOGON_MUST_TIME MATCHING_SEGMENT MAX_FILES_PER_USER MAX_HANDLES MAX_K_TO_USE MAX_USER_LOGS MAX_USER_LOG_ENTRY_BYTES MAX_VIRTUAL_FILES MEMORY_FILE MEMORY_MONITOR MEMORY_TRACK MIRROR_DIRECTORY MIRRORS MONITOR_MASK and MATCH_FILE_ID MPAGE_CACHE NO_CACHE NO_SHUTDOWN_FLUSH NODE_DELAY NODEQ_SEARCH NONMATCHING_SEGMENT NULL_STRING PAGE_SIZE PREIMAGE_DUMP PREIMAGE_FILE PREIMAGE_HASH PRIME_CACHE and PRIME_INDEX PRIME_CACHE_BY_KEY RECOVER_DETAILS RECOVER_FILES RECOVER_MEMLOG SEMAPHORE_BLK SERVER_DIRECTORY SESSION_TIMEOUT SET_FILE_CHANNELS SIGNAL_DOWN SIGNAL_READY SKIP_MISSING_FILES SKIP_MISSING_LOG_MIRRORS SKIP_MISSING_MIRRORS SNAPSHOT_FILENAME SNAPSHOT_INTERVAL SNAPSHOT_LOCKWAIT_USEC SNAPSHOT_TRANTIME_USEC SNAPSHOT_USERID SORT_MEMORY SPECIAL_CACHE_FILE SPECIAL_CACHE_PERCENT START_EVEN START_EVEN_MIRROR START_ODD START_ODD_MIRROR STARTUP_BLOCK_LOGONS SUPPRESS_LOG_FLUSH TASKER_SLEEP TMPNAME_PATH TOT_MEMORY TRAN_TIMEOUT TRANSACTION_FLUSH SIGNAL_READY SIGNAL_READY USR_MEM_RULE USR_MEMORY Compatibility Keywords COMPATIBILITY 6BTRAN_NOT_DEFAULT COMPATIBILITY ABORT_ON_CLOSE COMPATIBILITY ADMIN_STOP COMPATIBILITY BLOCK_DDSFM_CREATE and BLOCK_DDSFM_DELETE COMPATIBILITY CHAR_SCHSEG COMPATIBILITY DIRECT_IO COMPATIBILITY EXACT_FILE_NAMES COMPATIBILITY EXTENDED_TRAN_ONLY COMPATIBILITY FORCE_WRITETHRU COMPATIBILITY FAILED_TRAN_IO COMPATIBILITY LARGE_CACHE COMPATIBILITY LOG_WRITETHRU COMPATIBILITY PREV610A_FLUSH COMPATIBILITY PUTHDR_COMMIT COMPATIBILITY NLM_DEFER_THREADSWITH COMPATIBILITY NLM_LONG_FILENAMES COMPATIBILITY NO_BLOCK_KILL COMPATIBILITY NO_CHKMBRNAMLEN COMPATIBILITY NO_COMMIT_READ_LOCK COMPATIBILITY NO_SHUTDOWN_DELAY COMPATIBILITY NO_SPCMGT_QUEUE COMPATIBILITY NO_SYS_FLUSH_ON_CLOSE COMPATIBILITY NO_TEST_LOCAL COMPATIBILITY NO_UNIQFILE COMPATIBILITY NO_VARLEN_TRAN_UNUSED COMPATIBILITY NONADMIN_FILBLK COMPATIBILITY NONADMIN_QUIET COMPATIBILITY NONADMIN_QUIET COMPATIBILITY NON_ADMIN_SHUTDOWN COMPATIBILITY REVERT_TO_V6HDR COMPATIBILITY SYNC_LOG COMPATIBILITY TCPIP_CHECK_DEAD_CLIENTS COMPATIBILITY TDATA_WRITETHRU COMPATIBILITY TINDEX_WRITETHRU COMPATIBILITY TEMP_INDEX_ERROR COMPATIBILITY WTHRU_UPDFLG Diagnostics Keywords DIAGNOSTICS AUTO_PREIMG_CHECKLOCK / AUTO_PREIMG_CHECKREAD DIAGNOSTICS AUTO_TRNLOG_CHECKLOCK / AUTO_TRNLOG_CHECKREAD DIAGNOSTICS DLOK_ERR DIAGNOSTICS DYNDUMP_LOG DIAGNOSTICS EXTENDED_TRAN_NO DIAGNOSTICS FILE_LOGON DIAGNOSTIC_INT DIAGNOSTICS L59 DIAGNOSTICS LOCK_DUMP DIAGNOSTICS LOCK_LOGON DIAGNOSTICS LOWL_FILE_IO DIAGNOSTICS NO_EXCEPTION_HANDLER DIAGNOSTICS QUEUE_LOGON DIAGNOSTICS REMAINING_THREADS DIAGNOSTICS SHUTDOWN_COMM DIAGNOSTICS SNAPSHOT_AUTOMATIC DIAGNOSTICS SNAPSHOT_IOTIME DIAGNOSTICS SNAPSHOT_INTERMEDIATE DIAGNOSTICS SNAPSHOT_SHUTDOWN DIAGNOSTICS SNAPSHOT_WRKTIME DIAGNOSTIC_STR DIAGNOSTICS TRACK_LOGON DIAGNOSTICS TRAP_COMM DIAGNOSTICS UPDFLG DIAGNOSTICS WRITETHRU DIAGNOSTICS WRITE_ERR_DUMP Server System Event Log Keywords Automatic Segmented File Support Flexible I/O Channel Usage Detection of Transaction Log Incompatibilities Options for Faster Auto-Recovery Performance Optimizations for Advanced Applications I/O caching Fastest Platform Communication Protocol Transaction Processing Transaction Control Background Transaction Options Transaction Log Flush Delay Transaction Group Commit (Commit Delay) Commit Delay Operational Details Commit Delay Enhancements Enabling Transaction Commit Delay Reduced Flushing of Updated Data and Index Cache Pages Using the TRANSACTION_FLUSH Server Keyword Using the CHECKPOINT_FLUSH Server Keyword Improved Log Flushing Strategy Improving Checkpoint Efficiency Increasing the Interval Between Checkpoints Templates for Efficient Transaction Log Creation Enabling Log Templates More Efficient Flushing of Files Efficient Single Savepoint for Large Transactions Deferred Flush of Transaction Begin TCP/IP Broadcast Support Extended Transaction Number Support Extended Transaction Number Support Configurable Extended Transaction Number Options User's Control of Security Options The User’s Password File Security Controls Overview of the c-treeACE Server Client/Server Computing Transaction Processing Heterogeneous Server Network Support File Mirroring Encryption Glossary Index