c-treeEDGE MicroServer

 
c-treeEDGE IoT Database Administrator's Guide
Server Quick Start
Introduction
Advanced c-treeEDGE MicroServer Features
Client/Server Computing
c-treeEDGE MicroServer Installation
License Authorization File
Installing the c-treeEDGE MicroServer on Your Operating System
c-treeEDGE MicroServer for Windows
Operational Environment
Minimum Hardware Requirements for c-treeEDGE for Windows
c-treeEDGE MicroServer for Windows Installation
Installing as a Windows Service
Configuring the c-treeEDGE Service
Starting the c-treeEDGE Service
Displaying the current status of the c-treeEDGE Service
Stopping the c-treeEDGE Service
Removing the c-treeEDGE Service
Service Troubleshooting Tips
Problems starting the c-treeEDGE Service
Problems connecting to the c-treeEDGE Service
Problems stopping the c-treeEDGE Service
Tool Tray Interface
c-treeEDGE Unix-based Servers
Supported Platforms - c-treeEDGE MicroServer
Minimum Hardware Requirements
Linux
c-treeEDGE MicroServer Unix Installation
Configuring Unix-based Systems
Shared Memory Client-Server Communication for Unix/Linux
c-treeEDGE MicroServer - Unix version logs message when shared memory can’t create semaphore or segment
Other Possible Shared Memory Messages
Specify Shared Memory Keys on Unix
Use of Domain Sockets for Faster Unix/Linux Shared Memory Connections
System Group Assignment of Unix/Linux Shared Memory resources
Multiple c-treeEDGE MicroServers on One Machine
TCP/IP Broadcast Support
Heterogeneous Server Network Support
c-treeEDGE MicroServer Basic Operations
Starting c-treeEDGE the First Time
Starting the c-treeEDGE MicroServer
Start Up Errors
Launching c-treeEDGE Server companion executable
Stopping the c-treeEDGE MicroServer
Launching Server companion upon shutdown
Server Operational Errors
Windows Resource Error (1450) Configurable Retry Logic
I/O Block Sizes with Windows Systems
Communications Errors (127/128)
8770
Server Memory Calculations
Stack Traces in Case of Critical Error
c-treeEDGE Access Configuration
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
Informing Users of their Security Options
Dynamic Advanced Encryption
Enabling Advanced Encryption Support
Encrypting Files Using Advanced Encryption
Changing the Master Password
User's Control of Security Options
The User's Password
File Security Controls
Administrator Utilities
c-treeEDGE MicroServer Administrator Utility
User Operations
Group Definitions
File Security
Monitor Clients
Server Information
Server Configuration
Stop Server
Quiesce Server
ctadmn utility checks for active transactions before quiescing c-treeEDGE MicroServer
Monitor Server Activity
Change Server Settings
ctstop - Server Stop Utility
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 Statistics Example
I/O Statistics 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
Transaction Statistics Example
File and User Lock Example
Memory Use and Allocation Call Stacks Example
sa_admin - Command-line security administration utility
ADMINISTRATOR OPTIONS
USER OPTIONS
GROUP OPTIONS
FILE OPTIONS
ctpass - Password Utility
ctquiet - Quiesce c-treeEDGE Utility
ctfilblkif - File Block Utility
ctdump - Schedule a Dynamic Dump
ctrdmp - Dynamic Dump Recovery or System Rollback
Rollback to New Restore Points with ctrdmp
ctrdmp options to convert path separators to operating system's native path separator
ctfdmp - Forward Dump Utility
ctcpvf - Master Password Verification File Utility
Advanced encryption master key store encrypted at system level on Windows
ctencrypt - Utility to Change Master Password
ctvfyidx - Index Verify Utility
ctvfyfil - File Verify Utility
Backups and Data Integrity
c-treeEDGE MicroServer Files
Copying c-treeEDGE MicroServer Controlled Files
Server Unique File Detection - NetWork/Remote/UNC file names
Automatic Recovery
Recovery in Alternate Locations with REDIRECT
Options for Faster Auto-Recovery
Dynamic Dump
Scheduling a Dynamic Dump
ctdump - Dynamic Dump Utility
Scripting a Dynamic Dump
Dynamic Dump Options
Dynamic Dump Script File
!BLOCK_RETURN
!COMMENT
!COPY_NONCTREE
!DATE <mm/dd/yyyy>
!DAY <day of week>
!DELAY <seconds>
!DIAGNOSTICS TRAN_RECOVERY
!DUMP <dump file>
!END
!ENDSEGMENT
!EXT_SIZE <bytes | NO>
!FILES
Wildcard Support for File Names
Files NOT to Include in Your Dynamic Dump Backup
!FREQ <hours>
!IMMEDIATE_RESTORE
!IMMEDIATE_RESTORE_LOGFILE
!IMMEDIATE_RESTORE_WITH_PROGRESS
!NONCTREEFILES
!PROTECT and !PROTECT_LOW
!RECOVER_DETAILS
!RECOVER_MEMLOG
!RECURSE <YES | NO | MATCH_SUBDIR>
!SEGMENT
!TIME <hh:mm:ss>
Dynamic Dump callback event notifications during immediate restore
Dynamic Dump now stops when client callback function returns an error
Dynamic Dump status and error messages
Enable Replication During Dynamic Dump Hot Backups
c-tree Files to Include in a Dynamic Dump
Dynamic Dump Defer to Improve Overall I/O Performance
Dynamic Dump Defer Interval for Improved Backup Performance
Non-ctree Files Included in a Dynamic Dump
Dump Files Without Transaction Control
Automatic Restore of a Dynamic Dump for Files That Are Ready-to-Use
Dump To Multiple Files - No Size Limit
Segmented Dynamic Dump
Mirrored File Backups
Dump Progress Messages Displayed in Function Monitor
Mask Routine Dynamic Dump Messages in CTSTATUS.FCS
Killing a Dynamic Dump
Dynamic Dump Recovery
Running the Recovery Utility
ctrdmp - Dynamic Dump Recovery or System Rollback
Recovery Script Options
!CLNIDXX
!DELETE
!#FCB <number of files>
!FORWARD_ROLL
!PAGE_SIZE <bytes per buffer>
!REDIRECT <old path> <new path>
!SKIP
Define Alternative Restore Destinations
Transaction Dependent Files
System Rollback
Running the Rollback Utility
Script File for Rollback
!COMMENT
!DATE <mm/dd/yyyy>
!#FCB <number of files>
!FILES
!ROLLBACK
!SKIP
!TIME <hh:mm:ss>
Rolling Forward from Backup
Forward Roll File Redirection
Transaction Log Dump
Options for Transaction Log Dump
Running a Transaction Log Dump
ctldmp option to create transaction start files from checkpoints in transaction log files
Controls for Performance AND Safety of Non-Transaction Updates
Checkpoint Requirements
Monitoring c-treeEDGE
Performance Monitoring Using the ctstat Utility
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
c-treeEDGE MicroServer Status Monitoring Utility, ctsysm
Using the ctsysm Utility
ctsysm Configuration File
ctsysm Configuration File Sample
Server System Event Log Keywords
Performance Optimization
Options for Advanced Applications
I/O caching
Fastest Platform
Communication Protocol
Flexible I/O Channel Usage
Transaction Control Options
Transaction Options
Transaction Commit Delay
Commit Delay Operational Details
Enabling Transaction Commit Delay
Reduced Flushing of Updated Cache Pages
Transaction Flushing
Checkpoint Flushing
Improved Log Flush Strategy
Checkpoint Efficiency
Increasing the Interval Between Checkpoints
Transaction Log Templates
Log Template Configuration
Efficient Transaction Log Template Copies
Efficient Flushing of Transaction Controlled Files
Extended Transaction Number Support
Extended Transaction Number Support
Configurable Extended Transaction Number Options
Configurable Transaction Number Overflow Warning Limit
Efficient Single Savepoint for Large Transactions
Deferred Flush of Transaction Begin
Detection of Transaction Log Incompatibilities
Configuring c-treeEDGE
c-treeEDGE Configuration File
Configuration flexibility with environment variables
c-treeEDGE Standard Wildcards
Scaling Factors for Configuration Keyword Values
Alternative Configuration Methods
Settings File
Environment Variables
Command-Line Parameters
c-treeEDGE Configuration Options
Basic Keywords
COMMENTS
COMM_PROTOCOL
Shared Memory Protocol - c-treeEDGE
Shared Memory Resource Considerations
CONNECTIONS or USERS
CPU_AFFINITY
DAT_MEMORY
DUMP
FILES
Improved File Descriptor Limit Messages Logged During Server Startup
Server Now Fails to Start if File Descriptor Limit Can't be Increased to Required Value
Message Written to Standard Output When File Descriptor Limit is too Low
New file descriptor limit compatibility keyword
GUEST_LOGON
IDX_MEMORY
LOCAL_DIRECTORY
MAX_DAT_KEY
MAX_KEY_SEG
PAGE_SIZE
SERVER_NAME
SERVER_PORT
Client Communication Keywords
DEAD_CLIENT_INTERVAL
MAX_CONCURRENT_USER_ACCOUNTS
MAX_CONNECTIONS_PER_USER_ACCOUNT
MAX_ISAM_CONNECTIONS
MAX_SQL_CONNECTIONS
TCP/IP
BROADCAST_DATA
BROADCAST_INTERVAL
BROADCAST_PORT
SESSION_TIMEOUT
Shared Memory
SEMAPHORE_BLK
SHMEM_DIRECTORY
SHMEM_GROUP
SHMEM_PERMISSIONS
LDAP
ADMIN_USER_GROUP
GUEST_USER_GROUP
LDAP_BASE
LDAP_SERVER
LDAP_TIMEOUT
LOGIN_ALLOWED_GROUP
DIAGNOSTICS TRAP_COMM
Startup and Shutdown Keywords
APP_NAME_LIST
CACHE_LINE
CHECK_CONFIG
COMPATIBILITY NO_EXTERNAL_SHUTDOWN
CONSOLE CTRL_C_ENABLE
CONSOLE NO_MESSAGEBOX
CONSOLE NO_PWRDWNPASSWORD
CONSOLE NO_SHUTDOWN_PROMPT
CONSOLE TOOL_TRAY
CONSOLE W9X_SERVICE
CTSRVR_CFG
DNODEQ_SHUTDOWN_LIMIT
NO_SHUTDOWN_FLUSH
PROCESS_PRIORITY
PROCESS_EXIT_COMMAND
SIGNAL_DOWN
SIGNAL_READY
WAIT_ON_SHUTDOWN_SEC
DIAGNOSTICS FULL_DUMP
DIAGNOSTICS SHUTDOWN_COMM
Cache and Memory Keywords
BUFBLK_RATIO
BUFFER_RUNLENGTH
BUFR_MEMORY
COMPATIBILITY LARGE_CACHE
DATA_LRU_LISTS
GUEST_MEMORY
INDEX_LRU_LISTS
LIST_MEMORY
LMT_MEMORY - c-treeEDGE
MEMORY_HASH
MPAGE_CACHE
NO_CACHE
NONTRAN_FILESYS_FLUSH_OFF
PRIME_CACHE and PRIME_INDEX
PRIME_CACHE_BY_KEY
SORT_MEMORY
SPECIAL_CACHE_FILE
SPECIAL_CACHE_PERCENT
TOT_MEMORY
USR_MEM_RULE
USR_MEMORY
Transaction Processing Keywords
AUTO_PREIMG
AUTO_TRNLOG
AUTO_TRNLOG_LIGHT
CHECKPOINT_FLUSH
CHECKPOINT_IDLE
CHECKPOINT_INTERVAL
CHECKPOINT_PREVIOUS
CHKPDFC_LOG_LIMIT
COMMIT_DELAY
COMMIT_DELAY_BASE
COMMIT_DELAY_SCALE
COMMIT_DELAY_USEC
COMMIT_LOCK_DEFER_MS
COMPATIBILITY LOG_WRITETHRU
COMPATIBILITY TDATA_WRITETHRU
COMPATIBILITY TINDEX_WRITETHRU
COMPATIBILITY LOCK_EXCL_TRAN
DELAYED_DURABILITY
DELSTK_COMMIT_SEC
FIXED_LOG_SIZE
FORCE_LOGIDX
KEEP_LOGS
KEEP_RESTORE_POINTS
LOG_COMPRESSION_FACTOR
LOG_COMPRESSION_THRESHOLD
LOG_EVEN
LOG_ODD
LOG_PAGE_SIZE
LOG_SPACE
LOG_TEMPLATE
LOG_TEMPLATE_COPY_SLEEP_PCT
LOG_TEMPLATE_COPY_SLEEP_TIME
LONG_TRANSACTION_MS
MAX_USER_LOG_ENTRY_BYTES
MAX_USER_LOGS
PREIMAGE_FILE
START_EVEN
START_ODD
SUPPRESS_LOG_FLUSH
SUPPRESS_LOG_SYNC
TRAN_HIGH_MARK
TRAN_OVERFLOW_THRESHOLD
TRAN_TIMEOUT
TRANSACTION_FLUSH
UNBUFFERED_LOG_IO
Recovery Keywords
RECOVER_DETAILS
RECOVER_FILES
RECOVER_MEMLOG
RECOVER_TO_RESTORE_POINT
RECOVER_SKIPCLEAN
REDIRECT
REDIRECT_IFIL
SKIP_INACCESSIBLE_FILES
SKIP_MISSING_FILES
TRANIDX_LOPN_ERR_CONTINUE
File Management Keywords
AUTO_CLNIDXX
AUTO_MKDIR
CMPREC_TYPE
COALESCE_TRNLOG
COMPRESS_FILE
FILE_CREATE_MODE
FILE_HANDLES
FILE_PERMISSIONS
HUGE_TO_SEG_MB
INHERIT_FILE_PERMISSIONS
KEEPOPEN_CLOSE_RETRY_LIMIT
KEEPOPEN_LIST - c-treeEDGE
MATCHING_SEGMENT
MAX_DFRIDX_LOGS
Transaction log limit for replication and deferred indexing
MAX_FILES_PER_USER
Maximum Index Members per File (MAXMEMB)
MAX_REBUILD_QUEUE
MAX_VIRTUAL_FILES
MEMFILE_MAX_BINS
MEMORY_FILE
NONMATCHING_SEGMENT
SPLIT_NBR_OF_FILES
TMPNAME_PATH
DIAGNOSTICS PTADMIN
Lock Keywords
AUTO_LOCK_RETRY
AUTO_LOCK_RETRY_SLEEP
BLOCKING_LOCK_TIMEOUT_SEC
CHECKLOCK_FILE
ITIM_RETRY_DEFER
ITIM_RETRY_LIMIT
DIAGNOSTICS DLOK_ERR
DIAGNOSTICS LOCK_DUMP
I/O Keywords
COMPATIBILITY DIRECT_IO
COMPATIBILITY FDATASYNC
COMPATIBILITY FORCE_WRITETHRU
COMPATIBILITY PREV610A_FLUSH
COMPATIBILITY WTHRU_UPDFLG
DEFAULT_CHANNELS
IO_BLOCK_SIZE
IO_ERROR_BLOCK_RETRY
IO_ERROR_BLOCK_SIZE
IO_ERROR_BLOCK_SLEEP
SET_FILE_CHANNELS
UNBUFFERED_IO
DIAGNOSTICS DIRECT_IO
DIAGNOSTICS LOWL_FILE_IO
NONTRAN_DATA_FLUSH_SEC
NONTRAN_INDEX_FLUSH_SEC
TRAN_DATA_FLUSH_SEC
TRAN_INDEX_FLUSH_SEC
Logging and Monitoring Keywords
CHECKPOINT_MONITOR
CTSTATUS_MASK
CTSTATUS_SIZE
DBENGINE_CHECK
DEADLOCK_MONITOR
DISK_FULL_ACTION
DISK_FULL_ACTION Script
DISK_FULL_LIMIT
DISK_FULL_VOLUME
FUNCTION_MONITOR
LOCK_MONITOR
MEMORY_MONITOR
MEMORY_TRACK
MONITOR_MASK
PERF_MONITOR
REQUEST_TIME_MONITOR
SNAPSHOT_FILENAME
SNAPSHOT_INTERVAL
SNAPSHOT_LOCKWAIT_USEC
SNAPSHOT_TRANTIME_USEC
SNAPSHOT_USERID
SYSLOG
SYSVIEW_WHAT
SYSVIEW_WHEN
DIAGNOSTICS SNAPSHOT_AUTOMATIC
DIAGNOSTICS SNAPSHOT_IOTIME
DIAGNOSTICS SNAPSHOT_SHUTDOWN
DIAGNOSTICS SNAPSHOT_WORKTIME
Security Keywords
ADMIN_ENCRYPT
ADVANCED_ENCRYPTION
ALLOW_MASTER_KEY_CHANGE
CHANGE_ENCRYPTION_ON_COMPACT
COMPATIBILITY NO_COMMAND_LINE
COMPATIBILITY NO_CONFIG_FILE
COMPATIBILITY NONADMIN_FILBLK
COMPATIBILITY NONADMIN_QUIET
COMPATIBILITY NONADMIN_TRANSFER_FILE
COMPATIBILITY NON_ADMIN_SHUTDOWN
ENABLE_TRANSFER_FILE_API
FILEDEF_SECURITY_LEVEL
LOG_ENCRYPT
LOGON_FAIL_LIMIT
LOGON_FAIL_TIME
LOGON_MUST_TIME
MASTER_KEY_FILE
NULL_STRING
STARTUP_BLOCK_LOGONS
Backup Keywords
DYNAMIC_DUMP_DEFER
DYNAMIC_DUMP_DEFER_INTERVAL
DYNAMIC_DUMP_SYNC_INTERVAL
PERMIT_NONTRAN_DUMP
PREIMAGE_DUMP
VSS_WRITER
DIAGNOSTICS DYNDUMP_LOG
DIAGNOSTICS VSS_WRITER
Replication Keywords
Auto-Numbering Replication Defaults Changed
MAX_REPL_LOGS
REPLICATE
REPL_IDENTITY_USE_MASTER
REPL_IDENTITY_USE_SOURCE
REPL_MAPPINGS
REPL_NODEID
REPL_READ_BUFFER_SIZE
REPL_SRLSEG_ALLOW_UNQKEY
REPL_SRLSEG_USE_MASTER
REPL_SRLSEG_USE_SOURCE
DIAGNOSTICS REPLICATE
Unicode Keywords
ICU_LOCALE
ICU_OPTION
LANGUAGE
XTDKSEG_SEG_TYPE
XTDKSEG_SRC_TYPE
XTDKSEG_SRC_SIZE
XTDKSEG_FAILED_DEFAULT_OK
Mirroring Keywords
ADMIN_MIRROR
LOG_EVEN_MIRROR
LOG_ODD_MIRROR
MIRROR_DIRECTORY
MIRRORS
SKIP_MISSING_LOG_MIRRORS
SKIP_MISSING_MIRRORS
START_EVEN_MIRROR
START_ODD_MIRROR
Advanced Configuration Keywords
CONTEXT_HASH
CRITICAL_SECTION_SPIN
DH_THREAD_STACK_SZ_KB
DIST_COUNT_SEC
LATCH_SLEEP
LATCH_SPIN
LOCK_HASH
MAX_FILE_WAIT_SECS
MAX_HANDLES
MAX_K_TO_USE
NODE_DELAY
NODEQ_SEARCH
PARTITION_ESTIMATE_LIMIT
PREIMAGE_HASH
PRESYNC_THRESHOLD
SERVER_DIRECTORY
SESSCHG_ENABLE
SETENV
SKIP_CTADDWORK
SUBSYSTEM SQL LATTE
SYNC_DELAY
TASKER_SLEEP
UDEFER_64YIELD_USEC
UDEFER_THRESHOLD_USEC
VLEN_ERR_RETRY_LIMIT
Diagnostics Keywords
DIAGNOSTIC_INT
DIAGNOSTIC_STR
DIAGNOSTICS ABEND_ABORT
DIAGNOSTICS ABORT_NODE_LIST
DIAGNOSTICS AUTO_PREIMG_CHECKLOCK / AUTO_PREIMG_CHECKREAD
DIAGNOSTICS AUTO_TRNLOG_CHECKLOCK / AUTO_TRNLOG_CHECKREAD
DIAGNOSTICS CHECK_UDEFER
DIAGNOSTICS COMM_LEVEL_X
DIAGNOSTICS DADV_ERR
DIAGNOSTICS DBGSEMTIM
DIAGNOSTICS DEBUG
DIAGNOSTICS EXTENDED_TRAN_NO
DIAGNOSTICS FILE_LOGON
DIAGNOSTICS FLUSH_BLM
DIAGNOSTICS FORCEI_SHADOWUPD
DIAGNOSTICS KEY_COMPARE
DIAGNOSTICS KLLX
DIAGNOSTICS L59
DIAGNOSTICS LOCK_LOGON
DIAGNOSTICS LOGON_COMM
DIAGNOSTICS LOWL_CRC_ON
DIAGNOSTICS MEMORY_LEAK
DIAGNOSTICS MEMTRACK
DIAGNOSTICS NO_EXCEPTION_HANDLER
DIAGNOSTICS NO_LOG_EXTENSION
DIAGNOSTICS NODE_REQUEST_TIME
DIAGNOSTICS NODEQ_MESSAGE
DIAGNOSTICS NONE
DIAGNOSTICS PCRP_ERR
DIAGNOSTICS PROCESS_EXIT
DIAGNOSTICS QUEUE_LOGON
DIAGNOSTICS READ_ERR
DIAGNOSTICS REMAINING_THREADS
DIAGNOSTICS REPL_READ_BUFFER
DIAGNOSTICS SUBALLOCATOR_OFF
DIAGNOSTICS THREAD_DUMP
DIAGNOSTICS TR_TRAN_ERR
DIAGNOSTICS TRACK_LOGON
DIAGNOSTICS TRAN_RECOVERY
DIAGNOSTICS TREE_WALK
DIAGNOSTICS UNOD_ERR
DIAGNOSTICS UPDFLG
DIAGNOSTICS WRITE_ERR_DUMP
DIAGNOSTICS WRITETHRU
Custom Server SDK Keywords
JOB_QUEUE_INFO
SERVER_SDK
USER_SIGNAL_DOWN
USER_SIGNAL_READY
DIAGNOSTICS CTUSER_ERROR
DIAGNOSTICS CTUSER_VERBOSE
DIAGNOSTICS CUSTOM
Glossary
Copyright Notice
Index