HOWTO install Sybase Adaptive Server Enterprise 11.0.3.3 under Linux
Support
[ 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.
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.
Start configuring ASE
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:
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.
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'
3 => Configure a Server product.
Instruct 'sybinit' to configure the ASE environment for a SQL Server or
Backup Server.
CONFIGURE SERVER PRODUCTS
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
Ctrl-a => Accept and Continue
SET ERRORLOG LOCATION
SQL SERVER CONFIGURATION "SET ERRORLOG LOCATION"
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.
Ctrl-a => Accept and Continue
CONFIGURE DEFAULT BACKUP SERVER
SQL SERVER CONFIGURATION "CONFIGURE DEFAULT BACKUP SERVER"
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.
Ctrl-a => Accept and Continue.
CONFIGURE LANGUAGES
SQL SERVER CONFIGURATION "CONFIGURE LANGUAGES"
6 => CONFIGURE LANGUAGES
CONFIGURE LANGUAGES
Feel free to install any of the possible selections listed. By default 'sybinit'
selects the us_english locale setup.
Ctrl-a => Accept and Continue
CONFIGURE CHARACTER SETS
SQL SERVER CONFIGURATION "CONFIGURE CHARACTER SETS"
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.
Ctrl-a => Accept and Continue
CONFIGURE SORT ORDER
SQL SERVER CONFIGURATION "CONFIGURE SORT ORDER"
8 => CONFIGURE SORT ORDER
CONFIGURE SORT ORDER
Default sort order can be configured here.
Ctrl-a => Accept and Continue
ACTIVATE AUDITING
SQL SERVER CONFIGURATION "ACTIVATE AUDITING"
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.
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.
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 another
terminal using 'ps' and 'netstat'.
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.
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.
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.
1 => Add a new entry
NEXT
CREATE NEW INTERFACES FILE
1 => Server name
NEXT
For the Backup Server server we registered the default name 'SYB_BACKUP'.
Ctrl-a => Accept and Continue
NEXT
SERVER INTERFACES FILE ENTRY SCREEN
3 => Add a new listener service
NEXT
EDIT TCP SERVICE
2 => Port
NEXT
The SYB_BACKUP is configured for Hostname 'snippy' and Port '7110'
Ctrl-a => Accept and Continue
NEXT
Acknowledge the configuration to 'sybinit'
Ctrl-a => Accept and Continue
Force 'sybinit' to update the 'interfaces' file.
NEXT
INTERFACES FILE TOP SCREEN
Ctrl-a => Accept and Continue
NEXT
SYBINIT
3 => Configure a Server product
NEXT
CONFIGURE SERVER PRODUCTS "Backup Server"
2 => Backup Server
NEXT
NEW OR EXISTING BACKUP SERVER
1 => Configure a new Backup Server
ADD NEW BACKUP SERVER
ADD NEW BACKUP SERVER
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.
return
NEXT
Go all the way back to the main SYBINIT screen.
Ctrl-a => Accept and Continue
NEXT
CONFIGURE SERVER PRODUCTS
Ctrl-a => Accept and Continue
NEXT
SYBINIT
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.
Ctrl-a => Accept and Continue
LEAVING SYBINIT
SYBINIT
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.
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
Back
Copyright © [- SroNey / JohN
-]. All rights reserved