Sybase Adaptive Server Enterprise 11.0.3.3 under Linux ġϱ
ڸ , 1998 10 16
 
 1. Ұ
 2. ġϱ

 
 
 2.1 α׷ 
 2.2. ý / ũ 뷮 Ȯϱ

 2.3. rpm  ȭ Ǯ
 2.4.  
 
 3. ASE ȯ ϱ

 3.1 Configure a Server product : SQL Server 
 3.2. Edit / View
Interfaces File
 3.3. Configure a Server product : Backup Server 

 3.4. CONFIGURE CONNECTIVITY PRODUCTS
 
 4. ͺ̽ ϱ
 
 
--------------------------------------------------------------------------------

 1. Ұ
 
   Sybase Adaptive Server Enterprise 11.0.3.3 under
Linux ġϱ  HOWTO ̸ ڰ ̹ Red Hat Linux/Unix
⺻ ɰ  ˰ ִٴ Ͽ Ͽϴ. Red Hat 5.1
 ϸ Red Hat Linux 5.1 Ǵ Unix ⺻    ٸ
ù  ϱ ٶϴ.
 Ʒ ɿ # root ,
$ sybase  ϴ  ǹմϴ. 
 
 
 2. ġϱ
 
 2.1
α׷ 
  Sybase Adaptive Server Enterprise 11.0.3.3 
 ̺̽ Ȩ, Redhat, Caldera Systems, S.u.S.E,Inc.  
ֽϴ.
  Ȩ ̵ϸ ϴ ȭ  ⿡ 
ϸ α׷ ٿ   ֽϴ.
 ٿ  丮 ̵Ͽ
 ȭ Ȯմϴ. 
 
 
 # cd YOUR-RPMS-i386-archive-directory
 #
ls -l
 sybase-ase-11.0.3.3-1.i386.rpm
 sybase-doc-11.0.3.3-1.i386.rpm

 ⺻ Ű "sybase-ase-11.0.3.3-1.i386.rpm" full localization
 character sets   Adaptive ServerEnterprise 11.0.3.3
run-time and development area ϰ ֽϴ. ASE 10.0.4 Open
Client/Open Server run-time ̺ ESQL/C ӵ Բ Sybase
SQL Server, Backup Server, Sybinit, Sybmon մϴ.  Ű
"sybase-doc-11.0.3.3-1.i386.rpm" Ʈ ũƮ  Ϻ
ǰ  ֽϴ. 
 
 2.2 ý / ũ 뷮 Ȯ
 Sybase ASE
server  ÷ ּ 64MBytes ޸𸮿 fast physical disk
I/O  ÷  ġϴ  մϴ.
 ġϱ  Ʈ
ũƮ   ü ν翡 200Mbyte ʿϸ, Ʈ
ũƮ  Sybase Adaptive Server Enterprise ġϸ ּ
120Mbyte ʿմ . Ű ġ   run-time ȯ游 ʿϸ
development Open Client and Open Server Libraries ν 
پϴ.
 
 2.3 rpm  ȭ Ǯ
 sybase-ase-11.0.3.3-1.i386.rpm
 Ǳϴ.
 
 
 
 # rpm -i sybase-ase-11.0.3.3-1.i386.rpm
 
 DO YOU
AGREE WITH THE LISTED LICENSE CONDITIONS? [Yes/No/List] : 
 
 
 LICENSE
ϴ   Y Ĩϴ. 
 2.4  
 LICENSE Ͽ
/opt/sybase/install/sybinstall.sh ũƮ ڵ Ͽ  ̽
  , ۹̼ մϴ.
  NIS  ũƮ
ڵ  մϴ. NIS ȯ̶ ġ ϱ  NIS  
   ʿմϴ.  'root'μ ũƮ ٽ  
ֽϴ.
 ׷  sybase ⺻  Ǿ  
ũƮ ڵ  ϴ. ׷  ϸ Sybase Adaptive Server
Enterprise Ű νմϴ.
 Sybase Adaptive Server Enterprise
/opt/sybase ν˴ϴ. ν  'sybase' αϰ
/opt/sybase/install/sybinit Ͽ ȯ  ؾ մϴ. ó
'sybase' αϸ ڵ    ˴ϴ. ȯ漳 ٽ
Ϸ 'sybase' ν   .readme  .sysinit  ϸ
˴ϴ. 
 
 
 3. ASE ȯ ϱ
 
 
 ν  'sybase' α
ϸ(su - sybase) ó α   ASE ȯ 漳 ϴ ޴
 sysinit  ڵ մϴ.
 ASE ϱ   ý
ڿ ؼ ϰ ˰ ־ մϴ.    Ʈ port
ҴϿ ϰ, ȯ漳 ϱ ؼ master sybsystemprocs 
̽ ̽ ʱȭϱ ؼ ּ 37Mbytes ʿմϴ.
  
   𸣴 쿡  ⺻  ϸ ˴ϴ. 
  ȯ漳 Ͽ Ctrl-a     ׳
 Ctrl-x  ˴ϴ.  ȭ 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.1. Main MENU : Configure a Server product
 SQL  ȯ մϴ.

 
 3 Configure a Server product
 -> 1. SQL server 
 -> NEW OR EXITING
SQL SERVER 
 1. Confiruge a new SQL Server
 -> ADD NEW SQL SERVER
 1. SQL
Server name : SYBASE
 ( SQL Server ϴµ  ̸ Ǿ
Ѵ.  SQL  ϱ   ̸  ٸ Ŭ̾Ʈ
   ִ. ⺻ SYBASE̸ ڰ ٲܼ ִ.) 
 
3.1.2. SQL SERVER CONFIGURATION
 sysinit  ϰǾ  Ʒ 9ܰ
޴ ó ȯ  SQL Server   ִ.
 
 
 
    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
 
 => SERVER INTERFACES
FILE ENTRY SCREEN
 3. Add a new listener service
 -> EDIT TCP SERVICE
1. Hostname/Address : snippy.sybase.com
 2. PORT : 7100
 -> ȯ 
 Ȯ, ϰ SQL SERVER CONFIGURATION  .
 
 (
 SQL  ̸ 'SYBASE'   snippy ȣƮ
  ִ 7100 Ʈ ΰ ִٴ  ش. Ʈ տ
Ѵ  ϰ    Ʈ ؾ ϰ hostname 
ȯ濡 °  ϸ ȴ. ) 
 2. MASTER DEVICE CONFIGURATION
 (ó
ȯ  ϴ ̸ ⺻  Ѵ. mster device size ּ
21MBytes  ϴ-⺻ Ǿ )
 
 3. SYBSYSTEMPROCS DATABASE
CONFIGURATION
 (Sybsystemprocs database  ν Sybase ý
ϴµ . ⺻  Sybase ASE ȯ ͺ̽ ڸ
ϰ ϱ   ν    ִ.  ̽ 
ּ 16Mbytes Ѵ. ⺻ Ǿ ִ.)
 
 4. SET ERRORLOG
LOCATION
 (Sybase SQL Server SQL Server Ŀ ޽ α׸
  ʿϴ.  ϴ  õѴ)
 
 5. CONFIGURE
DEFAULT BACKUP SERVER
 (ð    ʿ. Backup
Server ־ Ѵ.   SYB_BACKUP  ϴ
 ϰڴ)
 
 6. CONFIGURE LANGUAGES
 (⺻ us_english locale
setup Ǿ ִ.)
 
 7. CONFIGURE CHARACTER SETS
 8. CONFIGURE SORT
ORDER
 (ϴ character Ʈ sort order .)
 
 9. ACTIVATE
AUDITING
 (⺻ enabled̴.)
 
  Ͽ 9 ޴
 complete Ȱ Ȯմϴ.  ɼ  sybinit
ȯ  ̽ ͺ̽  ó SQL Server 
Դϴ. "Execute the SQL Server Configuration now?"  ⼭
Y ġ ˴ϴ. ͺ̽ ̽     ð
ɸϴ. ÷ ɿ    30 ɸ⵵ մϴ.  ۾
 Configuration completed successfully   ƹ Ű ġ
sysinit ȯ  ȭ ưϴ.  Sybase SQL Server ȯ漳
 ˴ϴ.('ps' 'netstat' Ȯ  ֽϴ)
 
 SYBINIT MAIN
MENU ưϴµ        
  ޴ 2 'interfaces' editor ϰ  ؾմϴ.
 
 
 
 
SYBINIT 1. Release directory: /opt/sybase 2. Edit / View Interfaces File
3. Configure a Server product 4. Configure an Open Client/Server product 

 3.2 MAIN MENU : 2. Edit / View Interfaces File
 Sybinit 'interfaces'
 ϴµ   ֽϴ. interfaces file Ʈ Բ 
Ʈ ip 巹 Ҵǰ ̸ ־ Sybase 񽺸 ϰ ִ
ƽŰ ؽƮ   ȭԴϴ.
 
 
 2. Edit / View Interfaces File

 -> Interfaces File : 
 1. Add a new entry
 -> CREATE NEW INTERFACES
FILE ENTRY
 1. Server name :
 -> ߰  ̸ ԷѴ. ⺻
''̴. SYB_BACKUP ԷѴ.
 -> Է Server name ȭ鿡 
3. Add a new listener service Ѵ.
 -> EDIT TCP SERVICE
 2. Port:

 -> port  ʴ Ʈ ԷѴ. ( 7110) 
 -> ϰ 
MAIN MENU . 
 3.3 MAIN MENU : 3. Configure a Server product
 Backup
Server մϴ.
 
 
 3. Configure a Server product
 -> 2. Backup Server

 -> NEW OR EXISTING BACKUP SERVER
 1. Configure a new Backup Server
 ->
ADD NEW BACKUP SERVER
 1. Backup Server name :
 (Backup Server ̸
ԷѴ. SYB_BACKUP)
 Ʒ ⺻  Backup Server  
ûѴ. SQL Server  Backup Server ɼ locale character
 ȯ   ִ. SQL Server   .  ϰ
ϸ "Execute the Backup Server configuration now?"  . ⼭
Y ġ Backup Server Ѵ. -> ϰ MAIN MENU ´. 
3.4 MAIN MENU : 4. CONFIGURE CONNECTIVITY PRODUCTS
 Ʒ ܰ迡 Open
Client  Open Server Sybase ASE ȯ մϴ.  ǰ  
 rpm Ű Ǿ  ̰  ν翡 ݵ
ʿ   մϴ.  ܰ踦 ϴ°  ýۿ Ȯ
̺귯   νϴ   Դϴ. 1, 2, 3 
ʴ ϸ ڵ  ˴ϴ.
 
 
 
 
    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
 
 ó ȯ  SQL Server  غ Ǿϴ. 
 Ǿ 'sybase' α ϸ罩 Ʈ ٸ  ߰
Դϴ.
 
 
    Exiting.
 The log file for this session is 
          '/opt/sybase/init/logs/log0908.001'.
    

 
 4. ͺ̽ ϱ 
 
 SQL Server αϰ ͺ̽
ҷ,    ۾ ۾    ȯ  ɼ
ȮϽʽÿ. Sybase Adaptive Enterprise setup ϰ   
׷쿡 Ǹ Ͻʽÿ.
 sybase ͺ̽ ϱ ؼ "isql"
α׷ մϴ.
 
 α׷ ġ ȯ漳  "isql -Usa
-P"  ̿Ͽ ͺ̽   ֽϴ. 
 ͺ̽
 Ͽ isql  Ǹ   ؼ go մϴ. 
 ۿ ִ   reset  ˴ϴ.
  ȯ 
ȮϷ sp_configure մϴ.
 Ǹ ģ  isql 
ؼ quit  exit Ͽ     Ű
shutdown ϰ  ˴ϴ.
 
 
 
 $ isql -Usa -P
 
 1> sp_who
 2> go

 1> quit
 
 scripts丮 installpubs2 ̿Ͽ pubs2 ͺ̽
ϴ. ͺ̽ Ͽ pubs2 ͺ̽  select 
մϴ. use ٸ ͺ̽ Ҷ ϴ. 
 
 $ isql -Usa -P -i
${SYBASE}/scripts/installpubs2
 
 $ isql -Usa -P
 1> use pubs2   
 2> go
1> select * from titles
 2> order by price
 3> go
 
  shutdown Ͽ
SQL Server Ű  ٽ SQL Server ϱ ؼ
dataserver startserver մϴ. 
 startserver -f runserverfile 
· runserver file  Ͽ  մϴ. 
 showserver
α׷ ̿ϸ   ǻͿ ǰ ִ SQL Server Backup
Server ݴϴ. 
 
 
 
 $ cd install/
 $ ./startserver -f ./RUN_SYBASE

 
 ڼ  doc 丮 Ʈ ũƮ Ŵ Ͻʽÿ. 

 
 
 [ ]
 
 
    [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
 

