About this book

Subject

Sybase® IQ is a high-performance decision support server designed specifically for data warehouses and data marts. This book, System Administration Guide: Volume 1, presents concepts and procedures necessary for the administration of Sybase IQ.

Audience

This guide is for system and database administrators and for anyone who needs to set up or manage Sybase IQ. Familiarity with relational database systems and introductory user-level experience with Sybase IQ is assumed. Use this guide with other manuals in the documentation set.

How to use this book

The following table shows which chapters fit a particular interest or need.

Table 1: Guide to using this book

To learn how to...

Read this chapter...

Understand the role of an Sybase IQ administrator

Chapter 1, “Overview of Sybase IQ System Administration”

Start and stop an IQ database server, and set up user connections

Chapter 2, “Running Sybase IQ”

Set up user connections

Chapter 3, “Sybase IQ Connections” and Chapter 4, “Connection and Communication Parameters”

Create an Sybase IQ database

Chapter 5, “Working with Database Objects”

Select Sybase IQ indexes

Chapter 6, “Using Sybase IQ Indexes”

Load data into your database

Chapter 7, “Moving Data In and Out of Databases”

Add users and assign them privileges

Chapter 8, “Managing User IDs and Permissions”

Specify constraints on the data in your tables

Chapter 9, “Ensuring Data Integrity”

Understand how transactions work

Chapter 10, “Transactions and Versioning”

Set up your database for the language you work in

Chapter 11, “International Languages and Character Sets”

Back up and restore databases and archive data

Chapter 12, “Data Backup, Recovery, and Archiving”

Back up and recover servers and repair databases

Chapter 13, “System Recovery and Database Repair”

Resolve problems encountered while running Sybase IQ

Chapter 14, “Troubleshooting Hints”

Create procedures and batches

Volume 2 Chapter 1, “Using Procedures and Batches”

Use OLAP functions

Volume 2 Chapter 2, “Using OLAP”

Set up IQ for use as an Open Server™

Volume 2 Chapter 3, “Sybase IQ as a Data Server”

Configure Sybase IQ to access remote data

Volume 2 Chapter 4, “Accessing Remote Data”

Volume 2 Chapter 5, “Server Classes for Remote Data Access”

Automate database administration tasks using scheduling and event handling

Volume 2 Chapter 6, “Automating Tasks Using Schedules and Events”

Use Java tools to access XML documents in Sybase IQ

Appendix A, “XML in the Database”

Use the Sybase debugger

Appendix A, “Debugging Logic in the Database”

Use JDBC to access data

SQL Anywhere® Server – Programming

Protect the confidentiality and integrity of data passing between a client and the Sybase IQ server

SQL Anywhere Studio Security Guide and Appendix A, “Compatibility with Other Sybase Databases,” in Reference: Building Blocks, Tables, and Procedures

Related documents

The Sybase IQ 15.1 documentation set includes:

NoteSybase IQ and SQL Anywhere Because Sybase IQ is an extension of SQL Anywhere Server, a component of the SQL Anywhere® package, Sybase IQ supports many of the same features as SQL Anywhere Server. The IQ documentation set refers you to SQL Anywhere documentation, where appropriate.

Documentation for SQL Anywhere includes:

You can also refer to the SQL Anywhere documentation in the SQL Anywhere 11.0.1 collection at Product Manuals and in DocCommentXchange.

Documentation for Sybase Software Asset Management (SySAM) includes:

Other sources of information

Use the Sybase Getting Started CD, the SyBooks™ CD, and the Sybase Product Manuals Web site to learn more about your product:

Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

StepsFinding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

StepsFinding the latest information on component certifications

  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Product; or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

StepsCreating a personalized view of the Sybase Web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.

Sybase EBFs and software maintenance

StepsFinding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.

Syntax conventions

This documentation uses the following syntax conventions in syntax descriptions:

Typographic conventions

Table 2 lists the typographic conventions used in this documentation.

Table 2: Typographic conventions

Item

Description

Code

SQL and program code is displayed in a mono-spaced (fixed-width) font.

User entry

Text entered by the user is shown in bold serif type.

emphasis

Emphasized words are shown in italic.

file names

File names are shown in italic.

database objects

Names of database objects, such as tables and procedures, are shown in bold, san-serif type in print, and in italic online.

The demo database

Sybase IQ includes scripts to create a demo database.

The demo database represents a small company. The database contains internal information about the company (employees, departments, and financial data), as well as product information (products), and sales information (sales orders, customers, and contacts).

To create the demo database, run the file $IQDIR15/demo/mkiqdemo.sh on UNIX or %ALLUSERSPROFILE%\SybaseIQ\demo\mkiqdemo.bat on Windows. The demo database is created in a file named iqdemo.db.

Accessibility features

This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.

Sybase IQ 15.1 and the HTML documentation have been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.

NoteConfiguring your accessibility tool You might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool for information on using screen readers.

For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

For a Section 508 compliance statement for Sybase IQ, go to Sybase Accessibility.

If you need help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.