OPGUIDE.PDF

(2590 KB) Pobierz
opguide.bk
InterBase 6
Operations Guide
Borland
®
SOFTWARE CORPORATION
100 Enterprise Way, Scotts Valley, CA 95066 http://www.borland.com
302388078.003.png 302388078.004.png
Borland Software Corporation may have patents and/or pending patent applications covering subject matter in
this document. The furnishing of this document does not convey any license to these patents.
Copyright 2001 BorlandSoftware Corporation. All rights reserved. All InterBase and Borland products are
trademarks or registered trademarks of BorlandSoftware Corporation. Other brand and product names are
trademarks or registered trademarks of their respective holders.
INT0060WW21000 20000
D4
302388078.005.png
Table of Contents
List of Tables
....................................
xiii
List of Figures
.....................................
xv
CHAPTER 1
Introduction
Who should use this guide
.....................
17
Topics covered in this guide
....................
18
System requirements and server sizing
..............
18
Primary InterBase features
.....................
19
SQL support
..........................
21
Multiuser database access
...................
21
Transaction management
...................
22
Multigenerational architecture
................
22
Optimistic row-level locking
.................
22
Database administration
...................
23
About InterBase SuperServer architecture
............
24
How SuperServer differs from Classic architecture
....
24
Which is better?
........................
26
Overview of command-line tools
..................
27
isql
................................
27
gbak
...............................
27
gfix
................................
28
gsec
...............................
28
gstat
...............................
28
iblockpr (gds_lock_print)
...................
28
ibmgr
..............................
29
CHAPTER 2
IBConsole: The InterBase Interface
Starting IBConsole
..........................
32
IBConsole menus
........................
32
Tree pane
............................
35
Work pane
...........................
37
iii
302388078.006.png
Standard text display window
................
37
Switching between IBConsole windows
...........
38
Managing custom tools in IBConsole
............
38
CHAPTER 3
Server Configuration
Configuring server properties
...................
41
The General tab
........................
42
The IB Settings tab
.......................
42
Using InterBase Manager to start and stop InterBase
......
43
Starting and stopping the InterBase Server on UNIX
......
44
Using ibmgr to start and stop the server
..........
44
Starting the server
.......................
45
Stopping the server
......................
45
Starting the server automatically
...............
46
The attachment governor
......................
50
Using environment variables
....................
50
ISC_USER
and
ISC_PASSWORD
.................
51
The
INTERBASE
environment variables
...........
51
The
TMP
environment variable
................
51
Managing temporary files
......................
52
Configuring history files
...................
52
Configuring sort files
.....................
52
Configuring parameters in isc_config
...............
53
Monitoring client connections with IBConsole
..........
55
Viewing the server log file
.....................
56
CHAPTER 4
Network Configuration
Network protocols
..........................
59
Connecting to servers and databases
...............
60
Registering a server
......................
60
Logging in to a server
.....................
62
Logging out from a server
...................
63
Unregistering a server
.....................
63
Registering a database
.....................
64
iv
INTERBASE 6
302388078.001.png
Connecting to a database
...................
65
Disconnecting a database
...................
67
Unregistering a database
...................
67
Connection-specific examples
.................
68
Connection troubleshooting
....................
68
Connection refused errors
..................
68
Connection rejected errors
..................
71
Disabling automatic Internet dialup
.............
72
Other errors
..........................
74
Communication diagnostics
....................
76
DB Connection tab
.......................
76
TCP/IP tab
...........................
77
NetBEUI tab
...........................
79
SPX tab
.............................
80
CHAPTER 5
Database Security
Security model
............................
83
The
SYSDBA
user
........................
84
Other users
...........................
84
Users on UNIX
.........................
85
Security database isc4.gdb
.....................
85
SQL privileges
............................
86
Groups of users
...........................
86
ANSI SQL 3 roles
........................
86
UNIX groups
..........................
87
Other security measures
......................
88
Restriction on using InterBase tools
.............
88
Protecting your databases
...................
88
User administration with IBConsole
................
89
Displaying the User Information dialog
...........
Adding a user
..........................
90
Modifying user configurations
................
91
Deleting a user
.........................
91
User administration with the InterBase API
...........
92
v
89
302388078.002.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin