Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 23 / 536

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