System administration tasks

Typically, the database administrator (DBA) is responsible for the tasks listed on the left side of the following table. Look at the right side of the table to see where these tasks are explained in this or other manuals.

**Table 1-1: Administrative tasks**
If you want to know how to...	Look in...
Install and configure Sybase IQ for your platform	Sybase IQ Installation and Configuration Guide
Start and stop the database server	Chapter 2, “Running Sybase IQ”
Set up or manage user connections	Chapter 3, “Sybase IQ Connections” and Chapter 4, “Connection and Communication Parameters”
Create a Sybase IQ database (with or without multiplex capability)	Chapter 5, “Working with Database Objects”
Determine appropriate indexes for your users' queries	Chapter 6, “Using Sybase IQ Indexes”
Load data into your database	Chapter 7, “Moving Data In and Out of Databases”
Create procedures and batches	Chapter 8, “Using Procedures and Batches”
Ensure the integrity of data in your tables	Chapter 9, “Ensuring Data Integrity”
Understand how transactions impact concurrency	Chapter 10, “Transactions and Versioning”
Set up your database for the language you work in	Chapter 11, “International Languages and Character Sets”
Add users, assign them privileges, and manage logins	Chapter 12, “Managing User IDs and Permissions”
Back up and restore databases	Chapter 14, “Data Backup, Recovery, and Archiving”
Tune Sybase IQ for maximum performance	Sybase IQ Performance and Tuning Guide
Monitor IQ performance	Sybase IQ Performance and Tuning Guide
Set up IQ for use as an Open Server	Chapter 15, “Sybase IQ as a Data Server”
Configure Sybase IQ to access remote data	Chapter 16, “Accessing Remote Data” Chapter 17, “Server Classes for Remote Data Access”
Automate database administration tasks using scheduling and event handling	Chapter 18, “Automating Tasks Using Schedules and Events”
Use Java tools to access XML documents in Sybase IQ	Appendix A, “XML in the Database”
Use Java in a Sybase IQ database	Appendix B, “Data Access Using JDBC” Appendix C, “Debugging Logic in the Database”
Diagnose IQ server conditions	Chapter 1, “Troubleshooting Hints” in Sybase IQ Troubleshooting and Error Messages Guide
Verify or recover your database	Chapter 2, “System Recovery and Database Repair” in Sybase IQ Troubleshooting and Error Messages Guide