Sybase 12.4.2 Manuale Utente
CHAPTER 1 Overview of Adaptive Server IQ System Administration
3
Table 1-1: Administrative tasks
Security overview
The DBA is responsible for maintaining database security. Adaptive Server IQ
provides security controls by means of the privileges you can assign to users.
provides security controls by means of the privileges you can assign to users.
If you want to know how to...
Look in...
Install and configure Adaptive Server
IQ for your platform
IQ for your platform
Adaptive Server IQ Installation and
Configuration Guide
Configuration Guide
Start and stop the database server, and
set up user connections
set up user connections
Chapter 2, “Running Adaptive Server
IQ”
IQ”
Create an Adaptive Server IQ database
Chapter 3, “Working with Database
Objects”
Objects”
Determine appropriate indexes for
your users' queries
your users' queries
Chapter 4, “Adaptive Server IQ
Indexes”
Indexes”
Load data into your database
Chapter 5, “Moving Data In and Out
of Databases”
of Databases”
Add users and assign them privileges
Chapter 10, “Managing User IDs and
Permissions”
Permissions”
Ensure the integrity of data in your
tables
tables
Chapter 7, “Ensuring Data Integrity”
Understand how transactions impact
concurrency
concurrency
Chapter 8, “Transactions and
Versioning”
Versioning”
Set up your database for the language
you work in
you work in
Chapter 9, “International Languages
and Character Sets”
and Character Sets”
Back up and restore databases
Chapter 11, “Backup and Data
Recovery”
Recovery”
Tune Adaptive Server IQ for
maximum performance
maximum performance
Chapter 12, “Managing System
Resources”; see also performance
tuning hints for specific features in all
chapters
Resources”; see also performance
tuning hints for specific features in all
chapters
Monitor IQ performance
Chapter 13, “Monitoring and Tuning
Performance”
Performance”
Set up and manage a multiplex
configuration
configuration
Adaptive Server IQ Multiplex User’s
Guide
Guide