The c-treeACE Information Utility, ctinfo, is a valuable tool to examine many c-tree data and index file attributes. Several enhancements were applied to the c-tree IFIL and DODA extraction utility,
ctinfo.
List all files open by c-treeACE.
List all files open by a particular connection.
List connections that have a particular file open.
List locks held on a particular file.
Display 64-bit logical and physical file sizes.
Output individual extended file mode attributes.
The -rdkeys option has been enhanced to properly handle HUGE files.
Now opens the specified file in shared read-only mode.
Display complete XCREblk information.
Index
1
127 ... 80 128 ... 80 160 ... 535
530 ... 197
745 ... 198
808 ... 80 809 ... 80 827 ... 48A
Access a c-treeACE Connection Created by Another Thread ... 79Additional c-treeACE SQL Interfaces ... 55
Additional c-treeACE SQL Table Import Utility Options ... 87
Additional c-treeDB and c-treeDB.NET Features and Improvements ... 13
Additional ORDER BY Clause Usage ... 43
Additional Scalar Functions Available ... 41
Additional Search Options for c-treeACE SQL LONG Field Types ... 41
Additional Security Administrator Functions ... 80
Additional SETOPS Modes ... 81
Additional SNAPSHOT Options ... 50
Addressing the issue ... 22
Administrators Can Now Define the c-treeACE Port Number ... 47
Advanced Cache Alternative for Scanning Data Files ... 78
Advanced Commit Delay Options ... 52
Advanced Encryption for c-treeACE SQL Tables ... 40
Advanced Functions for the c-treeACE SDK .... 14, 77 Advanced Searching with CONTAINS Clause and LVARCHAR Fields ... 41
AIX ... 52
ARQS_ERR ... 80
ARSP_ERR ... 80
Assignment of Default File Permissions to User Groups ... 52
Attach and Detach Existing Sessions ... 61
Attach and Detach Existing Sessions to c-treeDB . 70 Attach and Detach Open Tables to c-treeDB ... 71
Attach and Detach Tables ... 61
Automatic Shared Memory Protocol for Local Connections on Windows ... 50
Automatic Transaction Processing for non-TRANPROC files ... 49
B
backups ... See Dynamic Dump Backward Compatibility Changes with c-treeSQL Databases ... 21batches ... 65
Batches for c-treeDB... 60, 65 Block Access to Files ... 77
block files ... 77, See ctFILBLK blocking lock timeout ... 48
Blocking Lock Timeout ... 48
Blocking Lock Timeouts ... 77
C
Cache ... 49, 78 Callback Support in c-treeDB ... 67callbacks ... 49, 67, 78, See ctFileCloseCallback, See ctFileOpenCallback, See ctFileCreateCallback Change Configuration Options at Run Time ... 51
commit delay ... 52
Commit Read Locks... 49
Commit Read Locks for Guaranteed Data Reads . 49 compact ... 81, See CompactIFile Compact Function Now Supports Duplicate Key Purge and Update IFIL Options ... 81
compatibility issues ... 15, 19, 20, 21 Compatibility Notes ... 19
Complete RIGHT OUTER JOIN Syntax ... 42
Configuration Keywords ... 50 AUTO_PREIMG ... 49 AUTO_TRNLOG ... 49 BLOCKING_LOCK_TIMEOUT_SEC ... 48 COMM_PROTOCOL DISABLE ... 50 COMMIT_DELAY_BASE ... 52 COMMIT_DELAY_SCALE ... 52 COMPATIBILITY COMMIT_READ_LOCK ... 49 COMPATIBILITY LOG_WRITETHRU ... 21 COMPATIBILITY REVERT_TO_V6HDR ... 19 COMPATIBILITY SYNC_LOG ... 21 CPU_AFFINITY ... 47 DIAGNOSTICS SNAPSHOT_IOTIME ... 50 DIAGNOSTICS SNAPSHOT_WRKTIME ... 50 FILE_CREATE_MODE ... 53 FILE_PERMISSIONS ... 52 LOG_WRITETHRU ... 21 PAGE_SIZE ... 41, 80 PRIME_CACHE_BY_KEY ... 49 SERVER_NAME ... 47 SERVER_PORT ... 47 SNAPSHOT_LOCKWAIT_USEC ... 51 SNAPSHOT_TRANTIME_USEC ... 51
SQL_OPTION ... 21
TMPNAME_PATH ... 81
TRAN_TIMEOUT ... 48
Copy a Database with the c-treeACE SQL Maintenance Utility ... 43
CPU_AFFINITY ... 47
ctFILBLK ... 77
ctoption ... 41
ctQUIET ... 45, See ctFILBLK c-tree Information Utility Enhancements... 88
c-treeACE API .... See GETFIL, See GetCtFileInfo, See SETOPS, See RebuildIFile, See CompactIFile, See ctLOKDMP, See ctFILWCD, See LOKREC, See LKISAM, See PUTHDR, See NXTVREC, See NXTREC, See SetDataFilter, See SA_WILDCARD, See SA_ERRMSG, See ReWritePartialRecord, See LockList, See FindFileByName, See ctUPDICU, See ctSQLImportTable, See ctSetOWNER, See ctQUIET, See ctfiltercb_rowl, See ctFILMTX, See ctFILBLK, See ctdbEstimateSpan, See ctdbNumberOfKeyEntries, See ESTKEY, See NbrOfKeyEntries, See CurrentISAMKey, See ctFileCloseCallback, See ctFileOpenCallback, See ctFileCreateCallback, See SetSystemConfigurationOption, See TRANEND, See TRANBEG, See ctSNAPSHOT, See SetCallbackOnRebuild, See ctLOKTIMOUT CompactIFile ... 81 ctFILBLK ... 77 ctFileCloseCallback ... 52 ctFileCreateCallback ... 52 ctFileOpenCallback ... 52 ctFILMTX ... 79 ctfiltercb_rowl ... 78 ctFILWCD ... 79 ctLOKDMP ... 80 ctLOKTIMOUT ... 77
ctQUIET ... 45, See ctFILBLK ctSetOWNER ... 79 ctSNAPSHOT ... 50 ctSQLImportTable ... 79 ctUpdateICUversion ... 82 ctUPDICU ... 82 CurrentISAMKey ... 85 ESTKEY ... 85 FindFileByName ... 79 GetCtFileInfo ... 82 GETFIL ... 82 LKISAM ... 78 LockList ... 79 LOKREC ... 78 NbrOfKeyEntries ... 85 NXTREC ... 78 NXTVREC ... 78 PUTHDR ... 78 RebuildIFile ... 81 ReWritePartialRecord ... 77 SA_ERRMSG ... 80 SA_WILDCARD ... 80 SetCallbackOnRebuild ... 49 SetDataFilter ... 78 SETOPS... 81 SetSystemConfigurationOption ... 51 TRANBEG ... 78 TRANEND ... 78
c-treeACE Configuration Manager... 32
c-treeACE CPU Configuration Options ... 47
c-treeACE Direct SQL ... 57
c-treeACE Gauges ... 35
c-treeACE ISAM Explorer ... 29
c-treeACE Load Test ... 37
c-treeACE Monitor ... 34
c-treeACE Performance Monitor ... 33
c-treeACE Security Administrator ... 30
c-treeACE Server SDK File Callback Options ... 52
c-treeACE SQL ADO .NET Data Provider ... 55
c-treeACE SQL dbExpress ... 57
c-treeACE SQL Enhancements ... 6, 39 c-treeACE SQL Explorer ... 26
c-treeACE SQL PHP ... 56
c-treeACE SQL Query Builder ... 28
c-treeACE Stack Dumps for Windows and UNIX .. 52
c-treeACE Status Log Analyzer ... 36
c-treeACE Tools ... 3, 25 c-treeDB ... See filters ctdbEstimateSpan ... 85
ctdbNumberOfKeyEntries ... 85
c-treeDB Functions to Start and Stop the c-tree Server Engine ... 74
c-treeDB Transaction Begin Modes ... 74
c-treeSQL and c-treeDB BINARY and VARBINARY Compatibility Issues ... 22
D
DEFAULT Clause with ALTER TABLE ... 42Default Extended Headers for Enhanced Feature Support... 19, 48 Default HUGE Files for Tables ... 40
Default Index for Physical Data File Traversal ... 63
Default Temporary File Path in Standalone and LOCLIB Models ... 82
default values ... 42
Default Values for Alter Table Operations ... 70
Delphi .NET Compatibility when using Create() .... 59
Determine if c-treeDB Records Sets are Active .... 72
diagnostics ... 52
Disable Communications ... 50
Disable the c-treeACE Communication SubSystem ... 50
Documentation Overview ... vii
Dynamic Dump ... 47
E
Easier Navigation in c-treeACE ... 15encryption ... 40
Enforce Maximum Disk Read/Write Sizes on Windows ... 82
Enhanced c-treeACE Statistics Utility Features ... 87
Enhanced Dynamic Dump ... 47
Enhanced Security Administrator Usage and Options ... 88
Ensure Matching Client and Server Versions for 100% Comptibility ... 19 Errors ARQS_ERR ... 80 ARSP_ERR... 80 ITIM_ERR ... 53 LMTC_ERR... 19 R6BT_ERR ... 19 SETENV ... 42 TRQS_ERR ... 80 TRSP_ERR ... 80 UTIM_OUT... 48
Exclusive Sessions and Databases ... 62
Exclusive Sessions and Databases in c-treeDB .... 72
Extended Connection Information in a Lock Dump 80 Extended Version of Compact Function Added ... 81
Extensive Interface Support ... 10
F
FairCom Security Handshake Now Available in all c-treeACE SQL Products ... 43FairCom Typographical Conventions ... viii
file ID ... 82, See GETFIL, See GetCtFileInfo file mutex ... 79, See ctFILMTX File Permission Mode for Files Created by c-tree on Unix Systems ... 53
file permissions ...21, 52, 53, 88 File-based Global Mutexes ... 79
filenames ... 79, See ctFILWCD, See FindFileByName filters ... 21, 78 Filters are Now Record Based, Rather Than Table Based ... 69
G
Get and Set c-treeDB Table Owner Information .... 73Get Table Status information From c-treeDB ... 72
H
handshake ... 43Highlights of c-treeACE V9.0 ... 1
histogram ... 51
HUGE files ... 21, 40, 88 HUGE Files are now Default with c-treeACE SQL . 21
I
Identifying Duplicate Key Index Errors... 72import tables ... 79, See ctSQLImportTable, See ctsqlimp Improved c-treeACE SQL Java Configuration ... 42
Improved c-treeDB.NET ... 59
Improved Query Optimizer Performance ... 39
Increased Page Size Now Available ... 80
ITIM_ERR ... 53
J
java ... 42JDBC ... 42
joins ... See RIGHT OUTER JOIN
K
Key Counting Functions ... 68L
List Users Owning or Waiting for Record Locks .... 79LMTC_ERR ... 19
Locks ... 77, 78, 79, 81, See ctLOKDMP, See LockList, See ctLOKTIMOUT, See blocking lock timeout, See Commit Read Locks LOG_WRITETHRU support for Unix ... 21
LONGVARBINARY ... 40, 41 LONGVARCHAR ... 40, 41 LVARCHAR ... 41
M
Many Additional c-treeDB Features ... 65Many New Method Additions ... 62
Maximum Field Lengths for Non LONGVAR Fields Raised to 8K ... 40
microsoft excel ... 43
More c-treeVCL Functionality ... 85
More Options with c-treeACE Utilities... 87
Move Segments in an Index Definition ... 62
Move Segments in an Index Definition with c-treeDB ... 71
mtmake ... 14
mtPro Build Utility... 14
mutexes ... 79
N
New Commit Read Lock Support Requires Record Locks for Update ... 19New c-treeVCL Features ... 85
New Delphi .NET Support ... 59
New Features for c-treeACE ISAM Server ... 8, 45 New Mode for Table Rebuilds with Missing Index Files ... 63, 73 New Unix Default File Permissions Mode ... 21
NULL Handling in Filter Expressions ... 23
O
ODBC and JDBC Driver Socket SEND/RECV
Timeout ... 42
ODBC Driver Login Timeout ... 42
operating systems ... See unix, See Solaris, See AIX, See windows Options to Retrieve a File's Unique ID ... 82
Other New Functions Available ... 82
P
Partial Record Rewrites ... 77performance ... 39, 43 preimage ... 43, 49 PREIMAGE Tables in c-treeACE SQL ... 43
Prime Cache By Key... 49
Programmatically Import Tables into c-treeACE SQL ... 79
Q
queries ... 43, See timeouts Query Timeout Options ... 42Quickly TRUNCATE Tables ... 40
quiese ... 45, See ctQUIET, See ctFILBLK, See ctadmn
R
Rebuild Callback Support in Client/Server Mode ... 49Rebuild Tables with c-treeDB ... 69
rebuilds ... 49, See RebuildIFile Record Based c-treeDB Filters ... 21
Recursive Locking Support ... 78
recursive locks ... 78
Reserved Keywords With Microsoft Excel and ODBC ... 43
resources ... 66, 85 Resources for c-treeDB ... 66
Retain Locks After Commit ... 69
Retrieve a Field that Partially Matches a Key Segment... 68
Retrieve a List of File names from c-treeACE ... 79
Retrieve c-tree Configuration with c-treeDB ... 72
Retrieve c-treeDB Field and Segment Change Status ... 71
Retrieve Field, Index, and Segment Status ... 61
Retrieve the c-treeACE Configuration ... 62
Retry Options ... 53
ReWritePartialRecord ... 77
rewriting records ... 77, See ReWritePartialRecord Row Level Permanent Filters ... 67
Row-Level Permanent Callback Filters ... 78
S
Scaling Factors for Configuration Keyword Values 50 security ... 78, See handshake security administrator.... See SA_WILDCARD, See SA_ERRMSG, See sa_admin server SDK ... See ctFileCloseCallback, See ctFileOpenCallback, See ctFileCreateCallback Set Integer Values with c-treeDB CTMoney Class 73 Set Operations State in c-treeDB ... 73shared memory ... 50
SNAPSHOT ... 50, 51, 87 SNAPSHOT Histogram Support ... 51
Solaris ... 52
SQL keywords ... 43, 44, See LVARCHAR, See LONGVARBINARY, See LONGVARCHAR ALTER TABLE ... 42 CONTAINS ... 41 CREATE TABLE ... 40 DEFAULT ... 42 FOR UPDATE ... 43 LIKE ... 41 ORDER BY ... 43
RIGHT OUTER JOIN ... 42
STORAGE_ATTRIBUTES ... 40, 43 TRUNCATE TABLE ... 40 SQL_ATTR_CONNECTION_TIMEOUT ... 42 SQL_ATTR_LOGIN_TIMEOUT ... 42 SQLSetConnectAttr ... 42 stack trace ... 52 stored procedures ... 42
Stored Procedures, Triggers, and User Defined Functions Now Standard Features ... 40
Support for Resources ... 60
Support for SQL Transaction Isolation Levels 1 and 2 ... 41
T
TCP/IP ... 50, 80, See 809, See 808, See TRSP_ERR, See TRQS_ERR, See ARSP_ERR, See 128, See 127, See ARQS_ERR, See COMM_PROTOCOL DISABLE, See SERVER_NAME, See SERVER_PORT TCP/IP Client Connect and Communication Timeout Options ... 80Temporarily Suspend c-treeACE Operations ... 45
The Most Up to Date Information ... 18
threads ... 79, See ctSetOWNER timeouts ... 42, 77, 80, See 809, See 808, See TRSP_ERR, See TRQS_ERR tools ... 26, 28, 29, 30, 33, 34, 35, 36, 37 transaction isolation levels ... 41
Transaction Log Format ... 20
transaction logs ... 20
Transaction Processing ... 20, 41, 49, 52, See preimage, See Commit Read Locks, See Transaction Timeout Transaction Timeout ... 48
triggers ... 42
TRQS_ERR ... 80
U
UNICODE .. 66, 82, See ctUpdateICUversion, See ctUPDICU
Unicode Support for c-treeDB ... 66 unix ... 21, 53 Update Unicode Version ... 82 Updated c-treeACE SQL Reserved Words ... 44 user defined functions... 42 utilities ctadmn ... 20, 45 ctinfo ... 88 ctsqlcdb ... 43 ctsqlimp ... 87 ctstat ... 50, 87 ctstop ... 20 sa_admin ... 80, 88 UTIM_OUT ... 48