From owner-freebsd-questions Sun Jul 16 22:39:40 2000 Delivered-To: freebsd-questions@freebsd.org Received: from maynard.mail.mindspring.net (maynard.mail.mindspring.net [207.69.200.243]) by hub.freebsd.org (Postfix) with ESMTP id E4E9337B78C for ; Sun, 16 Jul 2000 22:39:36 -0700 (PDT) (envelope-from scrantr@ix.netcom.com) Received: from ix.netcom.com (col-oh31-38.ix.netcom.com [207.220.176.166]) by maynard.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id BAA27534 for ; Mon, 17 Jul 2000 01:39:34 -0400 (EDT) Message-ID: <39729C50.CDB98BB4@ix.netcom.com> Date: Mon, 17 Jul 2000 01:40:32 -0400 From: Richard Scranton Organization: Online Computer Library Center, Inc. X-Mailer: Mozilla 4.73 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en-US, en MIME-Version: 1.0 To: questions@freebsd.org Subject: Sybase on FreeBSD, finally! Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Sybase has released a tweaked version of their ASE 11.0.3.3 package that works on FreeBSD 3.4-RELEASE. In order to get it going, you need to do a few things up front, but it installs pretty cleanly after that. 1) Make sure you have the SystemV IPC defines in your kernel config You will need to configure for a considerable amount of shared memory, as Sybase uses it for communication and buffer cache. As installed, it will need at least 15 megs of shared memory. I have configured it as: options SYSVSHM options SYSVMSG options SYSVSEM options "SHMMAX=33554432" options "SHMALL=16384" This allows 64 megs total shared memory, and a max of 32 megs for a single region. That will allow the allocation of 30 megs to Sybase, for a little better performance. think [/usr/src/sys/i386/conf]: isql -Usa Password: 1> sp_configure memory 2> go Configuration option is not unique. Parameter Name Default Memory Used Config Value Run Value ------------------------------ ----------- ------ additional network memory 0 0 0 0 lock shared memory 0 0 0 0 memory alignment boundary 2048 0 2048 2048 shared memory starting address 0 0 0 0 total memory 7500 30000 15000 15000 2) Install the linuxbase-6.1 package. Sybase requires it, and will just coredump when trying to run with the linuxbase-5.2 that is part of 3.4-RELEASE. It appears to be able to coexist with 5.2 without ill effect. I got it from the 3.4-STABLE tree. The proof is in the results. Here is a "top" snapshot of it running on a ThinkPad 600E. The particulars are: 400Mhz Pentium II, 128 megs memory, 10 gig drive FreeBSD 3.4-RELEASE, linuxbase-6.1 installed. last pid: 705; load averages: 0.19, 0.42, 0.46 up 0+01:19:29 01:20:21 65 processes: 3 running, 62 sleeping CPU states: 1.6% user, 0.0% nice, 0.3% system, 0.1% interrupt, 98.0% idle Mem: 55M Active, 42M Inact, 13M Wired, 5040K Cache, 6337K Buf, 8596K Free Swap: 256M Total, 256M Free PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 598 richard 2 0 21748K 17448K select 0:29 0.00% 0.00% netscape.bin 340 root 2 0 16880K 11872K select 0:28 0.00% 0.00% XF86_SVGA 315 httpd 18 0 20980K 3452K pause 0:24 0.00% 0.00% java 552 richard 2 0 1388K 1040K RUN 0:11 0.00% 0.00% ppp 318 httpd 2 0 3892K 2512K select 0:03 0.00% 0.00% cached 668 sybase 10 0 31584K 11040K RUN 0:01 0.00% 0.00% dataserver 452 richard 2 0 2116K 1456K select 0:01 0.00% 0.00% xclock 454 richard 2 0 2172K 1504K select 0:00 0.00% 0.00% xbatt 455 richard 2 0 2460K 1828K select 0:00 0.00% 0.00% xterm 314 httpd 10 0 1580K 1160K nanslp 0:00 0.00% 0.00% httpd 312 root 2 0 1628K 1236K select 0:00 0.00% 0.00% httpd 457 richard 2 0 2296K 1672K select 0:00 0.00% 0.00% twm 453 richard 2 0 2212K 1572K select 0:00 0.00% 0.00% xload 700 sybase 2 0 1592K 864K select 0:00 0.00% 0.00% top 307 root 2 0 1484K 1020K select 0:00 0.00% 0.00% nmbd 459 richard 18 0 516K 244K pause 0:00 0.00% 0.00% ksh 669 sybase 2 0 7828K 5380K select 0:00 0.00% 0.00% backupserver 551 richard 2 0 2408K 1772K select 0:00 0.00% 0.00% xterm 456 richard 2 0 2460K 1828K select 0:00 0.00% 0.00% xterm 156 root 2 0 824K 512K select 0:00 0.00% 0.00% syslogd 596 sybase 10 0 504K 284K wait 0:00 0.00% 0.00% sh 599 richard 2 0 16112K 5680K select 0:00 0.00% 0.00% netscape.bin 161 root 2 0 1968K 1420K select 0:00 0.00% 0.00% named 341 root 10 0 2108K 1420K wait 0:00 0.00% 0.00% xdm 701 richard 28 0 1596K 868K RUN 0:00 0.00% 0.00% top 224 root 2 0 912K 644K select 0:00 0.00% 0.00% inetd 227 root 10 0 988K 524K nanslp 0:00 0.00% 0.00% cron 234 root 2 0 1312K 788K select 0:00 0.00% 0.00% sendmail 336 root 2 0 2000K 1076K select 0:00 0.00% 0.00% xdm 202 daemon 2 0 792K 544K sbwait 0:00 0.00% 0.00% rwhod 440 richard 10 0 504K 208K wait 0:00 0.00% 0.00% sh -- _____________________________________________________ Computer Associates: Where old software goes to die. http://www.netcom.com/~scrantr/index.html To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message