iii
Contents
About This Manual............................................................ xi
Related documentation ............................................................xii
Documentation conventions....................................................xiii
The sample database..............................................................xvi
1 File Locations and Installation Settings........................... 1
Installation directory structure...................................................2
How Adaptive Server Anywhere locates files ...........................4
Environment variables ..............................................................6
Registry entries and INI files...................................................10
2 The Database Server ....................................................... 13
The database server ...............................................................14
3 Connection and Communication Parameters................ 45
Connection parameters...........................................................46
Network communications parameters ....................................65
4 Database Administration Utilities................................... 75
Administration utilities overview..............................................77
The Backup utility....................................................................78
The Collation utility..................................................................82
The Compression utility...........................................................85
The Console utility...................................................................87
The Data Source utility............................................................89
The Erase utility ......................................................................94
The Information utility..............................................................96
The Initialization utility.............................................................98
The Interactive SQL utility.....................................................106
The License utility .................................................................109
The Log Transfer Manager ...................................................111
The Log Translation utility.....................................................117
The Ping utility.......................................................................122
The REBUILD utility..............................................................124