Documentation changes

In version 12.6, Sybase reorganized the IQ documentation set in order to:

Meet customer needs better
Eliminate redundancy
Reflect changes in the structure of documentation sets for sister products Adaptive Server Anywhere and Adaptive Server Enterprise.

**Table 1-2: 12.6 Sybase IQ new books**
Title	Purpose	Contents^*	Changes
New Features in Sybase IQ 12.6	Overview of new features for this release for all IQ users	List of new features and pointers to books with details about each.	Moved new features from Release Bulletins into this book
Sybase IQ Utility Guide	Guide to utility programs executed at the operating system level for system administrators	Syntax and options for all utility programs including dbisql	Moved chapter 4 from Sybase IQ Reference Manual into this book
Performance and Tuning Guide	Guide for DB administrators. Response to numerous customer requests for more information about database design issues, query optimization, tuning for very large databases, disk and cache issues, effects of locking and cursors on performance.	“Monitoring and Tuning Performance” and “Managing System Resources” (chapters 12 and 13 from Administration and Performance Guide) Query optimization details, formerly part of “Managing System Resources,” set aside as a separate chapter. “Selecting Data from Database Tables” and “Joining Tables” from Introduction to Sybase IQ NT tuning info from Installation and Configuration Guide New information from Engineering	Moved chapters from existing books; added 12.6 new features.
Large Objects Management in Sybase IQ	Description of storage and retrieval of Large Object (LOB) data in Sybase IQ	Syntax and descriptions of commands and functions used to store and move Binary and Character Large Object data.	None.

Table 1-3 describes changes to existing books.

**Table 1-3: 12.6 Sybase IQ changed books**
Title	Purpose	Contents^*	Changes
Performance and Tuning Guide	Guide for DB administrators. Response to numerous customer requests for more information about database design issues, query optimization, tuning for very large databases, disk and cache issues, effects of locking and cursors on performance.	“Monitoring and Tuning Performance” and “Managing System Resources” (chapters 12 and 13 from Administration and Performance Guide) Query optimization details, formerly part of “Managing System Resources,” set aside as a separate chapter. “Selecting Data from Database Tables” and “Joining Tables” from Introduction to Sybase IQ NT tuning info from Installation and Configuration Guide New information from Engineering	Moved chapters from existing books; added 12.6 new features.
Reference Manual	Full description of the SQL language supported by Sybase IQ for all IQ users	SQL syntax, system tables and procedures, SQL functions, and database options.	Moved information on startup and connection to Sybase IQ System Administration Guide. Moved SQL Preprocessor chapter to Sybase IQ Utility Guide. Moved SQL Preprocessor errors to Sybase IQ Troubleshooting and Error Messages Guide
Introduction to Sybase IQ	Product overview and tutorial	Hands-on exercises for those unfamiliar with Sybase IQ.	Moved select and join chapters to Sybase IQ Performance and Tuning Guide. Moved DBISQL chapter to Sybase IQ Utility Guide.
Sybase IQ Installation and Configuration Guide	Procedures for installing Sybase IQ, migrating to a new version of Sybase IQ, and configuring Sybase IQ for a particular platform.	Installation requirements, directions and configuration procedures for both the IQ Server and Network Client.	Moved Windows tuning info into Sybase IQ Performance and Tuning Guide
Sybase IQ Release Bulletin	Information useful to read just before or after purchasing Sybase IQ, or if you encounter a problem.	Restrictions, late changes, known problems, and special installation instructions.	Moved list of new features into this book (New Features in Sybase IQ 12.6).
System Administration Guide	Information that system administrators need to manage the IQ Store	Details about creating database objects, indexing and loading data, and guidelines for managing security, user and system databases, character conversion, international language and sort order settings	Moved memory and performance chapters to separate Performance Guide. Moved all information in Adaptive Server IQ Multiplex User’s Guide into this book. Replaced redundant LOAD TABLE syntax with pointer to Sybase IQ Reference Manual.
Error Messages and Troubleshooting Guide	Guidelines for solving problems, procedures for performing system recovery and database repair, and error message reference information	List of error messages referenced by SQLCode, SQLState, Sybase error code, and message text, troubleshooting recommendations for common errors	Moved SQL Preprocessor errors from Reference Manual to Sybase IQ Troubleshooting and Error Messages Guide. Moved all log file info here from other books. Error message descriptions reorganized and now listed by SQLCode.
Multiplex User’s Guide	Details about creating and administering multiplex databases	Multiplex overview and management procedures.	This book is discontinued. See Table 1-4

Table 1-4 shows the new location for information moved out of the Adaptive Server IQ Multiplex User’s Guide, the discontinued book.

**Table 1-4: Relocated multiplex information**
12.5 Multiplex User’s Guide Chapter	12.5 Multiplex User’s Guide section	12.6 Document title	Location
Chapter 1,” Introducing IQ Multiplex Capability”	“Understanding multiplex architecture”	Sybase IQ System Administration Guide	“Multiplex capability” on page 9
Chapter 2, “Setting Up the Multiplex Environment”	“Multiplex requirements”		“Rules for running multiplex servers” on page 36
	“Running the Sybase ASIQ Agent”		“Running the Sybase IQ Agent” on page 37
	“Setting up the raw device”	Sybase IQ Installation and Configuration Guide	Chapter 1, section “Setting up raw devices for multiplex access.”
	“Granting administrator privilege to the ASIQ service”	Sybase IQ Installation and Configuration Guide	Chapter 3, section “Granting administrator privilege to the ASIQ service”
Chapter 3, “Creating and Populating the Multiplex	“Before creating databases”	Sybase IQ System Administration Guide	“Creating databases with multiplex functionality” on page 199
Chapter 3, “Creating and Populating the Multiplex	Populating persistent tables for query servers	Sybase IQ System Administration Guide	“Populating persistent tables in multiplex databases” on page 243
Chapter 4, “Running Multiplex Servers”		Sybase IQ System Administration Guide	“Starting all servers in a multiplex” on page 42
Chapter 5, “Managing the Multiplex Environment”	“Managing servers”	Sybase IQ System Administration Guide	“Managing multiplex servers” on page 210
	“Deleting query servers”		“Deleting query servers” on page 214
	“Updating multiplex databases”		“Updating multiplex databases” on page 215
	“Changing the DBA password”		“Changing the DBA password in a multiplex” on page 552
	“Managing disk space”	Sybase IQ Performance and Tuning Guide	“Managing disk space in multiplex databases” on page 105
	“Managing memory”		“Server memory” on page 47
	“Truncating the transaction log”		“Truncating the transaction log for a multiplex database” on page 94
	“Backing up and restoring the multiplex”	Sybase IQ System Administration Guide	“Backing up and restoring the multiplex” on page 637
	“Multiplex server migration and failover”	Sybase IQ System Administration Guide	“Multiplex server migration and failover” on page 639