dropping, 215
modifying, 214-215
timeslice, 226
tips, 403-456
active vs. inactive connections, 425-431
auditing, 177
backing up Unix systems, 403
database cannot be accessed, 369
database creation checklist, 431-433
deadlocking, 404
defining space requirements, 448
designating default database, 404
determining total memory in Sun Solaris
system, 449
finding status of database devices,
421-425
finding users, 411-417
for DBAs, 451-456
killing user connections, 418-421
loading production databases, 404
maintaining indexes, 448
matching IDs, 450-451
monitoring, 408-411
objects cannot be accessed, 369
performance tuning, 404-407
processing has slowed or stopped, 369
protecting passwords, 450
reducing contention, 448-449
retrieving data, 433-448
retrieving information about connec-
tions, 425-431
server may have stopped, 368
server won’t come up, 367
tuning, 407-408
Unix backups, 403
users can’t access server, 368
using Historical Server, 406-407
transaction control statements, 94-95
transaction dump, 181, 196
transaction log, 91, 92
filling, 102
in sybsecurity database, 164
managing, 363
sizing cache for, 287-288
truncating, 102-106
truncating automatically, 108
transaction modes, 92-94
transactions, 91-92
aborting, 203-204
committing, 97-99
distributed, 8
dumping, 196-198
loading, 198-199
suspended, 108
suspending, 203-204
troubleshooting, 5
tips, 367-370
truncation of transaction log, 102-106
automatic, 108
truncation point, 102
trusted roots file, 18-19
tuning cache, 274-276
tuning issues, 289
U
unbinding, 140, 283
unchained mode transaction, 93
Unix interfaces example, 29
Unix runserver example, 32
Unix startup, 37-38
manual, 38-39
verifying, 39
unmirroring, 57-58
update statistics, 293, 365
up-to-the-minute recovery, 199-200
user database, 8
creating, 4
initializing, 3-4
user log cache, 98
user-defined roles, 145-146
creating, 146
dropping, 146
users, 4
adding to database, 123
assigning roles to, 148
displaying information about, 125
dropping from database, 123
utilities, 7
V
volume management, 60-61
W
warm standby, 206-207
wash area, 280-281
sizing, 281-282
wash marker, 280
with grant option, 134
work tables, 73-74
worker processes, configuring, 348-350
workspaces,
creating for dbccdb, 353
planning size of, 348
write-ahead log, 92
467
Index

Get Administrator's Guide to Sybase ASE 15 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.