記錄 Sybase ASE 12.5 在 Linux (RedHat 5) 上的安裝、環境變量、Server/Backup Server 建立、資料庫創建、參數調優、分段管理等完整步驟。
sybase 用戶與目錄。su - sybase 必須在 sybase 用戶下安裝。./setup -console。YES。/sybase/sybase。Full。~/.bash_profile). ${HOME}/SYBASE.sh
export LD_POINTER_GUARD=0 # RHEL5 必須,否則報 Segmentation Fault
/etc/hosts 添加:127.0.0.1 dacsdb/etc/sysconfig/network 修改 HOSTNAME=dacsdbsrvbuild.LCDACS_SERVER.rs(關鍵參數:master device 1024M、page size 16k、port 7100、TCP 協議)。ASE-12_5/bin/srvbuildres -r dacs/srvbuild.LCDACS_SERVER.rssrvbuild.DACS_BACK.rs(port 7200、關聯 LCDACS_SERVER)。ASE-12_5/bin/srvbuildres -r dacs/srvbuild.DACS_BACK.rs-- 裝置與資料庫
disk init name="lcdacs", physname="/data/sysdata/lcdacs.dat", size="2g", dsync=true
disk init name="lcdacs_log", physname="/data/sysdata/lcdacs_log.dat", size="2g", dsync=true
create database LCDACS on lcdacs="30G" log on lcdacs_log="2G"
sp_addlogin dacs, dacs123, "LCDACS"
use LCDACS; sp_changedbowner dacs
-- tempdb 分離裝置
disk init name='tempdbdev01', physname='/data/sysdata/tempdbdev01.dat', size='1G', dsync='false'
disk init name='tempdbdev01_log', physname='/data/sysdata/tempdbdev01_log.dat', size='1G', dsync='false'
alter database tempdb on tempdbdev01='1G' log on tempdbdev01_log='1G'
use tempdb
exec sp_dropsegment 'logsegment', 'tempdb', 'master'
exec sp_dropsegment 'system', 'tempdb', 'master'
exec sp_dropsegment 'default', 'tempdb', 'master'
-- 核心調優參數 (需重啟生效)
sp_configure "max memory", 0, "1G"
sp_configure "allocate max shared mem", 1
sp_cacheconfig "default data cache", "1G"
sp_cacheconfig "default data cache", "cache_partition=2"
sp_poolconfig "default data cache", "768M", "32k"
sp_configure "procedure cache size", 1024000
sp_cacheconfig "tempdb_cache", "1G", "mixed"
sp_bindcache "tempdb_cache", tempdb
sp_cacheconfig "dacs_cache", "1G", "mixed"
sp_bindcache "dacs_cache", LCDACS
sp_configure "max online engines", 15
sp_configure "number of engines at startup", 15
sp_configure "number of worker processes", 16
sp_configure "max parallel degree", 1
sp_configure "number of user connections", 600
sp_configure "number of locks", 10000
sp_configure "number of open indexes", 500
sp_configure "number of open objects", 500
sp_configure "number of devices", 100
sp_configure "lock scheme", 1, datarows
sp_dboption "LCDACS", "trunc log on chkpt", true
disk init name="dacs_data01", physname="/data/sysdata/dacs_data01", size="1G"
disk init name="dacs_index01", physname="/data/sysdata/dacs_index01", size="1G"
alter database LCDACS on dacs_data01="1G"
alter database LCDACS on dacs_index01="1G"
use LCDACS
sp_addsegment dacs_data, LCDACS, lcdacs
sp_addsegment dacs_index, LCDACS, lcdacs
sp_extendsegment dacs_data, LCDACS, dacs_data01
sp_extendsegment dacs_index, LCDACS, dacs_index01
isql -Usa -P -SLCDACS_SERVER -w300