Sybase 12.4.2 Manuale Utente
Contents
iii
About This Book ........................................................................................................................ xvii
CHAPTER 1
Overview of Adaptive Server IQ System Administration ............ 1
Introduction to Adaptive Server IQ ................................................... 1
System administration tasks............................................................. 2
Security overview ............................................................................. 3
System administration tasks............................................................. 2
Security overview ............................................................................. 3
Types of users ........................................................................... 4
Granting permissions ................................................................ 4
Granting permissions ................................................................ 4
Tools for system administration........................................................ 4
The database server ........................................................................ 5
Catalogs and IQ ............................................................................... 5
The database server ........................................................................ 5
Catalogs and IQ ............................................................................... 5
The IQ Store .............................................................................. 6
The Temporary Store ................................................................ 6
The Catalog Store ..................................................................... 6
The Temporary Store ................................................................ 6
The Catalog Store ..................................................................... 6
Concurrent operations...................................................................... 7
Stored procedures............................................................................ 7
Stored procedures............................................................................ 7
Adaptive Server IQ stored procedures ...................................... 8
Adaptive Server Enterprise system and catalog procedures .... 9
Catalog stored procedures ...................................................... 11
Adaptive Server Enterprise system and catalog procedures .... 9
Catalog stored procedures ...................................................... 11
System tables and views................................................................ 12
Commands and Functions ............................................................. 16
Commands and Functions ............................................................. 16
Types of SQL statements ........................................................ 16
Functions ................................................................................. 16
Functions ................................................................................. 16
Message logging ............................................................................ 17
The utility database ........................................................................ 18
Compatibility with earlier versions .................................................. 19
The utility database ........................................................................ 18
Compatibility with earlier versions .................................................. 19
CHAPTER 2
Running Adaptive Server IQ ........................................................ 21
Starting the database server .......................................................... 21
Server command lines ................................................................... 22
Starting the server on UNIX ........................................................... 23
Server command lines ................................................................... 22
Starting the server on UNIX ........................................................... 23
Using the startup utility ............................................................ 24
Typing the server startup command ........................................ 25
Typing the server startup command ........................................ 25