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.
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.
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.
You 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:
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 documentation and a Quickstart HOWTO to configure this Sybase
ASE release can be found in the $SYBASE/doc directory.
Documentation towards any Sybase product can be found on our Dynaweb
pages accessible from our World Wide Web site:
We would like you to register your installation and find more
information about this Sybase Adaptive Server Enterprise release
for Linux available from:
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
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.
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.
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 built 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 minimum 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
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
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.
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
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
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
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
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
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
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
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.
Your Sybase SQL Server is configured and running. You may check from another 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 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
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'.
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: