Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 5 / 536

Contents
v
Steps in establishing a connection .......................................... 77
Locating the interface library ................................................... 78
Assembling a list of connection parameters ............................ 79
Locating a server ..................................................................... 81
Locating the database ............................................................. 83
Server name caching for faster connections ........................... 84
Interactive SQL connections ................................................... 85
Connecting from other databases .................................................. 85
Using an integrated login ............................................................... 86
Using integrated logins ............................................................ 87
Security concerns: unrestricted database access ................... 90
Setting temporary public options for added security ............... 91
Network aspects of integrated logins ...................................... 92
Creating a default integrated login user .................................. 92
Troubleshooting startup, shutdown, and connections .................... 93
What to do if you can’t start Adaptive Server IQ...................... 93
What to do if you can’t connect to a database......................... 95
Stopping a database server in an emergency (UNIX) ............. 96
Resolving problems with your DBISQL window on UNIX........ 96
CHAPTER 3 Working with Database Objects .................................................. 99
Building Your Adaptive Server IQ Databases ................................ 99
Designing your database......................................................... 99
Tools for working with database objects ............................... 100
A step-by-step overview of database setup .......................... 101
Extending data definition privileges ....................................... 103
Selecting a device type ......................................................... 104
Allocating space for databases ............................................. 104
Working with databases ............................................................... 106
Creating a database .............................................................. 107
Adding dbspaces ................................................................... 114
Dropping dbspaces ............................................................... 116
Dropping a database ............................................................. 118
Working with tables ...................................................................... 118
Creating tables ...................................................................... 118
Altering tables........................................................................ 123
Dropping tables ..................................................................... 124
Creating primary and foreign keys ........................................ 125
Table information in the system tables .................................. 127
Working with views....................................................................... 127
Creating views ....................................................................... 128
Using views ........................................................................... 129
Modifying views ..................................................................... 130
Permissions on views ............................................................ 130