HOWTO install Sybase Adaptive Server Enterprise 11.0.3.3 under Linux

[ ASE distribution packages ] [ Installing the rpm packages ] [ Pre install of ASE ] [ Post install of ASE ]
[ Start configuring ASE ] [ Login under sybase ] [ Sybinit and ASE ]

[ SYBINIT ]
[ CONFIGURE SERVER PRODUCTS ]
[ NEW OR EXISTING SQL SERVER ]
[ ADD NEW SQL SERVER ]
[ SQL SERVER CONFIGURATION ]
[ SERVER INTERFACES FILE ENTRY SCREEN ]
[ EDIT TCP SERVICE ]
[ SERVER INTERFACES FILE ENTRY SCREEN ]
[ MASTER DEVICE CONFIGURATION ]
[ SYBSYSTEMPROCS DATABASE CONFIGURATION ]
[ SET ERRORLOG LOCATION ]
[ CONFIGURE DEFAULT BACKUP SERVER ]
[ CONFIGURE LANGUAGES ]
[ CONFIGURE CHARACTER SETS ]
[ CONFIGURE SORT ORDER ]
[ ACTIVATE AUDITING ]
[ BUILD DEVICES AND BOOT THE SERVER ]
[ ADD NEW BACKUP SERVER ]
[ CONFIGURE CONNECTIVITY PRODUCTS ]

[ Done with sybinit ]

[ How should I proceed ? ]
[ Register and Sybase ASE Linux resources ]

[ ASE distribution packages ]


If appropriate you should have received the below listed packages. We advise you to contact your Linux distribution channel if your set is incomplete.

    [root@snippy wtenhave]# cd YOUR-RPMS-i386-archive-directory

    [root@snippy i386]# ls -1
    sybase-ase-11.0.3.3-1.i386.rpm
    sybase-doc-11.0.3.3-1.i386.rpm

What is inside?

The base packages "sybase-ase-11.0.3.3-1.i386.rpm" contains the complete Adaptive Server Enterprise 11.0.3.3 run-time and development area with full localization and character sets. ASE bundles the Sybase SQL Server, Backup server, Sybinit, Sybmon together with the Connectivity 10.0.4 Open Client / Open Server run-time libraries and ESQL/C.

Complete product documentation in Post Script is available in the documentation package "sybase-doc-11.0.3.3-1.i386.rpm"

[ Installing the "sybase-ase-11.0.3.3-1.i386.rpm" package. ]


Sybase Adaptive Server Enterprise by default installs in /opt/sybase.

Before you install make sure that there is enough space available. For full installation (this includes Post Script documentation) 200 MByte is required. Sybase Adaptive Server Enterprise without the Post Script documentation requires 120 MByte for a minimum.

After package installation the space occupied can be reduced by removing the development Open Client and Open Server Libraries if only a run-time environment is required.

[ Pre install of ASE ]


On "pre installation" rpm will present you the Sybase Adaptive Server Enterprise LICENSE agreements. We strongly advise you to read them before proceeding.


    [root@snippy i386]# rpm -q sybase-ase
    package sybase-ase is not installed

    [root@snippy i386]# rpm -i sybase-ase-11.0.3.3-1.i386.rpm

       SYBASE ADAPTIVE SERVER ENTERPRISE 11.0.3.3 SOFTWARE LICENSE AGREEMENT

       NOTICE TO USER: BY INSTALLING THIS SOFTWARE YOU ACCEPT ALL THE TERMS
       AND CONDITIONS OF THIS AGREEMENT. PLEASE READ THEM CAREFULLY.
			..
			..
        4. You agree not to use, or permit the use of, the Software for any
           purposes prohibited by U.S. law, including, without limitation,
           for the development, design or production of nuclear, chemical
           or biological weapons.


    DO YOU AGREE WITH THE LISTED LICENSE CONDITIONS? [Yes/No/List]: y

Congratulations, you did agree! Be patient and wait until the 120 MBytes make their way to your /opt/sybase filesystem. This can take minutes depending on the performance of your machine.

[ Post install of ASE ]


On "post installation" rpm will run a script, available from the release directory /opt/sybase/install/sybinstall.sh, installing a Database Administrator account and setting correct ownership and permissions on the release area.

If your system is configured for NIS you may wish to contact your NIS administrator before proceeding. The script will inform you if a NIS setup is detected. Strong advise from our side is to abort the installation and have the required user account setup under your NIS administration before proceeding. You can restart running the script later as 'root' at any time.


    Do you like this script to proceed by installing an account? [y/n]: y

    Group sybase was not found. Create it for you? [y/n]: y

       Group and permissions for /opt/sybase are set !

    User sybase was not found. Create it for you? [y/n]: y
    New UNIX password: 
    Retype new UNIX password: 
    passwd: all authentication tokens updated successfully

       User sybase is available, release user id is set !

       This completes your Sybase Adaptive Server Enterprise (ASE) package
       installation.  To run Sybase ASE, you may like to configure your master
       and sybsystemprocs databases by continuing the installation procedure after
       logging in as sybase and executing /opt/sybase/install/sybinit.

       This action is the default when you login for the first time.  To re-run
       the configuration remove the .readme and .sybinit files from the 'sybase'
       installation directory.

[ Start configuring ASE ]


Your are set now.

Sybase Adaptive Server Enterprise is installed on your platform in /opt/sybase.

Before you can start Sybase ASE 11.0.3.3 you need to configure a database server. Experienced Sybase Database Administrators may do this directly from the command line. If this is your first experience with Sybase Adaptive Server Enterprise you can start configuring a server with 'sybinit'.

You may also like to visit our online registration page and register. We would like to know if you're using Sybase Adaptive Server Enterprise as this may help us to turn it into a supported platform in the future.

Please visit:

Linux Sybase Registration Page

[ Login under sybase ]


Configure Sybase Adaptive Server Enterprise during your first login from the 'sybase' user account. After the installation of the rpm package you can either logout and login as 'sybase' or directly 'su - sybase' to the account.

The first time you login as user 'sybase', sybinit will start automatically.

The 'sybinit' binary is a menu driven program to configure all products delivered with this Sybase Adaptive Server Enterprise run-time environment.


    [root@snippy i386]# su - sybase

       This first time login as Database Administrator (DBA) will start
       configuring and running the Sybase Adaptive Server Enterprise (ASE)
       with help from 'sybinit'.  If you are unfamiliar or feel uncomfortable
       with this action and like to read the HOWTO or full documentation
       first,  you can either choose not to enter 'sybinit' or exit from the
       'sybinit' main menu by entering '^X'.

       Entering 'sybinit' can be done at any time by:

	    => Login under the 'sybase' DBA account.

            => Setup your environment (if not done by the login process)

       Bourne-Shell users

	    => $ . .profile

       C-Shell users:

	    => % source .cshrc

	    => Start 'sybinit'

	    $ $SYBASE/install/sybinit

       Complete release documentation and HOWTO's to configure this Sybase
       ASE release can be found under the $SYBASE/doc directory.

       Documentation towards any Sybase product can be found on our Dynaweb
       pages accessible from our World Wide page under documentation.

	    

       We also like you to Register your installation and read about the
       latest from our Sybase on Linux pages:

	    

       Enjoy this Sybase Adaptive Enterprise Server installation !


    Do you want to start 'sybinit' now? [y/n]: y

[ Sybinit and ASE ]


Before configuring Sybase ASE you need to define and know a few system resources. Sybase ASE is a network (TCP/IP) oriented SQL programmable database server.

To administrate your first dataserver you need to reserve some network port services. Verify that the ports you assign are not in use.

Configuring the dataserver does require a minimum of 37 MBytes of free disk space for initial master and sybsystemprocs database devices.

[ SYBINIT ]


Configure ASE with 'sybinit'


    The log file for this session is '/opt/sybase/init/logs/log0908.001'.

    SYBINIT

    1.  Release directory:  /opt/sybase

    2.  Edit / View Interfaces File

    3.  Configure a Server product
    4.  Configure an Open Client/Server product













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 3

3 => Configure a Server product.

Instruct 'sybinit' to configure the ASE environment for a SQL Server or Backup Server.

[ CONFIGURE SERVER PRODUCTS ]



    CONFIGURE SERVER PRODUCTS

    Products:

        Product                 Date Installed      Date Configured
    1.  SQL Server              05 Sep 1998 15:40
    2.  Backup Server           05 Sep 1998 15:40














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1

1 => SQL Server.

Instruct 'sybinit' to configure a SQL Server.

[ NEW OR EXISTING SQL SERVER ]


Instruct 'sybinit' to configure a new SQL Server. Your SQL Server will need a name. To connect to a designated SQL Server this name is also used by other Clients and Servers to reference.

As system administrator you may like to administrate the /etc/services file after the complete product configuration. This to make commands like 'netstat' produce listings with the service under a name. Also look at the section where we administrate the 'interfaces' file.


    NEW OR EXISTING SQL SERVER

    1.  Configure a new SQL Server
    2.  Configure an existing SQL Server
    3.  Upgrade an existing SQL Server
















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1

1 => Configure a new SQL Server.

Instruct 'sybinit' to configure a new SQL Server.

[ ADD NEW SQL SERVER ]


If you like to change the SQL Server name to anything other then the default 'SYBASE', you should do it now.


    ADD NEW SQL SERVER

    1.  SQL Server name:  SYBASE


















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

1 => SQL Server name.

Ctrl-a => Accept and Continue

[ SQL SERVER CONFIGURATION ]


SQL SERVER CONFIGURATION

The listed menu shows the 9 steps which all need to be completed before 'sybinit' can boot your configured SQL Server for the first time.


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                Incomplete

    2.  MASTER DEVICE CONFIGURATION                             Incomplete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                   Incomplete
    4.  SET ERRORLOG LOCATION                                   Incomplete
    5.  CONFIGURE DEFAULT BACKUP SERVER                         Incomplete
    
    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1

1 => CONFIGURE SERVER'S INTERFACES FILE ENTRY

This step is a shortcut to the 'SERVER INTERFACES FILE ENTRY SCREEN'. Within this 'interfaces' editor we configure the network service for the SQL Server, Backup or other ASE services provided. The network service requires an IP address (or hostname) and port to listen to.

In this example the Sybase SQL Server is administrated under the name 'SYBASE'.

[ SERVER INTERFACES FILE ENTRY SCREEN ]


Edit the TCP service for the SQL Server 'SYBASE'. By default 'sybinit' will prompt with the correct hostname. To administrate the service correctly you need to assign a free port for the SQL Server to listen to.


    SERVER INTERFACES FILE ENTRY SCREEN

        Server name:  SYBASE

    1.  Retry Count:  0
    2.  Retry Delay:  0

    3.  Add a new listener service













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 3

3 => Add a new listener service

Fill in the specific details for the current ASE server 'SYBASE'

The 'Retry Count' and 'Retry Delay' info can be left as is. You may need to administrate them if many concurrent clients cause severe performance impact on your system installation. This can be administrated later at any time.

[ EDIT TCP SERVICE ]


The example below shows that for the SQL Server name SYBASE the server will listen to 'Port' 7100 available from the 'Host' snippy.


    EDIT TCP SERVICE

    1.  Hostname/Address: snippy.sybase.com
    2.  Port:
    3.  Name Alias:

    4.  Delete this service from the interfaces entry














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 2
    Enter the port number to use for this entry (default is ''):
    7100

2 => Port:

Select 2 and enter a port available. Assure yourself that the service administrated is not in use!

Ctrl-a => Accept and Continue

If your administration completed you can continue.

[ Accept and Continue ]



    EDIT TCP SERVICE

    1.  Hostname/Address: snippy.sybase.com
    2.  Port: 7100
    3.  Name Alias:

    4.  Delete this service from the interfaces entry














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Is this information correct? y

y => acknowledge correct information (Hostname='snippy.sybase.com', Port='7100')

[ SERVER INTERFACES FILE ENTRY SCREEN ]


The Sybase ASE 'interfaces' file should now be written to the release area.


    SERVER INTERFACES FILE ENTRY SCREEN

        Server name:  SYBASE

    1.  Retry Count:  0
    2.  Retry Delay:  0

    3.  Add a new listener service

    Modify or delete a service

    Listener services available:

        Protocol  Address          Port          Name Alias
    4.  tcp       snippy.sybase.c  7100






    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Write the changes to the interfaces file now? y

y => To write the changes to the interfaces file.

[ MASTER DEVICE CONFIGURATION ]


SQL SERVER CONFIGURATION "MASTER DEVICE CONFIGURATION"

Instruct 'sybinit' to configure the Sybase ASE master device location.


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                             Incomplete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                   Incomplete
    4.  SET ERRORLOG LOCATION                                   Incomplete
    5.  CONFIGURE DEFAULT BACKUP SERVER                         Incomplete

    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 2

2 => MASTER DEVICE CONFIGURATION

[ MASTER DEVICE CONFIGURATION ]


If this is your first configuration, go for the default! You may wish to alter the device location to be located on another filesystem or have it build on a raw device. When selecting a raw device 'sybinit' will by itself detect the available space. The device size for the 'master device' needs 21 MByte for minimum space.


    MASTER DEVICE CONFIGURATION

    1.  Master Device:  /opt/sybase/master.dat

    2.  Size (Meg):  21
















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: Ctrl-a

    WARNING: '/opt/sybase/master.dat' is a regular file which is
    	     not recommended for a Server device.
    Press  to continue.  

Ctrl-a => Accept and Continue

The warning can be ignored.

[ SYBSYSTEMPROCS DATABASE CONFIGURATION ]


SQL SERVER CONFIGURATION "SYBSYSTEMPROCS DATABASE CONFIGURATION"

Instruct 'sybinit' to configure the 'sybsystemprocs' database. The Sybsystemprocs database is used to hold the Sybase(tm) system stored procedures. By default the Sybase ASE environment is equipped with a set of stored procedures to ease the life of the Database Administrator.


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                   Incomplete
    4.  SET ERRORLOG LOCATION                                   Incomplete
    5.  CONFIGURE DEFAULT BACKUP SERVER                         Incomplete

    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 3

3 => SYBSYSTEMPROCS DATABASE CONFIGURATION

[ SYBSYSTEMPROCS DATABASE CONFIGURATION ]


This device can also be build on a raw partitions and should have at least a minumim size of 16 MBytes.


    SYBSYSTEMPROCS DATABASE CONFIGURATION

    1.  sybsystemprocs database size (Meg):  16

    2.  sybsystemprocs logical device name:  sysprocsdev

    3.  create new device for the sybsystemprocs database:  yes

    4.  physical name of new device:  /opt/sybase/sybprocs.dat

    5.  size of the new device (Meg):  16










    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ SET ERRORLOG LOCATION ]


SQL SERVER CONFIGURATION "SET ERRORLOG LOCATION"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                   Incomplete
    5.  CONFIGURE DEFAULT BACKUP SERVER                         Incomplete

    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 4

4 => SET ERRORLOG LOCATION

[ SET ERRORLOG LOCATION ]


The Sybase SQL Server needs a location to log SQL Server server and kernel messages. The file named 'errorlog' is an ASCII file and can be compared to the Unix /var/log/messages file. It does contain boot, erroneous and security violation events reported by the SQL Server. Inspection of the file from time to time is highly recommended.


    SET ERRORLOG LOCATION

    1.  SQL Server errorlog:  /opt/sybase/install/errorlog


















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ CONFIGURE DEFAULT BACKUP SERVER ]


SQL SERVER CONFIGURATION "CONFIGURE DEFAULT BACKUP SERVER"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                         Incomplete

    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 5

5 => CONFIGURE DEFAULT BACKUP SERVER

[ CONFIGURE DEFAULT BACKUP SERVER ]


Data stored in Databases controlled by the Sybase Adaptive Server Enterprise does need a backup from time to time. Sure you can directly backup the database files from the operating system, though doing such does not guarantee a transaction consistent model. If data within the database needs a backup the Sybase Backup Server should be used to assure you of a transaction consistent model.

At this time the SQL Server needs to know the Sybase service for its Backup Server as given under SYB_BACKUP.


    SET THE SQL SERVER'S BACKUP SERVER

    1.  SQL Server Backup Server name:  SYB_BACKUP











    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue.

[ CONFIGURE LANGUAGES ]


SQL SERVER CONFIGURATION "CONFIGURE LANGUAGES"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                           Complete

    6.  CONFIGURE LANGUAGES                                     Incomplete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 6

6 => CONFIGURE LANGUAGES

[ CONFIGURE LANGUAGES ]


Feel free to install any of the possible selections listed. By default 'sybinit' selects the us_english locale setup.


    CONFIGURE LANGUAGES

        Current default language:  us_english
        Current default character set: 
		ISO 8859-1 (Latin-1) - Western European 8-bcharacter set.
        Current sort order: 
		Binary ordering, for the ISO 8859/1 or Latin-1 charact (iso_1).

    Select the language you want to install, remove, or designate as
    the default language.
        Language                  Installed?  Remove      Install    Make default
    1.  us_english                yes         no          no         yes
    2.  chinese                   no          no          no         no
    3.  french                    no          no          no         no
    4.  german                    no          no          no         no
    5.  japanese                  no          no          no         no
    6.  spanish                   no          no          no         no




    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ CONFIGURE CHARACTER SETS ]


SQL SERVER CONFIGURATION "CONFIGURE CHARACTER SETS"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                           Complete

    6.  CONFIGURE LANGUAGES                                       Complete
    7.  CONFIGURE CHARACTER SETS                                Incomplete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 7

7 => CONFIGURE CHARACTER SETS

[ CONFIGURE CHARACTER SETS ]


The character set and sort order may require configuration specific details. Altering the information below does imply that 'sybinit' will load additional info into the master database.


    CONFIGURE CHARACTER SETS

        Current default language:  us_english
        Current default character set:  
		ISO 8859-1 (Latin-1) - Western European 8-b character set.
        Current sort order: 
		Binary ordering, for the ISO 8859/1 or Latin-1 charact (iso_1).

    Select the character set you want to install, remove, or designate as
    the default set character

        Character set             Installed?  Remove      Install    Make default
    1.  ASCII, for use with unsp  yes         no          no         no
    2.  Code Page 437, (United S  no          no          no         no
    3.  Code Page 850 (Multiling  no          no          no         no
    4.  ISO 8859-1 (Latin-1) - W  yes         no          no         yes
    5.  Macintosh default charac  no          no          no         no
    6.  Hewlett-Packard propriet  no          no          no         no



    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ CONFIGURE SORT ORDER ]


SQL SERVER CONFIGURATION "CONFIGURE SORT ORDER"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                           Complete

    6.  CONFIGURE LANGUAGES                                       Complete
    7.  CONFIGURE CHARACTER SETS                                  Complete
    8.  CONFIGURE SORT ORDER                                    Incomplete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 8

8 => CONFIGURE SORT ORDER

[ CONFIGURE SORT ORDER ]


Default sort order can be configured here.


    CONFIGURE SORT ORDER

        Current default language:  us_english
        Current default character set:  
		ISO 8859-1 (Latin-1) - Western European 8-b character set.
        Current sort order: 
		Binary ordering, for the ISO 8859/1 or Latin-1 charact (iso_1).

    Select a sort order.

        Sort Order                                                        Chosen
    1.  Binary ordering, for the ISO 8859/1 or Latin-1 character set (is  yes
    2.  General purpose dictionary ordering.                              no
    3.  Spanish dictionary ordering.                                      no
    4.  Spanish case and accent insensitive dictionary order.             no
    5.  Spanish case insensitive dictionary order.                        no
    6.  Dictionary order, case insensitive, accent insensitive.           no
    7.  Dictionary order, case insensitive.                               no
    8.  Dictionary order, case insensitive with preference.               no


    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ ACTIVATE AUDITING ]


SQL SERVER CONFIGURATION "ACTIVATE AUDITING"


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                           Complete

    6.  CONFIGURE LANGUAGES                                       Complete
    7.  CONFIGURE CHARACTER SETS                                  Complete
    8.  CONFIGURE SORT ORDER                                      Complete

    9.  ACTIVATE AUDITING                                       Incomplete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 9

9 => ACTIVATE AUDITING

[ ACTIVATE AUDITING ]


By default auditing is not enabled. If you like to enable it this is the moment in time. You also may decide to configure an additional device for this database.


    ACTIVATE AUDITING

    1.  Install auditing:  no

    2.  sybsecurity database size (Meg):  5

    3.  sybsecurity logical device name:  sybsecurity

    4.  create new device for the sybsecurity database:  no












    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ BUILD DEVICES AND BOOT THE SERVER ]


SQL SERVER CONFIGURATION "BUILD DEVICES AND BOOT THE SERVER"

If all options are completed, sybinit will create the configured devices and databases and boot your SQL Server for the first time.


    SQL SERVER CONFIGURATION

    1.  CONFIGURE SERVER'S INTERFACES FILE ENTRY                  Complete

    2.  MASTER DEVICE CONFIGURATION                               Complete
    3.  SYBSYSTEMPROCS DATABASE CONFIGURATION                     Complete
    4.  SET ERRORLOG LOCATION                                     Complete
    5.  CONFIGURE DEFAULT BACKUP SERVER                           Complete

    6.  CONFIGURE LANGUAGES                                       Complete
    7.  CONFIGURE CHARACTER SETS                                  Complete
    8.  CONFIGURE SORT ORDER                                      Complete

    9.  ACTIVATE AUDITING                                         Complete







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Execute the SQL Server Configuration now? y

You continue by entering 'Ctrl-a'.

y => Execute the SQL Server Configuration now

[ BUILD DEVICES AND BOOT THE SERVER ]


Building the database devices and booting the server does take some time. The process completion may take up to 30 minutes depending on the overall performance of your platform. It is highly recommended to install the Sybase ASE server only on platforms with a minimum memory configuration of 64 MByte and fast physical disk I/O.


    WARNING: '/opt/sybase/master.dat' is a regular file
    	     which is not recommended for a Server device.
    Press  to continue.
    Running task: create the master device.
    Building the master device
    ...Done
    Task succeeded: create the master device.
    Running task: update the SQL Server runserver file.
    Task succeeded: update the SQL Server runserver file.
    Running task: boot the SQL Server.
    waiting for server 'SYBASE' to boot...
    Task succeeded: boot the SQL Server.
    Running task: create the sybsystemprocs database.
    sybsystemprocs database created.
    Task succeeded: create the sybsystemprocs database.
    Running task: install system stored procedures.
    ...............................................................
    ...............................................................
    ...........................................................Done
    Task succeeded: install system stored procedures.
    Running task: set permissions for the 'model' database.
    Done
    Task succeeded: set permissions for the 'model' database.
    Running task: set the default character set and/or default
    	sort order for the SQL Server.
    Setting the default character set to iso_1
    Sort order 'binary' has already been installed.
    Character set 'iso_1' is already the default.
    Sort order 'binary' is already the default.
    Task succeeded: set the default character set and/or default
    	sort order for the SQL Server.
    Running task: set the default language.
    Setting the default language to us_english
    Language 'us_english' is already the default.
    Task succeeded: set the default language.

    Configuration completed successfully.
    Press  to continue.

Enter return to get back to the 'sybinit' configuration screens.

[ BACK TO THE MAIN MENU ]


Your Sybase SQL Server is configured and running. You may check from an other terminal using 'ps' and 'netstat'.


    NEW OR EXISTING SQL SERVER

    1.  Configure a new SQL Server
    2.  Configure an existing SQL Server
    3.  Upgrade an existing SQL Server











    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ BACK TO THE MAIN MENU ]


Back in the CONFIGURE SERVER PRODUCTS menu. Do not configure the Backup Server now but let us go to the 'interfaces' editor first.


    CONFIGURE SERVER PRODUCTS

    Products:

        Product                 Date Installed      Date Configured
    1.  SQL Server              05 Sep 1998 15:40   08 Sep 1998 22:03
    2.  Backup Server           05 Sep 1998 15:40











    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ WHAT NEXT ]


SYBINIT Main menu

The screens below show examples on other topics to configure. Please take some time to browse them and use your imagination.


    SYBINIT

    1.  Release directory:  /opt/sybase

    2.  Edit / View Interfaces File

    3.  Configure a Server product
    4.  Configure an Open Client/Server product













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 2

2 => Edit / View Interfaces File

[ NEXT ]


Sybinit can be used to administrate the 'interfaces' file. The interfaces file is in ASCII text format describing the Sybase services under a name and assigning network IP addresses with port.


    INTERFACES FILE TOP SCREEN

    Interfaces File:

    1.  Add a new entry
    2.  Modify an existing entry
    3.  View an existing entry
    4.  Delete an existing entry













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1

1 => Add a new entry

[ NEXT ]


CREATE NEW INTERFACES FILE


    CREATE NEW INTERFACES FILE ENTRY

    1.  Server name:


















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1
    Enter the name of the server to add (default is ''):
    SYB_BACKUP

1 => Server name

[ NEXT ]


For the Backup Server server we registered the default name 'SYB_BACKUP'.


    CREATE NEW INTERFACES FILE ENTRY

    1.  Server name:  SYB_BACKUP


















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ NEXT ]


SERVER INTERFACES FILE ENTRY SCREEN


    SERVER INTERFACES FILE ENTRY SCREEN

        Server name:  SYB_BACKUP

    1.  Retry Count:  0
    2.  Retry Delay:  0

    3.  Add a new listener service













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 3

3 => Add a new listener service

[ NEXT ]


EDIT TCP SERVICE


    EDIT TCP SERVICE

    1.  Hostname/Address: snippy.sybase.com
    2.  Port:
    3.  Name Alias:

    4.  Delete this service from the interfaces entry














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 2
    Enter the port number to use for this entry (default is ''):
    7110

2 => Port

[ NEXT ]


The SYB_BACKUP is configured for Hostname 'snippy' and Port '7110'


    EDIT TCP SERVICE

    1.  Hostname/Address: snippy.sybase.com
    2.  Port: 7110
    3.  Name Alias:

    4.  Delete this service from the interfaces entry














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Is this information correct? y

Ctrl-a => Accept and Continue

[ NEXT ]


Acknowledge the configuration to 'sybinit'


    SERVER INTERFACES FILE ENTRY SCREEN

        Server name:  SYB_BACKUP

    1.  Retry Count:  0
    2.  Retry Delay:  0

    3.  Add a new listener service

    Modify or delete a service

    Listener services available:

        Protocol  Address          Port          Name Alias
    4.  tcp       snippy.sybase.c  7110






    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Write the changes to the interfaces file now? y

Ctrl-a => Accept and Continue

Force 'sybinit' to update the 'interfaces' file.

[ NEXT ]


INTERFACES FILE TOP SCREEN


    INTERFACES FILE TOP SCREEN

    Interfaces File:

    1.  Add a new entry
    2.  Modify an existing entry
    3.  View an existing entry
    4.  Delete an existing entry













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ NEXT ]


SYBINIT


    SYBINIT

    1.  Release directory:  /opt/sybase

    2.  Edit / View Interfaces File

    3.  Configure a Server product
    4.  Configure an Open Client/Server product













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 3

3 => Configure a Server product

[ NEXT ]


CONFIGURE SERVER PRODUCTS "Backup Server"


    CONFIGURE SERVER PRODUCTS

    Products:

        Product                 Date Installed      Date Configured
    1.  SQL Server              05 Sep 1998 15:40   08 Sep 1998 22:03
    2.  Backup Server           05 Sep 1998 15:40














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 2

2 => Backup Server

[ NEXT ]


NEW OR EXISTING BACKUP SERVER


    NEW OR EXISTING BACKUP SERVER

    1.  Configure a new Backup Server
    2.  Configure an existing Backup Server

















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1

1 => Configure a new Backup Server

[ ADD NEW BACKUP SERVER ]


ADD NEW BACKUP SERVER


    ADD NEW BACKUP SERVER

    1.  Backup Server name:  SYB_BACKUP


















    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ BACKUP SERVER CONFIGURATION ]


BACKUP SERVER CONFIGURATION

Below we request 'sybinit' to start the Backup Server with default settings. Like the SQL Server the Backup Server can be configured for optional locale and character settings.


    BACKUP SERVER CONFIGURATION

    1.  Backup Server errorlog:  /opt/sybase/install/backup.log
    2.  Enter / Modify Backup Server interfaces file information
    3.  Backup Server language:  us_english
    4.  Backup Server character set:  iso_1
    5.  Backup Server tape configuration file: /opt/sybase/backup_tape.cfg










    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:
    Execute the Backup Server configuration now? y
    Running task: update the Backup Server runserver file.
    Task succeeded: update the Backup Server runserver file.
    Running task: boot the Backup Server.
    waiting for server 'SYB_BACKUP' to boot...
    Task succeeded: boot the Backup Server.

    Configuration completed successfully.
    Press  to continue.

return

[ NEXT ]


Go all the way back to the main SYBINIT screen.


    NEW OR EXISTING BACKUP SERVER

    1.  Configure a new Backup Server
    2.  Configure an existing Backup Server













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ NEXT ]


CONFIGURE SERVER PRODUCTS


    CONFIGURE SERVER PRODUCTS

    Products:

        Product                 Date Installed      Date Configured
    1.  SQL Server              05 Sep 1998 15:40   08 Sep 1998 22:03
    2.  Backup Server           05 Sep 1998 15:40   08 Sep 1998 22:04














    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ NEXT ]


SYBINIT


    SYBINIT

    1.  Release directory:  /opt/sybase

    2.  Edit / View Interfaces File

    3.  Configure a Server product
    4.  Configure an Open Client/Server product













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 4

4 => Ctrl-a Accept and Continue

[ CONFIGURE CONNECTIVITY PRODUCTS ]


CONFIGURE CONNECTIVITY PRODUCTS

The steps below will configure your Open Client and Open Server Sybase ASE environment. This is not needed for the Linux installation since all the products are configured within one single rpm package.

Completing the steps will guarantee that the correct libraries and supporting files are installed on your system.


    CONFIGURE CONNECTIVITY PRODUCTS

    Products:

        Product                 Date Installed    Date Configured
    1.  Open Client Library     05 Sep 1998 15:4
    2.  Open Server Library     05 Sep 1998 15:4
    3.  Embedded SQL/C Precomp  05 Sep 1998 15:4







    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return: 1
    Running task: initialize Open Client Library.

    Successfully initialized 'Open Client Library'.
    Press  to continue.
    Task succeeded: initialize Open Client Library.

    Configuration completed successfully.
    Press  to continue.


CONFIGURE CONNECTIVITY PRODUCTS Products: Product Date Installed Date Configured 1. Open Client Library 05 Sep 1998 15:4 08 Sep 1998 22:0 2. Open Server Library 05 Sep 1998 15:4 3. Embedded SQL/C Precomp 05 Sep 1998 15:4 Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. Enter the number of your choice and press return: 2 Running task: initialize Open Server Library. Successfully initialized 'Open Server Library'. Press to continue. Task succeeded: initialize Open Server Library. Configuration completed successfully. Press to continue.
CONFIGURE CONNECTIVITY PRODUCTS Products: Product Date Installed Date Configured 1. Open Client Library 05 Sep 1998 15:4 08 Sep 1998 22:0 2. Open Server Library 05 Sep 1998 15:4 08 Sep 1998 22:0 3. Embedded SQL/C Precomp 05 Sep 1998 15:4 Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. Enter the number of your choice and press return: 3 Running task: initialize Embedded SQL C Precompiler. Successfully initialized 'Embedded SQL/C Precompiler'. Press to continue. Task succeeded: initialize Embedded SQL C Precompiler. Configuration completed successfully. Press to continue.
CONFIGURE CONNECTIVITY PRODUCTS Products: Product Date Installed Date Configured 1. Open Client Library 05 Sep 1998 15:4 08 Sep 1998 22:0 2. Open Server Library 05 Sep 1998 15:4 08 Sep 1998 22:0 3. Embedded SQL/C Precomp 05 Sep 1998 15:4 08 Sep 1998 22:0 Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help. Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ LEAVING SYBINIT ]


SYBINIT


    SYBINIT

    1.  Release directory:  /opt/sybase

    2.  Edit / View Interfaces File

    3.  Configure a Server product
    4.  Configure an Open Client/Server product













    Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.

    Enter the number of your choice and press return:

Ctrl-a => Accept and Continue

[ NEXT ]


You're now set to connect to your configured SQL Server for the first time.

Please login as 'sybase' again and if things proceeded fine, you will find the shell prompt waiting.


    Exiting.
    The log file for this session is '/opt/sybase/init/logs/log0908.001'.

[ Where and how proceed ? ]


Login to your SQL Server, load databases, check the engine tasks make a backup and check the server configuration options. Please read the documentation and ask in the news groups to get you going beyond the initial Sybase Adaptive Server Enterprise setup.


    [sybase@snippy sybase]$ isql -Usa -P
    1> select @@version
    2> go
    
    
    
    	---------------------------------------------------------------------------------------
    
    	 SQL Server/11.0.3.3/P/Linux Intel/Linux 2.0.36 i586/1/OPT/Sun Sep  6 09:36:01 CEST 1998
    
    (1 row affected)
    1> sp_who
    2> go
     spid   status       loginame     hostname   blk   dbname     cmd
     ------ ------------ ------------ ---------- ----- ---------- ----------------
          1 running      sa           snippy.syb 0     master     SELECT
          2 sleeping     NULL                    0     master     NETWORK HANDLER
          3 sleeping     NULL                    0     master     DEADLOCK TUNE
          4 sleeping     NULL                    0     master     MIRROR HANDLER
          5 sleeping     NULL                    0     master     HOUSEKEEPER
          6 sleeping     NULL                    0     master     CHECKPOINT SLEEP
    
    (6 rows affected, return status = 0)
    1> SYB_BACKUP...sp_who
    2> go
     spid        status     loginame     hostname   blk cmd
     ----------- ---------- ------------ ---------- --- ----------------
               1 sleeping   NULL         NULL       0   CONNECT HANDLER
               2 sleeping   NULL         NULL       0   DEFERRED HANDLER
               3 runnable   NULL         NULL       0   SCHEDULER
               5 runnable   NULL         NULL       0   SITE HANDLER
    
    (5 rows affected)
    1>
    
    [sybase@snippy sybase]$ isql -Usa -P -i ${SYBASE}/scripts/installpubs2
    Creating the "pubs2" database
    CREATE DATABASE: allocating 1024 pages on disk 'master'
    Type added.
    (return status = 0)
    Type added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New primary key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    New foreign key added.
    (return status = 0)
    Default bound to column.
    (return status = 0)
    Default bound to column.
    (return status = 0)
    Default bound to column.
    (return status = 0)
    Rule bound to table column.
    (return status = 0)
    Rule bound to table column.
    (return status = 0)
    Rule bound to table column.
    (return status = 0)
    (return status = 0)

    [sybase@snippy sybase]$ isql -Usa -P
    1> sp_helpdb
    2> go
     name                     db_size       owner                    dbid
    	 created
    	 status
     ------------------------ ------------- ------------------------ ------
    	--------------
    	------------------------------------------------------------------------------------------------------
     master                          5.0 MB sa                            1
    	 Jan 01, 1900
    	 no options set
     model                           2.0 MB sa                            3
    	 Jan 01, 1900
    	 no options set
     pubs2                           2.0 MB sa                            5
    	 Sep 08, 1998
    	 no options set
     sybsystemprocs                 16.0 MB sa                            4
    	 Sep 08, 1998
    	 trunc log on chkpt
     tempdb                          2.0 MB sa                            2
    	 Sep 08, 1998
    	 select into/bulkcopy
    
    (return status = 0)
    1> use pubs2
    2> go
    1> select * from titles
    2> order by price
    3> go
     title_id
    	 title
    	 type         pub_id price                    advance
    	 total_sales
    	 notes
    	 pubdate                    contract
     --------
    	--------------------------------------------------------------------------------
    	------------ ------ ------------------------ ------------------------
    	-----------
    	--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    	-------------------------- --------
     MC3026
    	 The Psychology of Computer Cooking
    	 UNDECIDED    0877                       NULL                     NULL
    	        NULL
    	 NULL
    	        Sep  8 1998 10:05PM        0
     PC9999
    	 Net Etiquette
    	 popular_comp 1389                       NULL                     NULL
    	        NULL
    	 A must-read for computer conferencing debutantes!
    	        Sep  8 1998 10:05PM        0
     BU2075
    	 You Can Combat Computer Stress!
    	 business     0736                       2.99                10,125.00
    	       18722
    	 The latest medical and psychological techniques for living with the electronic office.  Easy-to-understand explanations.
    	        Jun 30 1985 12:00AM        1
     MC3021
    	 The Gourmet Microwave
    	 mod_cook     0877                       2.99                15,000.00
    	       22246
    	 Traditional French gourmet recipes adapted for modern microwave cooking.
    	        Jun 18 1985 12:00AM        1
     PS2106
    	 Life Without Fear
    	 psychology   0736                       7.00                 6,000.00
    	         111
    	 New exercise, meditation, and nutritional techniques that can reduce the shock of daily interactions. Popular audience.  Sample menus included, exercise video available separately.
    	        Oct  5 1990 12:00AM        1
     PS7777
    	 Emotional Security: A New Algorithm
    	 psychology   0736                       7.99                 4,000.00
    	        3336
    	 Protecting yourself and your loved ones from undue emotional stress in the modern world.  Use of computer and nutritional aids emphasized.
    	        Jun 12 1988 12:00AM        1
     PS2091
    	 Is Anger the Enemy?
    	 psychology   0736                      10.95                 2,275.00
    	        2045
    	 Carefully researched study of the effects of strong emotions on the body.  Metabolic charts included.
    	        Jun 15 1989 12:00AM        1
     BU1111
    	 Cooking with Computers: Surreptitious Balance Sheets
    	 business     1389                      11.95                 5,000.00
    	        3876
    	 Helpful hints on how to use your electronic resources to the best advantage.
    	        Jun  9 1988 12:00AM        1
     TC4203
    	 Fifty Years in Buckingham Palace Kitchens
    	 trad_cook    0877                      11.95                 4,000.00
    	       15096
    	 More anecdotes from the Queen's favorite cook describing life among English royalty.  Recipes, techniques, tender vignettes.
    	        Jun 12 1985 12:00AM        1
     TC7777
    	 Sushi, Anyone?
    	 trad_cook    0877                      14.99                 8,000.00
    	        4095
    	 Detailed instructions on improving your position in life by learning how to make authentic Japanese sushi in your spare time.  5-10% increase in number of friends per recipe reported from beta test.
    	        Jun 12 1987 12:00AM        1
     BU1032
    	 The Busy Executive's Database Guide
    	 business     1389                      19.99                 5,000.00
    	        4095
    	 An overview of available database systems with emphasis on common business applications.  Illustrated.
    	        Jun 12 1986 12:00AM        1
     BU7832
    	 Straight Talk About Computers
    	 business     1389                      19.99                 5,000.00
    	        4095
    	 Annotated analysis of what computers can do for you: a no-hype guide for the critical user.
    	        Jun 22 1987 12:00AM        1
     MC2222
    	 Silicon Valley Gastronomic Treats
    	 mod_cook     0877                      19.99                     0.00
    	        2032
    	 Favorite recipes for quick, easy, and elegant meals, tried and tested by people who never have time to eat, let alone cook.
    	        Jun  9 1989 12:00AM        1
     PS3333
    	 Prolonged Data Deprivation: Four Case Studies
    	 psychology   0736                      19.99                 2,000.00
    	        4072
    	 What happens when the data runs dry?  Searching evaluations of information-shortage effects on heavy users.
    	        Jun 12 1988 12:00AM        1
     PC8888
    	 Secrets of Silicon Valley
    	 popular_comp 1389                      20.00                 8,000.00
    	        4095
    	 Muckraking reporting by two courageous women on the world's largest computer hardware and software manufacturers.
    	        Jun 12 1987 12:00AM        1
     TC3218
    	 Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean
    	 trad_cook    0877                      20.95                 7,000.00
    	         375
    	 Profusely illustrated in color, this makes a wonderful gift book for a cuisine-oriented friend.
    	        Oct 21 1990 12:00AM        1
     PS1372
    	 Computer Phobic and Non-Phobic Individuals: Behavior Variations
    	 psychology   0877                      21.59                 7,000.00
    	         375
    	 A must for the specialist, this book examines the difference between those who hate and fear computers and those who think they are swell.
    	        Oct 21 1990 12:00AM        1
     PC1035
    	 But Is It User Friendly?
    	 popular_comp 1389                      22.95                 7,000.00
    	        8780
    	 A survey of software for the naive user, focusing on the 'friendliness' of each.
    	        Jun 30 1986 12:00AM        1
    
    (18 rows affected)

    1> use master
    2> go

    1> dump database pubs2 to "/tmp/pubs2"
    2> go
    Backup Server session id is:  7.  Use this value when executing the
    'sp_volchanged' system stored procedure after fulfilling any volume change
    request from the Backup Server.
    Backup Server: 4.41.1.1: Creating new disk file /tmp/pubs2.
    Backup Server: 6.28.1.1: Dumpfile name 'pubs298251136FE  ' section number 0001
    mounted on disk file '/tmp/pubs2'
    Backup Server: 4.58.1.1: Database pubs2: 770 kilobytes DUMPed.
    Backup Server: 3.43.1.1: Dump phase number 1 completed.
    Backup Server: 3.43.1.1: Dump phase number 2 completed.
    Backup Server: 3.43.1.1: Dump phase number 3 completed.
    Backup Server: 4.58.1.1: Database pubs2: 778 kilobytes DUMPed.
    Backup Server: 3.42.1.1: DUMP is complete (database pubs2).

    1> shutdown SYB_BACKUP
    2> go
    Backup Server: 3.48.1.1: The Backup Server will go down immediately.
    Terminating sessions.

    1> shutdown
    2> go
    Server SHUTDOWN by request.
    The SQL Server is terminating this process.
    DB-LIBRARY error:
    	Unexpected EOF from SQL Server.

    [sybase@snippy sybase]$ cd install/
    [sybase@snippy install]$ ./startserver -f ./RUN_SYBASE
    [sybase@snippy install]$ 00:1998/09/08 22:07:29.80 kernel  Using config area from primary master device.
    00:1998/09/08 22:07:30.00 kernel  Warning: Using default file
    '/opt/sybase/SYBASE.cfg' since a configuration file was not specified.
    Specify a configuration file name in the RUNSERVER file to avoid this message.
    00:1998/09/08 22:07:30.02 kernel  Using 256 file descriptors.
    00:1998/09/08 22:07:30.02 kernel  SQL Server/11.0.3.3/P/Linux Intel/Linux 2.0.36 i586/1/OPT/Sun Sep  6 09:36:01 CEST 1998
    00:1998/09/08 22:07:30.02 kernel  (c) Copyright 1987, 1998.
    00:1998/09/08 22:07:30.02 kernel  Sybase, Inc.  All rights reserved.
    00:1998/09/08 22:07:30.03 kernel
    00:1998/09/08 22:07:30.03 kernel  Unpublished rights reserved under U.S. copyright laws.
    00:1998/09/08 22:07:30.03 kernel  This software contains confidential and trade secret information of Sybase,
    00:1998/09/08 22:07:30.03 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
    00:1998/09/08 22:07:30.03 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
    00:1998/09/08 22:07:30.03 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
    00:1998/09/08 22:07:30.03 kernel  agreement  specifying  the  Government's rights to use the software and any
    00:1998/09/08 22:07:30.03 kernel  applicable FAR provisions, for example, FAR 52.227-19.
    00:1998/09/08 22:07:30.04 kernel
    00:1998/09/08 22:07:30.04 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA.
    00:1998/09/08 22:07:30.04 kernel  Using '/opt/sybase/SYBASE.cfg' for configuration information.
    00:1998/09/08 22:07:30.04 kernel  Logging SQL Server messages in file '/opt/sybase/install/errorlog'
    .
    00:1998/09/08 22:07:30.06 kernel  Network and device connection limit is 246.
    00:1998/09/08 22:07:30.14 server  Number of proc buffers allocated: 472.
    00:1998/09/08 22:07:30.35 server  Number of blocks left for proc headers: 519.
    00:1998/09/08 22:07:30.36 server  Memory allocated for the default data cache cache: 3544 Kb
    00:1998/09/08 22:07:30.37 server  Size of the 2K memory pool: 3544 Kb
    00:1998/09/08 22:07:30.38 kernel  Initializing virtual device 0, '/opt/sybase/master.dat'
    00:1998/09/08 22:07:30.38 kernel  Virtual device 0 started using standard unix i/o.
    00:1998/09/08 22:07:30.38 server  No active traceflags
    00:1998/09/08 22:07:30.43 server  Opening Master Database ...
    00:1998/09/08 22:07:30.68 server  Loading SQL Server's default sort order and character set
    00:1998/09/08 22:07:30.70 kernel  network name snippy.sybase.com, type ether, port 7100
    00:1998/09/08 22:07:30.76 server  Recovering database 'master'
    00:1998/09/08 22:07:30.78 server  Recovery dbid 1 ckpt (2005,9)
    00:1998/09/08 22:07:30.78 server  Recovery no active transactions before ckpt.
    00:1998/09/08 22:07:31.09 server  Database 'master' is now online.
    00:1998/09/08 22:07:31.11 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:31.11 server  0 dump conditions detected at boot time
    00:1998/09/08 22:07:31.18 server  server is unnamed
    00:1998/09/08 22:07:31.22 server  Activating disk 'sysprocsdev'.
    00:1998/09/08 22:07:31.22 kernel  Initializing virtual device 1, '/opt/sybase/sybprocs.dat'
    00:1998/09/08 22:07:31.22 kernel  Virtual device 1 started using standard unix i/o.
    00:1998/09/08 22:07:31.48 server  Recovering database 'model'.
    00:1998/09/08 22:07:31.48 server  Recovery dbid 3 ckpt (431,34)
    00:1998/09/08 22:07:31.48 server  Recovery no active transactions before ckpt.
    00:1998/09/08 22:07:31.67 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:31.67 server  Database 'model' is now online.
    00:1998/09/08 22:07:31.67 server  Clearing temp db
    00:1998/09/08 22:07:32.22 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:32.27 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:32.27 server  Database 'tempdb' is now online.
    00:1998/09/08 22:07:32.41 server  Recovering database 'sybsystemprocs'.
    00:1998/09/08 22:07:32.42 server  Recovery dbid 4 ckpt (6981,13)
    00:1998/09/08 22:07:32.42 server  Recovery no active transactions before ckpt.
    00:1998/09/08 22:07:33.26 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:33.27 server  Database 'sybsystemprocs' is now online.
    00:1998/09/08 22:07:33.28 server  Recovering database 'pubs2'.
    00:1998/09/08 22:07:33.29 server  Recovery dbid 5 ckpt (797,15)
    00:1998/09/08 22:07:33.29 server  Recovery no active transactions before ckpt.
    00:1998/09/08 22:07:33.33 server  The transaction log in the database 'pubs2' will use I/O size of 2 Kb.
    00:1998/09/08 22:07:33.33 server  Database 'pubs2' is now online.
    00:1998/09/08 22:07:33.34 server  Recovery complete.
    00:1998/09/08 22:07:33.34 server  SQL Server's default sort order is:
    00:1998/09/08 22:07:33.34 server  	'bin_iso_1' (ID = 50)
    00:1998/09/08 22:07:33.34 server  on top of default character set:
    00:1998/09/08 22:07:33.34 server  	'iso_1' (ID = 1).
    
    [sybase@snippy install]$ ipcs
    
    ------ Shared Memory Segments --------
    key        shmid     owner     perms     bytes     nattch    status
    0xf501803e 1537      sybase    600       11886592  1
    
    ------ Semaphore Arrays --------
    key       semid     owner     perms     nsems     status
    
    ------ Message Queues --------
    key       msqid     owner     perms     used-bytes  messages
    
    [sybase@snippy install]$ isql -Usa -P
    1> sp_configure
    2> go
    
    Group: Configuration Options
    
    
    Group: Backup/Recovery
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     allow remote access                      1           0           1            1
     print recovery information               0           0           0            0
     recovery interval in minutes             5           0           5            5
     tape retention in days                   0           0           0            0
    
    Group: Cache Manager
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     memory alignment boundary             2048           0        2048         2048
     number of index trips                    0           0           0            0
     number of oam trips                      0           0           0            0
     procedure cache percent                 20         980          20           20
     total data cache size                    0        3776           0         3776
     total memory                          7500       15000        7500         7500
    
    Group: Disk I/O
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     allow sql server async i/o               1           0           1            1
     disk i/o structures                    256          17         256          256
     number of devices                       10          #4          10           10
     page utilization percent                95           0          95           95
    
    Group: General Information
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     configuration file                       0           0           0  /opt/sybase
    
    Group: Languages
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     default character set id                 1           0           1            1
     default language id                      0           0           0            0
     default sortorder id                    50           0          50           50
     disable character set conversi           0           0           0            0
     number of languages in cache             3           4           3            3
    
    Group: Lock Manager
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     address lock spinlock ratio            100           0         100          100
     deadlock checking period               500           0         500          500
     freelock transfer block size            30           0          30           30
     max engine freelocks                    10           0          10           10
     number of locks                       5000         469        5000         5000
     page lock spinlock ratio               100           0         100          100
     table lock spinlock ratio               20           0          20           20
    
    Group: Memory Use
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     additional network memory                0           0           0            0
     audit queue size                       100          42         100          100
     default network packet size            512        #135         512          512
     disk i/o structures                    256          17         256          256
     event buffers per engine               100         #10         100          100
     executable codesize + overhead           0        4645           0         4645
     max number network listeners            15        1223          15           15
     max online engines                       1          53           1            1
     number of alarms                        40           1          40           40
     number of devices                       10          #4          10           10
     number of extent i/o buffers             0           0           0            0
     number of languages in cache             3           4           3            3
     number of large i/o buffers              6          97           6            6
     number of locks                       5000         469        5000         5000
     number of mailboxes                     30           1          30           30
     number of messages                      64           1          64           64
     number of open databases                12         395          12           12
     number of open objects                 500         489         500          500
     number of remote connections            20          33          20           20
     number of remote logins                 20          22          20           20
     number of remote sites                  10         815          10           10
     number of user connections              25        2031          25           25
     partition groups                      1024          21        1024         1024
     permission cache entries                15         #28          15           15
     procedure cache percent                 20         980          20           20
     remote server pre-read packets           3         #32           3            3
     stack guard size                      4096        #240        4096         4096
     stack size                           34816       #2041       34816        34816
     total data cache size                    0        3776           0         3776
     total memory                          7500       15000        7500         7500
    
    Group: Network Communication
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     additional network memory                0           0           0            0
     allow remote access                      1           0           1            1
     allow sendmsg                            0           0           0            0
     default network packet size            512        #135         512          512
     max network packet size                512           0         512          512
     max number network listeners            15        1223          15           15
     number of remote connections            20          33          20           20
     number of remote logins                 20          22          20           20
     number of remote sites                  10         815          10           10
     remote server pre-read packets           3         #32           3            3
     syb_sendmsg port number                  0           0           0            0
     tcp no delay                             0           0           0            0
    
    Group: O/S Resources
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     max async i/os per engine       2147483647           0  2147483647   2147483647
     max async i/os per server       2147483647           0  2147483647   2147483647
     o/s asynch i/o enabled                   0           0           0            0
     o/s file descriptors                     0           0           0          256
     tcp no delay                             0           0           0            0
    
    Group: Physical Resources
    
    
    Group: Physical Memory
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     additional network memory                0           0           0            0
     lock shared memory                       0           0           0            0
     shared memory starting address           0           0           0            0
     total memory                          7500       15000        7500         7500
    
    Group: Processors
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     max online engines                       1          53           1            1
     min online engines                       1           0           1            1
    
    Group: SQL Server Administration
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     allow nested triggers                    1           0           1            1
     allow updates to system tables           0           0           0            0
     audit queue size                       100          42         100          100
     cpu accounting flush interval          200           0         200          200
     cpu grace time                         500           0         500          500
     deadlock retries                         5           0           5            5
     default database size                    2           0           2            2
     default fill factor percent              0           0           0            0
     dump on conditions                       0           0           0            0
     event buffers per engine               100         #10         100          100
     housekeeper free write percent           1           0           1            1
     i/o accounting flush interval         1000           0        1000         1000
     i/o polling process count               10           0          10           10
     identity burning set factor           5000           0        5000         5000
     identity grab size                       1           0           1            1
     lock promotion HWM                     200           0         200          200
     lock promotion LWM                     200           0         200          200
     lock promotion PCT                     100           0         100          100
     maximum dump conditions                 10           0          10           10
     number of alarms                        40           1          40           40
     number of extent i/o buffers             0           0           0            0
     number of large i/o buffers              6          97           6            6
     number of mailboxes                     30           1          30           30
     number of messages                      64           1          64           64
     number of open databases                12         395          12           12
     number of open objects                 500         489         500          500
     number of pre-allocated extent           2           0           2            2
     number of sort buffers                   0           0           0            0
     partition groups                      1024          21        1024         1024
     partition spinlock ratio                10           0          10           10
     print deadlock information               0           0           0            0
     runnable process search count         2000           0        2000         2000
     size of auto identity column            10           0          10           10
     sort page count                          0           0           0            0
     sql server clock tick length        100000           0      100000       100000
     time slice                             100           0         100          100
     upgrade version                       1100           0        1103         1103
    
    Group: User Environment
    
    
     Parameter Name                 Default     Memory Used Config Value Run Value
     ------------------------------ ----------- ----------- ------------ -----------
     default network packet size            512        #135         512          512
     number of pre-allocated extent           2           0           2            2
     number of user connections              25        2031          25           25
     permission cache entries                15         #28          15           15
     stack guard size                      4096        #240        4096         4096
     stack size                           34816       #2041       34816        34816
     systemwide password expiration           0           0           0            0
     user log cache size                   2048           0        2048         2048
     user log cache spinlock ratio           20           0          20           20
    
    (return status = 0)
    
    1> shutdown
    2> go
    Server SHUTDOWN by request.
    The SQL Server is terminating this process.
    00:1998/09/08 22:07:58.33 server  SQL Server shutdown by request.
    00:1998/09/08 22:07:58.33 kernel  ueshutdown: exiting
    DB-LIBRARY error:
    	Unexpected EOF from SQL Server.
    
    [sybase@snippy install]$ logout
    

Some helpfull resources you may like to consult:


Sybase Main Page


Sybase Adaptive Server
The Sybase Adaptive Server Linux resource
Online Technical Library
Sybperl - OpenClient extensions to Perl !!!
Ed Barlow's Sybase Stuff