Initializing an 11.0.3.3 Server

After installing Sybase Adaptive Server Enterprise, you can initialize the server by following these steps.

First, su to the sybase user using the -l option.

> su -l sybase

Run install/sybinit, a text-based installation program. When prompted, follow these instructions.

> select 3. Configure a Server product
> select 1. SQL Server
> select 1. Configure a new Adaptive Server
> type ctrl-a to accept the default server name
> select 1. CONFIGURE SERVER'S INTERFACES FILE ENTRY
> select 3. Add a new listener service
> don't modify the default hostname/address
> select 2. Port:
> enter 4100
> type ctrl-a to Accept and Continue
> type y when prompted with Is this information correct?
> type ctrl-a to Accept and Continue
> type y when prompted with Write the changes to the interfaces file now?
> select 2. MASTER DEVICE CONFIGURATION
> type ctrl-a to Accept and Continue
> Press to continue, ignoring all WARNING's.
> select 3. SYBSYSTEMPROCS DATABASE CONFIGURATION
> type ctrl-a to Accept and Continue
> select 4. SET ERRORLOG LOCATION
> type ctrl-a to Accept and Continue
> select 5. CONFIGURE DEFAULT BACKUP SERVER
> type ctrl-a to Accept and Continue
> select 6. CONFIGURE LANGUAGES
> type ctrl-a to Accept and Continue
> select 7. CONFIGURE CHARACTER SETS
> type ctrl-a to Accept and Continue
> select 8. CONFIGURE SORT ORDER
> type ctrl-a to Accept and Continue
> select 9. CONFIGURE AUDITING
> type ctrl-a to Accept and Continue
> on the SYBASE SERVER CONFIGURATION screen, type ctrl-a to Accept and Continue
> type y when prompted with Execute the Sybase Server Configuration now?
> Press <return> to continue, ignoring all WARNING's.

If all goes well, you should see several Running task: and Task succeeded: messages. When you get a Configuration completed successfully message, press <return> to continue.

> type ctrl-x to Exit Screen
> type ctrl-x to Exit Screen
> type ctrl-x to Exit Screen

Starting the Database at Boot Time

Replace /usr/local/sybase with whatever directory Sybase ASE is installed in.

>     #!/bin/sh

>     export SYBASE=/usr/local/sybase

>     export PATH=$PATH:$SYBASE/bin:$SYBASE/install

>     case "$1" in
>             start)
>                     for i in `ls $SYBASE/install/RUN_*`
>                     do
>                             su -c "startserver -f $i" sybase > /dev/null 2>&1;
>                     done
>                     ;;
>             stop)
>                     kill `ps -efa | grep sybase | grep -v grep | awk '{print $2}'`
>                     ;;
>             *)
>                     echo $"Usage: $0 {start|stop}"
>                     exit 1
>     esac

>     exit 0

Install this script and run it with the "start" option to start up the database. Running it with the "stop" option shuts the database down. To access a database, it must be running.