ase15 和 ase15.0.3 创建服务模板区别？
本帖最后由 wangliangkaiser 于 2010-05-07 23:28 编辑系统平台：IBM AIX5.3
sybase： ASE15.0
模板文件：/sybase15/ASE-15_0/init/sample_resource_files/srvbuild.adaptive_server.rs
sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
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.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
注意：以上参数设置，大家都熟悉，这里不一一说明：
----------------------------------------------------------------------------------------------------
系统平台：IBM AIX5.3
sybase： ASE15.0.3
模板文件：/sybase15/ASE-15_0/init/sample_resource_files/srvbuild.adaptive_server.rs
sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
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.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
#sqlsrv.addl_cmdline_parameters: PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
#sqlsrv.addl_build_parameters: PUT_ANY_ADDITIONAL_BUILD_PARAMETERS_HERE
sqlsrv.cluster_input_file: PUT_THE_PATH_OF_YOUR_CLUSTER_INPUT_FILE_HERE
sqlsrv.create_cluster_id: yes
sqlsrv.build_quorum: yes
sqlsrv.force_build_quorum: no
sqlsrv.quorum_device_physical_name: PUT_THE_PATH_OF_YOUR_QUORUM_DEVICE_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
以上两个文件的区别在 红色的粗体部分，。。。
我在ase15.0.3版本在aix5.3平台上安装完成后，用这个资源文件来创建服务，文本如下
sybinit.release_directory: /sybase15
sybinit.product: sqlsrv
sqlsrv.server_name: WHDS
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: 192.168.1.131
sqlsrv.network_port_list: 4100
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: yes
sqlsrv.master_device_physical_name: /dev/rmaster
sqlsrv.master_device_size: 200
sqlsrv.master_database_size: 100
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /dev/rsystemprocs
sqlsrv.sybsystemprocs_device_size: 200
sqlsrv.sybsystemprocs_database_size: 140
sqlsrv.sybsystemdb_device_physical_name: /dev/rsystemdb
sqlsrv.sybsystemdb_device_size: 100
sqlsrv.sybsystemdb_database_size: 50
sqlsrv.default_backup_server: SYBASE_BACKUP
提示下列错误信息，，，，不知如何解决（问题在于不知道上面粗体部分不知道怎样用）
p570_lp02:sybase15:/sybase15> srvbuildres -r db.rs
Building Adaptive Server 'WHDS':
Writing entry into directory services...
Directory services entry complete.
Building master device...
Task failed
dataserver: quorum device is required.Pass 'Q' on the command line or set the 'DSQUORUM' environment variable.
Usage: dataserver <option list>
Valid options:
-h, --help=[{0|1|2|3}[,display_width]] - print this help message, and exit
-u, --admin-name=sa/sso_name - login name of SA/SSO user
-a, --caps-file=filename - path to CAPs directive file
-L, --conn-config-file= - connectivity configuration file;
default: 'config'
-D, --default-db-size=size_spec - default database size specifier
-e, --error-log= - error log file name;
default: 'instancename.log'
-G, --event-log-server=logserv_name - event log server name
-f, --forcebuild - force initialization of a device or
database
-H, --ha-server - start HA server
-y, --key-password= - password to decrypt server's private
key
-K, --keytab-file=filename - keytab file name
-N, --license-prop-file=filename - license properties file name
-z, --logical-page-size=page_size - server page size specifier
-Z, --master-db-size=size_spec - initial master database size
specifier
-d, --master-dev=master_device_name - master device name
-b, --master-dev-size= - master device size specifier
-r, --master-mirror=filename - *** Unsupported option ***
-m, --masterrecover - 'master recover' mode, restricted to
a single user
-g, --no-event-logging - turn off event logging
-q, --recover-quiesced - recover quiesced user databases as
for 'load database'
-w, --rewrite-db=database_name - database name to rewrite
-p, --sa-name=sa_name - login name of SA user
-k, --server-principal=s_principal - server principal name
-M, --shared-mem-dir=directory_name - shared-memory-repository directory
-X, --sybmon - start this server as sybmon
-T, --trace=trace_flag - set command-line trace flag
-v, --version - print version message, and exit
--buildquorum= - build a new quorum device,
optionally forcing the overwrite of
an existing device
-F, --cluster-input=filename - cluster input file pathname
--cluster-takeover - perform a cluster takeover if the
quorum device indicates the cluster
is running but no heartbeats are
being written to the quorum
--create-cluster-id - generate a new unique cluster id to
pair the quorum and master devices
--instance=instance_name - boot as the named instance
-Q, --quorum-dev=quorum_dev - quorum device name
Server 'WHDS' was not created.
希望高人帮我指点一下，也希望遇到同类问题的同仁也有借鉴参考！谢谢 sqlsrv.cluster_input_file: PUT_THE_PATH_OF_YOUR_CLUSTER_INPUT_FILE_HERE
sqlsrv.create_cluster_id: yes
sqlsrv.build_quorum: yes
-------------------------------------------------------------------------
这个是cluster版的ase15.0.3吧？ 本帖最后由 wangliangkaiser 于 2010-05-08 12:07 编辑
首先感谢楼上兄弟热心回复，
再次表示感谢，另外这个ase的版本为：ASE 1503 CE IBM64就是cluste版本
只创建ASE服务， 这个版本难道非要定义红色部分，才能创建ase服务吗？ srvbuildres -r db.rs
如果要定义，该如何着手，，，麻烦指点。。。。 谢谢 :em03:您正在看的文章转载枫林阁：
http://www.56fjk.cn
原文地址:
http://www.56fjk.cn/news/2010521/61.html 4楼是干吗的？ 4楼真无聊， ~ sqlsrv.create_cluster_id: yes
这句改为No试一试啊。
我的是ASE15.0.3，用下面的这个RS文件：sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: XXXX
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: YYYY
sqlsrv.network_port_list: 5000
sqlsrv.application_type: USE_DEFAULT
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: /dev/rlv_ase_master
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /dev/rlv_ase_systempr
sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: /dev/rlv_ase_systemdb
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.tempdb_device_physical_name: /dev/rlv_ase_tempdb
sqlsrv.tempdb_device_size: USE_DEFAULT
sqlsrv.tempdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: XXXX_BS
#sqlsrv.addl_cmdline_parameters: PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
sqlsrv.do_configure_pci: no
sqlsrv.sybpcidb_device_physical_name: /dev/rlv_ase_sybpcidb
sqlsrv.sybpcidb_device_size: USE_DEFAULT
sqlsrv.sybpcidb_database_size: USE_DEFAULT
sqlsrv.do_optimize_config: no
sqlsrv.avail_physical_memory: USE_DEFAULT
sqlsrv.avail_cpu_num: USE_DEFAULT
PCIDB我也不知道是干啥的，设置为no以后一切正常，能build :hug::hug::hug: 谢谢！好久没来chinaunix，看到8年前问题有朋友回复，感动！
页:
[1]