sybase配置
u 配置SYBASE伺服器
1. 為SYBASE SERVER建立所需的裝置
建議将sybase server的資料庫裝置建立在裸裝置上，是以，在系統中建立以下邏輯卷：
lvname=master,size=100M
lvname=sybproc,size=100M
lvname=sybsystem,size=100M(*)
修改對應裝置檔案權限：
# chown sybase:sybase /dev/master /dev/rmaster
# chown sybase:sybase /dev/sybproc /dev/rsybproc
# chown sybase:sybase /dev/sybsystem /dev/rsybsystem(*)
# chmod 600 /dev/master /dev/rmaster /dev/sybproc /dev/rsybproc
# chmod 600 /dev/sybsystem /dev/rsybsystem(*)
2. 設定系統環境
共享記憶體要求
Platform Number of 2K Pages Amount of Memory
HP/UX 9,000 18 MB
IBM RS/6000 9,000 18 MB
修改系統共享記憶體。
異步I/O要求
n IBM AIX
激活異步I/O。
# smitty chgaio
如果系統同時有多于7個磁盤使用異步I/O，對于每個裝置将參數MAXIMUM加1。
SMIT Parameters Entry Boxes for AIX 4.1.2
MINIMUM number of servers 1
MAXIMUM number of servers 10
MAXIMUM number of REQUESTS I/O 4096
Server PRIORITY 39
ASYNC I/O STATE to be configured at system restart available
n HP
使用SAM。
# sam
->;Kernel Configuration menu
---->;Drivers
修改 Pending State for asyncdisk為 In.
---->;Actions menu -->; rebuild the kernel-->; reboot the system.
由于啟動Adaptive Server和 Backup Server的使用者sybase必須是 /dev/async的屬主，執行以下指令：
# /etc/mknod /dev/async c 101 4
# chmod 0660 /dev/async
# chown sybase /dev/async
修改系統參數(SCO OPEN SERVER only)
# vi /etc/conf/cf.d/stune
加入以下行：
SHMMAX XXXXXXXX (XXXXXXXX為最大共享記憶體，如64M為67108864)
NFILE 3000
NOFILES 1024
# vi /etc/conf/sdevice.d/aio
将”N”改為”Y”。
# vi /etc/conf/sdevice.d/suds
将”N”改為”Y”。
# /etc/conf/cf.d/link_unix
重鍊核心。
# vi /etc/rc2
加入行：
/etc/suds_ctrl -a sybase組id号
# shutdown -y -i0 -g0 重新開機
修改sybase使用者的.profile
編輯/sybase/.profile檔案，如下：
SYBASE=/sybase
DSQUERY=ABIS_SERV
PATH=$PATH:.:.$SYBASE/bin:$SYBASE/install
LIBPATH=$SYBASE/lib
export SYBASE DSQUERY PATH LIBPATH
也可以将這些環境變量的設定放在系統的環境設定檔案中（如AIX的/etc/environment）。
3. 建立SYBASE SERVER
對于SCO OPEN SERVER下的SQL Server的建立，參見附錄。
假設SERVER名為ABIS_SERV。
以sybase使用者登入，或
# su – sybase
$ cd init
$ cd sample_resource_files
$ cp srvbuild.adaptive_server.rs /sybase/ABIS_SERV.rs
$ cp srvbuild.backup_servers.rs /sybase/ABIS_SERV_backup.rs
$ cd
修改資源定義檔案
$ vi ABIS_SERV.rs
sybinit.release_directory: /sybase
sybinit.product: sqlsrv
sqlsrv.server_name: ABIS_SERV
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
sqlsrv.master_device_physical_name:/dev/rmaster
sqlsrv.master_device_size: 100
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /dev/rsybproc
sqlsrv.sybsystemprocs_device_size: 100
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: /dev/rsybsystem(*)
sqlsrv.sybsystemdb_device_size: 100(*)
sqlsrv.sybsystemdb_database_size: USE_DEFAULT(*)
sqlsrv.default_backup_server: ABIS_SERV_backup
~
~
如果不使用兩階段送出(2pc)，可以不建立名為sybsystem的邏輯卷，同時删除以上檔案中最後标有(*)的三行。
$ vi ABIS_SERV_backup.rs
sybinit.release_directory: /sybase
sybinit.product: bsrv
bsrv.server_name: ABIS_SERV_backup
bsrv.do_add_backup_server: yes
bsrv.network_protocol_list: tcp
bsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
bsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
bsrv.language: USE_DEFAULT
bsrv.character_set: USE_DEFAULT
bsrv.tape_config_file: USE_DEFAULT
bsrv.errorlog: USE_DEFAULT
~
~
~
$ srvbuildres –r ABIS_SERV.rs
$ srvbuildres –r ABIS_SERV_backup.rs
如果是在HP-UX上，預設的字元集roman8，通過以下方法改為iso_1。
$ cd /sybase
$ cp init/sample_resource_files/sqlloc.rs sqlloc.rs
$ vi sqlloc.rs
sybinit.release_directory: USE_DEFAULT
sqlsrv.server_name: ABIS_SERV
sqlsrv.sa_login: sa
sqlsrv.sa_password:
sqlsrv.default_language: us_english
sqlsrv.language_install_list: USE_DEFAULT
sqlsrv.language_remove_list: USE_DEFAULT
sqlsrv.default_characterset: iso_1
sqlsrv.characterset_install_list: USE_DEFAULT
sqlsrv.characterset_remove_list: USE_DEFAULT
sqlsrv.sort_order: binary
$ sqllocres –r sqlloc.rs
4. 配置SYBASE SERVER
$ isql -Usa
Password:
1>;select @@version
2>;go
1>;alter database master on master=25 擴大MASTER資料庫
2>;go
1>;sp_helpdb
檢視資料庫資訊
2>;go
1>;sp_addserver "SYB_BACKUP",null,"ABIS_SERV_backup"
建立BACKUPSERVER與DBSERVER的連接配接
2>;go
1>;sp_addserver “ABIS_SERV”,local
2>;go
命名本伺服器，需重新開機server
1>;sp_helpserver
2>;go
1>;sp_configure "total memory",358400
為SYBASE指定其使用的記憶體(700M)，需重新開機動server
2>;go
1>;sp_configure "user connections",100
SYBASE可使用的使用者連接配接
2>;go
1>;sp_password NULL,”new_sa_password” 修改sa密碼
2>;go
1>;sp_diskdefault master,defaultoff 修改master裝置的預設狀态
2>;go
1>;shutdown SYB_BACKUP
必須先shutdown BACKUP server
2>;go
1>;shutdown
然後shutdown DB server
2>;go
5. 啟動SYBASE SERVER
# su – sybase
$ cd install
$ startserver -f RUN_ABIS_SERV 啟動server
$ showserver 對應每個CPU有一個dataserver程序
$ startserver -f RUN_ABIS_SERV_backup 啟動backup-server
6. 作系統資料庫備份
isql -Usa
1>;dump database master to "/sybase/install/master.dump"
2>;go
1>;dump database sybsystemprocs to "/sybase/install/sybprocs.dump"
2>;go
1>;quit
7. 修改配置檔案(Server)
$ cd /sybase
$ vi ABIS_SERV.cfg 該檔案是該伺服器的所有配置資訊，可以直接修改此檔案。
修改配置檔案後，最好使用以下指令進行檢驗修改是否正确：
$ isql –Usa –SABIS_SERV –P
1>;sp_configure "configuration file", 0,verify,"/sybase/ABIS_SERV.cfg"
2>;go
(return status = 0)
1>;quit
8. 修改配置檔案(Client)
根據需要，可能需要修改Open Client的某些配置檔案，才能正常使用應用程式。
可能需要修改的有：
l $SYBASE/config/libtcl.cfg
注釋掉所有段如[drivers],[directory],[security]内的所有行。
l $SYBASE/config/ocs.cfg
添加對應的server需要的段。
l $SYBASE/locales/locales.dat
根據應用使用的LANG添加或修改對應該OS的段，對應該LANG的行的值。
u 附錄
1. 在DS(DATA-SERVER)上安裝的産品及順序
1. Adattive Server Enterprise 11.9.2
2. All Server product Patch
2. 在AS(APPLATION-SERVER)上安裝的産品及順序
1. ESQL/C
2. Open Client/Server C
3. XA Library for CICS
4. All Client products patchs
3. 在BS(DS+AS)上安裝的産品及順序
1. ESQL/C
2. Open Client/Server C
3. XA Library for CICS
4. All Client product patchs
5. Adative Server Enterprise 11.9.2
6. All Server product Patch
7. other patchs
4. 在SCO OPENSERVER上安裝的産品及順序
1. SQL Server 11.0.3
2. Open Client/Server C 10.0.4
3. ESQL/C 10.0.4
4. SQL Server patch and OCS patch
5. 在SCO OPENSERVER上建立SQL Server
l 以使用者sybase登入，運作$SYBASE/install/sybinit。
$ install/sybinit
The log file for this session is '/sybase/init/logs/log0510.001'.
SYBINIT
1. Release directory: /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: 2
l 确認Release directory是正确的。
l 先配置server需要的interfaces項。
INTERFACES FILE TOP SCREEN
Interfaces file:
1. Add a new entry
2. Modify an existing entry
3. View an existing entry
4. Delete an existing entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
CREATE NEW INTERFACES FILE ENTRY
1. Server name:
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
Enter the name of the server to add (default is '):MYSERV
CREATE NEW INTERFACES FILE ENTRY
1. Server name: MYSERV
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SERVER INTERFACES FILE ENTRY SCREEN
Server name: MYSERV
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 3
EDIT TCP SERVICE
1. Hostname/Address: caiabc.nabc.com
2. Port:
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
Enter the hostname or Internet address to use for this entry (default is 'caiabc
.nabc.com'):localhost
EDIT TCP SERVICE
1. Hostname/Address: localhost
2. Port:
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 2
Enter the port number to use for this entry (default is '):2888
EDIT TCP SERVICE
1. Hostname/Address: localhost
2. Port: 2888
3. Name Alias:
4. Delete this service from the interfaces entry
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Is this information correct? y
SERVER INTERFACES FILE ENTRY SCREEN
Server name: MYSERV
1. Retry Count: 0
2. Retry Delay: 0
3. Add a new listener service
Modify or delete a service
Listener services available:
Protocol Address Port Name Alias
4. tcp localhost 2888
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Write the changes to the interfaces file now? y
l 建立新的Server
SYBINIT
1. Release directory: /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
CONFIGURE SERVER PRODUCTS
Products:
Product Date Installed Date Configured
1. SQL Server Oct 18 1996 22:07
2. Backup Server Oct 18 1996 22:07
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
NEW OR EXISTING SQL SERVER
1. Configure a new SQL Server
2. Configure an existing SQL Server
3. Upgrade an existing SQL Server
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
ADD NEW SQL SERVER
1. SQL Server name: SYBASE
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
Enter the name of the new SQL Server (default is 'SYBASE'):MYSERV
ADD NEW SQL SERVER
1. SQL Server name: MYSERV
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
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: 2
MASTER DEVICE CONFIGURATION
1. Master Device: /sybase/master.dat
2. Size (Meg): 21
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 1
Enter the pathname of the SQL Server's master device (default is '/sybase/master.dat'):/sybase/install/master.dat
WARNING: '/sybase/install/master.dat' is a regular file which is not recommended for a Server device.
Press <return>; to continue.
MASTER DEVICE CONFIGURATION
1. Master Device: /sybase/install/master.dat
2. Size (Meg): 21
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 2
Enter the size of the SQL Server's master device in megabytes:
50
MASTER DEVICE CONFIGURATION
1. Master Device: /sybase/install/master.dat
2. Size (Meg): 50
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
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: 3
SYBSYSTEMPROCS DATABASE CONFIGURATION
1. sybsystemprocs database size (Meg): 16
2. sybsystemprocs logical device name: sysprocsdev
3. create new device for the sybsystemprocs database: yes
4. physical name of new device: /sybase/sybprocs.dat
5. size of the new device (Meg): 16
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 4
Enter the physical device name for the sybsystemprocs database :
/sybase/install/sybprocs.dat
SYBSYSTEMPROCS DATABASE CONFIGURATION
1. sybsystemprocs database size (Meg): 16
2. sybsystemprocs logical device name: sysprocsdev
3. create new device for the sybsystemprocs database: yes
4. physical name of new device: /sybase/install/sybprocs.dat
5. size of the new device (Meg): 16
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
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: 4
SET ERRORLOG LOCATION
1. SQL Server errorlog: /sybase/install/errorlog
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
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: 5
SET THE SQL SERVER'S BACKUP SERVER
1. SQL Server Backup Server name: SYB_BACKUP
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
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: 6
CONFIGURE LANGUAGES
Current default language: us_english
Current default character set: ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 character(iso_1).
Select the language you want to install, remove, or designate as the default language.
Language Installed? Remove Install Make default
1. us_english yes no no yes
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
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: 7
CONFIGURE CHARACTER SETS
Current default language: us_english
Current default character set: ISO 8859-1 (Latin-1) - Western European 8-b character set.
Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 charact(iso_1).
Select the character set you want to install, remove, or designate as the defaulset.aracter
Character set Installed? Remove Install Make default
1. ASCII, for use with unsp yes no no no
2. Code Page 437, (United S no no no no
3. Code Page 850 (Multiling no no no no
4. ISO 8859-1 (Latin-1) - W yes no no yes
5. Macintosh default charac no no no no
6. Hewlett-Packard propriet no no no no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
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: 8
CONFIGURE SORT ORDER
Current default language: us_english
Current default character set: ISO 8859-1 (Latin-1) - Western European 8-bcharacter set.
Current sort order: Binary ordering, for the ISO 8859/1 or Latin-1 charact(iso_1).
Select a sort order.
Sort Order Chosen
1. Binary ordering, for the ISO 8859/1 or Latin-1 character set (is yes
2. General purpose dictionary ordering. no
3. Spanish dictionary ordering. no
4. Spanish case and accent insensitive dictionary order. no
5. Spanish case insensitive dictionary order. no
6. Dictionary order, case insensitive, accent insensitive. no
7. Dictionary order, case insensitive. no
8. Dictionary order, case insensitive with preference. no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
8. CONFIGURE SORT ORDER Complete
9. ACTIVATE AUDITING Incomplete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return: 9
ACTIVATE AUDITING
1. Install auditing: no
2. sybsecurity database size (Meg): 5
3. sybsecurity logical device name: sybsecurity
4. create new device for the sybsecurity database: no
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
SQL SERVER CONFIGURATION
SQL SERVER CONFIGURATION
1. CONFIGURE SERVER'S INTERFACES FILE ENTRY Complete
2. MASTER DEVICE CONFIGURATION Complete
3. SYBSYSTEMPROCS DATABASE CONFIGURATION Complete
4. SET ERRORLOG LOCATION Complete
5. CONFIGURE DEFAULT BACKUP SERVER Complete
6. CONFIGURE LANGUAGES Complete
7. CONFIGURE CHARACTER SETS Complete
8. CONFIGURE SORT ORDER Complete
9. ACTIVATE AUDITING Complete
Ctrl-a Accept and Continue, Ctrl-x Exit Screen, ? Help.
Enter the number of your choice and press return:
Execute the SQL Server Configuration now? y
WARNING: '/sybase/install/master.dat' is a regular file which is not recommended
for a Server device.
Press <return>; to continue.
Running task: create the master device.
Building the master device
.Done
Task succeeded: create the master device.
Running task: update the SQL Server runserver file.
Task succeeded: update the SQL Server runserver file.
Running task: boot the SQL Server.
waiting for server 'MYSERV' to boot...
Task succeeded: boot the SQL Server.
Running task: create the sybsystemprocs database.
sybsystemprocs database created.
Task succeeded: create the sybsystemprocs database.
Running task: install system stored procedures.
.....................................................................................................................Done
Task succeeded: install system stored procedures.
Running task: set permissions for the 'model' database.
Done
Task succeeded: set permissions for the 'model' database.
Running task: set the default character set and/or default sort order for the SQL Server.
Setting the default character set to iso_1
Sort order 'binary' has already been installed.
Character set 'iso_1' is already the default.
Sort order 'binary' is already the default.
Task succeeded: set the default character set and/or default sort order for the
SQL Server.
Running task: set the default language.
Setting the default language to us_english
Language 'us_english' is already the default.
Task succeeded: set the default language.
Configuration completed successfully.
Press <return>; to continue.
l 相同的方法配置BACKUP Server
![.NET程式員的技能分析參考V1.0(有附件)[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)