从事数据库工作多年,目前看好分布式NeSQL/HTAP数据库在企业客户市场的发展。未来的主要方向是——致力于 NewSQL/HTAP 数据库的推广普及。
分类: Sybase
2013-07-15 16:26:51
在安装完ASE 15.7 Server之后,接下来需要创建ASE Server以及ASE Backup Server。在这篇文章中,将向大家介绍如何使用响应文件创建它们。
1. 创建ASE Server
在成功安装完ASE 15.7 Server软件之后,在$SYBASE/ASE-15_0/init/sample_resource_files目录下有构建各种ASE Servers的示例响应文件:
* srvbuild.adaptive_server.rs #构建ASE Server的示例响应文件
* rvbuild.backup_server.rs #构建Backup Server的示例响应文件
* srvbuild.xp_server.rs #构建xp server的示例响应文件
* sqlloc.rs #修改AS Server字符集的示例响应文件
下面说明创建ASE Server的具体步骤:
(1) 编辑响应文件
cp $SYBASE/ASE-15_0/init/sample_resource_files/srvbuild.adaptive_server.rs /tmp/TPCSRV2K.rs
vi /tmp/TPCSRV2K.rs
下面是修改后的TPCSRV2K.rs文件的内容:
sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: TPCSRV2K
sqlsrv.sa_password: sybase
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: DBNode1
sqlsrv.network_port_list: 5080
sqlsrv.application_type: OLTP
sqlsrv.server_page_size: 2k
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: /opt/sybase/ase157/data/master.dat
sqlsrv.master_device_size: 160
sqlsrv.master_database_size: 120
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/ase157/data/sysprocs.dat
sqlsrv.sybsystemprocs_device_size: 160
sqlsrv.sybsystemprocs_database_size: 160
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/ase157/data/sybsysdb.dat
sqlsrv.sybsystemdb_device_size: 50
sqlsrv.sybsystemdb_database_size: 50
sqlsrv.tempdb_device_physical_name: /opt/sybase/ase157/data/tempdbdev.dat
sqlsrv.tempdb_device_size: 500
sqlsrv.tempdb_database_size: 500
sqlsrv.default_backup_server: TPCSRV2K_BS
#sqlsrv.addl_cmdline_parameters: PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
sqlsrv.do_configure_pci: no
sqlsrv.sybpcidb_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBPCIDB_DATA_DEVICE_HERE
sqlsrv.sybpcidb_device_size: USE_DEFAULT
sqlsrv.sybpcidb_database_size: USE_DEFAULT
# If sqlsrv.do_optimize_config is set to yes, both sqlsrv.avail_physical_memory and sqlsrv.avail_cpu_num need to be set.
sqlsrv.do_optimize_config: no
sqlsrv.avail_physical_memory: PUT_THE_AVAILABLE_PHYSICAL_MEMORY_FOR_ASE_IN_OPTIMIZATION
sqlsrv.avail_cpu_num: PUT_THE_AVAILABLE_NUMBER_CPU_FOR_ASE_IN_OPTIMIZATION
(2) 运行srvbuildres工具,创建 ASE Server
srvbuildres -r /tmp/TPCSRV2K.rs #构建Adaptive Server