Sybase資料庫初始化設定

 2,140 total views,  2 views today

由於sybase在台灣的設定資料還真的蠻難找的,底下的設定是預設的初始設定,有些是必須要視情況修訂的,可別照抄咧。

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

另外若要改資料庫為big語系步驟為
1. cdsybasecharsetsbig5

2. charset -Usa -P1234 -Sjack binary.srt big5

3. 接著用 SQL Advantage

[sql]sp_configure “default character set id”,161
go[/sql]

4. 用文書編輯器修改 C:sybaselocaleslocales.dat

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

 

這樣才完成

發表迴響

%d 位部落客按了讚: