來源:Sybase資料庫初始化設定
由於sybase在台灣的設定資料還真的蠻難找的,底下的設定是預設的初始設定,有些是必須要視情況修訂的,可別照抄咧。
sp_configure "max memory",870400
sp_cacheconfig "default data cache","1024M"
sp_configure "number of open objects",5000
sp_configure "number of open indexes",15000
sp_configure "max online engines",1
sp_configure "number of engines at startup", 1
sp_configure "number of locks",65535
sp_addserver "SYB_BACKUP",null,"JACK_BS"
sp_configure "procedure cache size", 51200
sp_configure 'max network packet size',4096
sp_configure 'number of user connections',100
sp_cacheconfig "default data cache","1024M"
sp_configure "number of open objects",5000
sp_configure "number of open indexes",15000
sp_configure "max online engines",1
sp_configure "number of engines at startup", 1
sp_configure "number of locks",65535
sp_addserver "SYB_BACKUP",null,"JACK_BS"
sp_configure "procedure cache size", 51200
sp_configure 'max network packet size',4096
sp_configure 'number of user connections',100
另外若要改資料庫為big語系步驟為
1. cd\sybase\charsets\big5
2. charset -Usa -P1234 -Sjack binary.srt big5
3. 接著用 SQL Advantage
sp_configure "default character set id",161
go
go
4. 用文書編輯器修改 C:\sybase\locales\locales.dat
引用
[NT]
locale = enu, us_english, iso_1
locale = fra, french, iso_1
locale = deu, german, iso_1
locale = rus, russian, cp1251
locale = hun, us_english, cp1250
locale = ell, us_english, cp1253
locale = heb, us_english, cp1255
locale = ara, us_english, cp1256
locale = trk, us_english, cp1254
locale = esp, spanish, iso_1
locale = jpn, japanese, sjis
locale = japanese, japanese, sjis
locale = chs, chinese, eucgb
locale = cht, tchinese, big5
locale = kor, korean, cp949
locale = us_english.utf8, us_english, utf8
;locale = default, us_english, iso_1
locale = default,us_english, big5
locale = enu, us_english, iso_1
locale = fra, french, iso_1
locale = deu, german, iso_1
locale = rus, russian, cp1251
locale = hun, us_english, cp1250
locale = ell, us_english, cp1253
locale = heb, us_english, cp1255
locale = ara, us_english, cp1256
locale = trk, us_english, cp1254
locale = esp, spanish, iso_1
locale = jpn, japanese, sjis
locale = japanese, japanese, sjis
locale = chs, chinese, eucgb
locale = cht, tchinese, big5
locale = kor, korean, cp949
locale = us_english.utf8, us_english, utf8
;locale = default, us_english, iso_1
locale = default,us_english, big5
這樣才完成
沒有留言:
發佈留言