Filter
Top Products
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