Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 13 / 536

Contents
xiii
The RESTORE statement ..................................................... 399
Restoring in the correct order ................................................ 403
Renaming the transaction log after you restore .................... 405
Validating the database after you restore.............................. 406
Restore requires exclusive write access ............................... 406
Displaying header information............................................... 407
Recovery from errors during restore ..................................... 408
Using Symbolic Links (UNIX Only) ........................................ 408
Unattended backup ...................................................................... 409
Getting information about backups and restores ......................... 410
Locating the backup log ........................................................ 410
Content of the backup log ..................................................... 411
Maintaining the backup log.................................................... 412
Viewing the backup log in Sybase Central ............................ 412
Recording dbspace names.................................................... 412
Determining your data backup and recovery strategy.................. 413
Scheduling routine backups .................................................. 414
Designating Backup and Restore Responsibilities ................ 415
Improving performance for backup and restore .................... 415
CHAPTER 12 Managing System Resources .................................................... 419
Introduction to performance terms ............................................... 419
Designing for performance .......................................................... 419
Overview of memory use ............................................................. 420
Paging increases available memory...................................... 420
Utilities to monitor swapping.................................................. 421
Server memory ...................................................................... 421
Managing buffer caches ........................................................ 422
Determining the sizes of the buffer caches ........................... 422
Setting buffer cache sizes ..................................................... 427
Specifying page size ............................................................. 429
Saving memory ..................................................................... 431
Optimizing for large numbers of users .................................. 432
Platform-specific memory options ......................................... 434
Other ways to get more memory ........................................... 438
The process threading model....................................................... 439
Insufficient threads error........................................................ 440
IQ options for managing thread usage .................................. 440
Balancing I/O................................................................................ 441
Raw I/O (on UNIX operating systems) .................................. 441
Using disk striping ................................................................. 442
Internal striping ...................................................................... 443
Using multiple dbspaces ....................................................... 445
Strategic file locations ........................................................... 446