589 lines
7.5 KiB
HTML
589 lines
7.5 KiB
HTML
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Sybase Adaptive Server Anywhere for Linux HOWTO</TITLE
|
|
><META
|
|
NAME="GENERATOR"
|
|
CONTENT="Modular DocBook HTML Stylesheet Version 1.63
|
|
"><LINK
|
|
REL="NEXT"
|
|
TITLE="Introduction"
|
|
HREF="intro.html"></HEAD
|
|
><BODY
|
|
CLASS="ARTICLE"
|
|
BGCOLOR="#FFFFFF"
|
|
TEXT="#000000"
|
|
LINK="#0000FF"
|
|
VLINK="#840084"
|
|
ALINK="#0000FF"
|
|
><DIV
|
|
CLASS="ARTICLE"
|
|
><DIV
|
|
CLASS="TITLEPAGE"
|
|
><H1
|
|
CLASS="TITLE"
|
|
><A
|
|
NAME="AEN2"
|
|
>Sybase Adaptive Server Anywhere for Linux HOWTO</A
|
|
></H1
|
|
><DIV
|
|
CLASS="AUTHORGROUP"
|
|
><A
|
|
NAME="AEN4"
|
|
></A
|
|
><H3
|
|
CLASS="AUTHOR"
|
|
><A
|
|
NAME="AEN5"
|
|
>Aylwin Lo</A
|
|
></H3
|
|
><H3
|
|
CLASS="AUTHOR"
|
|
><A
|
|
NAME="AEN8"
|
|
>Tom Slee</A
|
|
></H3
|
|
><DIV
|
|
CLASS="AFFILIATION"
|
|
><SPAN
|
|
CLASS="ORGNAME"
|
|
>Sybase Inc.<BR></SPAN
|
|
><DIV
|
|
CLASS="ADDRESS"
|
|
><P
|
|
CLASS="ADDRESS"
|
|
> Tom.Slee@sybase.com<br>
|
|
</P
|
|
></DIV
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="REVHISTORY"
|
|
><TABLE
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
><TR
|
|
><TH
|
|
ALIGN="LEFT"
|
|
VALIGN="TOP"
|
|
COLSPAN="3"
|
|
><B
|
|
>Revision History</B
|
|
></TH
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revision 1.0</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>2001-04-26</TD
|
|
><TD
|
|
ALIGN="LEFT"
|
|
>Revised by: al</TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
ALIGN="LEFT"
|
|
COLSPAN="3"
|
|
>First public release.</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
><DIV
|
|
><DIV
|
|
CLASS="ABSTRACT"
|
|
><A
|
|
NAME="AEN21"
|
|
></A
|
|
><P
|
|
></P
|
|
><P
|
|
> This HOWTO guides you through the installation of SQL Anywhere
|
|
Studio 7.0.2 for Linux and the basic operation and administration
|
|
of Adaptive Server Anywhere databases.
|
|
</P
|
|
><P
|
|
></P
|
|
></DIV
|
|
></DIV
|
|
><HR></DIV
|
|
><DIV
|
|
CLASS="TOC"
|
|
><DL
|
|
><DT
|
|
><B
|
|
>Table of Contents</B
|
|
></DT
|
|
><DT
|
|
>1. <A
|
|
HREF="intro.html"
|
|
>Introduction</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>1.1. <A
|
|
HREF="intro.html#AEN26"
|
|
>New versions of this document</A
|
|
></DT
|
|
><DT
|
|
>1.2. <A
|
|
HREF="intro.html#AEN30"
|
|
>Content and Audience</A
|
|
></DT
|
|
><DT
|
|
>1.3. <A
|
|
HREF="intro.html#AEN35"
|
|
>Adaptive Server Anywhere features</A
|
|
></DT
|
|
><DT
|
|
>1.4. <A
|
|
HREF="intro.html#AEN69"
|
|
>Quirks</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>1.4.1. <A
|
|
HREF="intro.html#AEN71"
|
|
>Alt and Function keys</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>1.5. <A
|
|
HREF="intro.html#DBCONCEPTS"
|
|
>What's a Relational Database?</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>1.5.1. <A
|
|
HREF="intro.html#AEN79"
|
|
>Definition</A
|
|
></DT
|
|
><DT
|
|
>1.5.2. <A
|
|
HREF="intro.html#AEN84"
|
|
>Example</A
|
|
></DT
|
|
><DT
|
|
>1.5.3. <A
|
|
HREF="intro.html#AEN303"
|
|
>Primary and Foreign Keys</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>2. <A
|
|
HREF="requirements.html"
|
|
>Requirements</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>2.1. <A
|
|
HREF="requirements.html#AEN315"
|
|
>System requirements</A
|
|
></DT
|
|
><DT
|
|
>2.2. <A
|
|
HREF="requirements.html#AEN327"
|
|
>Supported distributions</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>3. <A
|
|
HREF="install.html"
|
|
>Installation</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>3.1. <A
|
|
HREF="install.html#AEN343"
|
|
>Process</A
|
|
></DT
|
|
><DT
|
|
>3.2. <A
|
|
HREF="install.html#AEN365"
|
|
>Distribution-specific considerations
|
|
(for TurboLinux and Caldera)</A
|
|
></DT
|
|
><DT
|
|
>3.3. <A
|
|
HREF="install.html#AEN374"
|
|
>Setting the Environment Variables</A
|
|
></DT
|
|
><DT
|
|
>3.4. <A
|
|
HREF="install.html#AEN399"
|
|
>Where did it get installed?</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>4. <A
|
|
HREF="x428.html"
|
|
>Creating, Running and Connecting to Databases</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.1. <A
|
|
HREF="x428.html#AEN430"
|
|
>Creating a database</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.1.1. <A
|
|
HREF="x428.html#ASA-41HTMLTOC511556197"
|
|
>Creating a database
|
|
from the command prompt</A
|
|
></DT
|
|
><DT
|
|
>4.1.2. <A
|
|
HREF="x428.html#ASA-41HTMLTOC511556198"
|
|
>Creating a database
|
|
from Sybase Central</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>4.2. <A
|
|
HREF="x428.html#AEN461"
|
|
>Running a database server and starting databases</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.2.1. <A
|
|
HREF="x428.html#AEN527"
|
|
>Running the server as a daemon</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>4.3. <A
|
|
HREF="x428.html#AEN534"
|
|
>Stopping the database server</A
|
|
></DT
|
|
><DT
|
|
>4.4. <A
|
|
HREF="x428.html#AEN569"
|
|
>Stopping databases</A
|
|
></DT
|
|
><DT
|
|
>4.5. <A
|
|
HREF="x428.html#AEN576"
|
|
>Connecting to a database</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.5.1. <A
|
|
HREF="x428.html#AEN593"
|
|
>Connection strings</A
|
|
></DT
|
|
><DT
|
|
>4.5.2. <A
|
|
HREF="x428.html#AEN606"
|
|
>Connecting from Interactive SQL</A
|
|
></DT
|
|
><DT
|
|
>4.5.3. <A
|
|
HREF="x428.html#AEN609"
|
|
>Connecting via ODBC</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>4.5.3.1. <A
|
|
HREF="x428.html#AEN612"
|
|
>Setting up ODBC with Adaptive Server Anywhere</A
|
|
></DT
|
|
><DT
|
|
>4.5.3.2. <A
|
|
HREF="x428.html#AEN625"
|
|
>About ODBC data sources</A
|
|
></DT
|
|
><DT
|
|
>4.5.3.3. <A
|
|
HREF="x428.html#AEN669"
|
|
>Connecting to an ODBC data source</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>5. <A
|
|
HREF="backup.html"
|
|
>Backing up and Restoring a Database</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>5.1. <A
|
|
HREF="backup.html#AEN680"
|
|
>Creating a Backup of the Database</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>5.1.1. <A
|
|
HREF="backup.html#AEN683"
|
|
>Full vs. Incremental Backups</A
|
|
></DT
|
|
><DT
|
|
>5.1.2. <A
|
|
HREF="backup.html#AEN687"
|
|
>Online vs. Offline Backups</A
|
|
></DT
|
|
><DT
|
|
>5.1.3. <A
|
|
HREF="backup.html#AEN692"
|
|
>Server-side vs. Client-side Backups</A
|
|
></DT
|
|
><DT
|
|
>5.1.4. <A
|
|
HREF="backup.html#AEN697"
|
|
>How to make a backup</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>5.1.4.1. <A
|
|
HREF="backup.html#AEN699"
|
|
>From the command line</A
|
|
></DT
|
|
><DT
|
|
>5.1.4.2. <A
|
|
HREF="backup.html#AEN723"
|
|
>From SQL</A
|
|
></DT
|
|
><DT
|
|
>5.1.4.3. <A
|
|
HREF="backup.html#AEN728"
|
|
>From Sybase Central</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>5.2. <A
|
|
HREF="backup.html#AEN731"
|
|
>Validating the database and its backup</A
|
|
></DT
|
|
><DT
|
|
>5.3. <A
|
|
HREF="backup.html#AEN735"
|
|
>Recovering the database</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6. <A
|
|
HREF="manage.html"
|
|
>Managing a Database</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.1. <A
|
|
HREF="manage.html#AEN740"
|
|
>Tables</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.1.1. <A
|
|
HREF="manage.html#AEN758"
|
|
>Creating a Table</A
|
|
></DT
|
|
><DT
|
|
>6.1.2. <A
|
|
HREF="manage.html#AEN772"
|
|
>Making Alterations to Tables</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6.2. <A
|
|
HREF="manage.html#AEN792"
|
|
>Users, permissions, and authorities</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.2.1. <A
|
|
HREF="manage.html#AEN796"
|
|
>User IDs</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.2.1.1. <A
|
|
HREF="manage.html#AEN798"
|
|
>Special user IDs</A
|
|
></DT
|
|
><DT
|
|
>6.2.1.2. <A
|
|
HREF="manage.html#AEN804"
|
|
>Creating new user IDs</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6.2.2. <A
|
|
HREF="manage.html#AEN813"
|
|
>Permissions</A
|
|
></DT
|
|
><DT
|
|
>6.2.3. <A
|
|
HREF="manage.html#AEN855"
|
|
>Authorities</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.2.3.1. <A
|
|
HREF="manage.html#AEN858"
|
|
>RESOURCE authority</A
|
|
></DT
|
|
><DT
|
|
>6.2.3.2. <A
|
|
HREF="manage.html#AEN863"
|
|
>DBA authority</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6.2.4. <A
|
|
HREF="manage.html#AEN868"
|
|
>Removing Users and Revoking Permissions</A
|
|
></DT
|
|
><DT
|
|
>6.2.5. <A
|
|
HREF="manage.html#AEN880"
|
|
>Changing Passwords</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>6.3. <A
|
|
HREF="manage.html#AEN888"
|
|
>Making the database more secure</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>6.3.1. <A
|
|
HREF="manage.html#AEN923"
|
|
>Increasing password security</A
|
|
></DT
|
|
><DT
|
|
>6.3.2. <A
|
|
HREF="manage.html#AEN929"
|
|
>Views, procedures, and triggers</A
|
|
></DT
|
|
><DT
|
|
>6.3.3. <A
|
|
HREF="manage.html#AEN935"
|
|
>Encrypting client/server communications</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DD
|
|
><DT
|
|
>7. <A
|
|
HREF="moreinfo.html"
|
|
>Where to get more information</A
|
|
></DT
|
|
><DT
|
|
>8. <A
|
|
HREF="legal.html"
|
|
>Legalities and Acknowledgements</A
|
|
></DT
|
|
><DD
|
|
><DL
|
|
><DT
|
|
>8.1. <A
|
|
HREF="legal.html#AEN963"
|
|
>Copyright and Licenses</A
|
|
></DT
|
|
><DT
|
|
>8.2. <A
|
|
HREF="legal.html#AEN977"
|
|
>Names and Contacts</A
|
|
></DT
|
|
><DT
|
|
>8.3. <A
|
|
HREF="legal.html#AEN981"
|
|
>Acknowledgement</A
|
|
></DT
|
|
></DL
|
|
></DD
|
|
></DL
|
|
></DIV
|
|
></DIV
|
|
><DIV
|
|
CLASS="NAVFOOTER"
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"><TABLE
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
CELLPADDING="0"
|
|
CELLSPACING="0"
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="intro.html"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Introduction</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |