配置SYBASE服务器

配置SYBASE服务器
1. 为SYBASE SERVER创建所需的设备
建议将sybase server的数据库设备创建在裸设备上，因此，在系统中创建以下逻辑卷：
lvname=master,size=100M
lvname=sybproc,size=100M
lvname=sybsystem,size=100M()
修改对应设备文件权限：
# chown sybasesybase devmaster devrmaster
# chown sybasesybase devsybproc devrsybproc
# chown sybasesybase devsybsystem devrsybsystem()
# chmod 600 devmaster devrmaster devsybproc devrsybproc
# chmod 600 devsybsystem devrsybsystem()
2. 设置系统环境
共享内存要求
Platform Number of 2K Pages Amount of Memory
HPUX 9,000 18 MB
IBM RS6000 9,000 18 MB
修改系统共享内存。
异步IO要求
n IBM AIX
激活异步IO。
# smitty chgaio
如果系统同时有多于7个磁盘使用异步IO，对于每个设备将参数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 IO 4096
Server PRIORITY 39
ASYNC IO 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必须是 devasync的属主，执行以下命令：
# etcmknod devasync c 101 4
# chmod 0660 devasync
# chown sybase devasync
修改系统参数(SCO OPEN SERVER only)
# vi etcconfcf.dstune
加入以下行：
SHMMAX XXXXXXXX (XXXXXXXX为最大共享内存，如64M为67108864)
NFILE 3000
NOFILES 1024

# vi etcconfsdevice.daio
将”N”改为”Y”。
# vi etcconfsdevice.dsuds
将”N”改为”Y”。
# etcconfcf.dlink_unix
重链核心。
# vi etcrc2
加入行：
etcsuds_ctrl -a sybase组id号

# shutdown -y -i0 -g0 重新开机
修改sybase用户的.profile
编辑sybase.profile文件，如下：
SYBASE=sybase
DSQUERY=ABIS_SERV
PATH=$PATH..$SYBASEbin$SYBASEinstall
LIBPATH=$SYBASElib
export SYBASE DSQUERY PATH LIBPATH
也可以将这些环境变量的设置放在系统的环境设置文件中（如AIX的etcenvironment）。
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 sybaseABIS_SERV.rs
$ cp srvbuild.backup_servers.rs sybaseABIS_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
work_protocol_list tcp
work_hostname_list PUT_YOUR_HOSTNAME_HERE
work_port_list PUT_YOUR_PORT_NUMBER_HERE
sqlsrv.master_device_physical_namedevrmaster
sqlsrv.master_device_size 100
sqlsrv.master_database

_size USE_DEFAULT
sqlsrv.errorlog USE_DEFAULT
sqlsrv.do_upgrade no
sqlsrv.sybsystemprocs_device_physical_name devrsybproc
sqlsrv.sybsystemprocs_device_size 100
sqlsrv.sybsystemprocs_database_size USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name devrsybsystem()
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
work_protocol_list tcp
work_hostname_list PUT_YOUR_HOSTNAME_HERE
work_port_list PUT_YOUR_PORT_NUMBER_HERE
nguage 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 initsample_resource_filessqlloc.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
nguage_install_list USE_DEFAULT
nguage_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
1select @@version
2go
1alter database master on master=25 扩大MASTER数据库
2go
1sp_helpdb
查看数据库信息
2go
1sp_addserver SYB_BACKUP,null,ABIS_SERV_backup
建立BACKUPSERVER与DBSERVER的连接
2go
1sp_addserver “ABIS_SERV”,local
2go
命名本服务器，需重启server
1sp_helpserver
2go
1sp_configure total memory,358400
为SYBASE指定其使用的内存(700M)，需重启动server
2go
1sp_configure user connections,100
SYBASE可使用的用户连接
2go
1sp_password NULL,”new_sa_password” 修改sa口令
2go
1sp_diskdefault master,defaultoff 修改master设备的缺省状态
2go
1shutdown SYB_BACKUP
必须先shutdown BACKUP server
2go
1shutdown
然后shutdown DB server
2go
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
1dump database master to sybaseinstallmaster.dump
2go
1dump database sybsystemprocs to sybaseinstallsybprocs.dump
2go
1quit
7. 修改配置文件(Server)
$ cd sybase
$ vi ABIS_SERV.cfg 该文件是该服务器的所有配置信息，可以直接修改此文

件。
修改配置文件后，最好使用以下命令进行检验修改是否正确：
$ isql –Usa –SABIS_SERV –P
1sp_configure configuration file, 0,verify,sybaseABIS_SERV.cfg
2go
(return status = 0)
1quit
8. 修改配置文件(Client)
根据需要，可能需要修改Open Client的某些配置文件，才能正常使用应用程序。
可能需要修改的有：
l $SYBASEconfiglibtcl.cfg
注释掉所有段如[drivers],[directory],[security]内的所有行。
l $SYBASEconfigocs.cfg
添加对应的server需要的段。
l $SYBASElocaleslocales.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. ESQLC
2. Open ClientServer C
3. XA Library for CICS
4. All Client products patchs

3. 在BS(DS+AS)上安装的产品及顺序
1. ESQLC
2. Open ClientServer 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 ClientServer C 10.0.4
3. ESQLC 10.0.4
4. SQL Server patch and OCS patch
5. 在SCO OPENSERVER上创建SQL Server
l 以用户sybase登录，运行$SYBASEinstallsybinit。
$ installsybinit
The log file for this session is 'sybaseinitlogslog0510.001'.

SYBINIT

1. Release directory sybase

2. Edit View Interfaces File

3. Configure a Server product
4. Configure an Open ClientServer 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. HostnameAddress
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
')localhost

EDIT TCP SERVICE

1. HostnameAddress 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. HostnameAddress 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 ClientServer 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 2207
2. Backup Server Oct 18 1996 2207

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 sybasemaster.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 'sybasemaster.dat')sybaseinstallmaster.dat

WARNING 'sybaseinstallmaster.dat' is a regular file which is not recommended for a Server device.
Press return to continue.

MASTER DEVICE CONFIGURATION

1. Master Device sybaseinstallmaster.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 sybaseinstallmaster.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 sybasesybprocs.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
sybaseinstallsybprocs.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 sybaseinstallsybprocs.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 sybaseinstallerrorlog

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 88591 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 88591 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 88591 or Latin-1 charact(iso_1).

Select a sort order.

Sort Order Chosen
1. Binary ordering, for the ISO 88591 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 'sybaseinstallmaster.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.
.....................................................................................................................Don e
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 andor 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 andor 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。