-----------------------------------------------------
LCF本人以前的笔记，记录一下！以免时间长了望了！
UnixWare7.1.1参数
1）系统核心参数调整
更改文件/etc/conf/cf.d/stune，增加以下内容，（可调用/profile/1192下stune文件）
MSGMAX 32768
MSGMNB 65536
MSGMNI 300
MSGSSZ 262144
MSGTQL 512
SEMMNI 1500
SEMMSL 150
SEMUME 20
SHMMNI 100
SHMSEG 15
SHMMAX 102400000
SHMALL 2048
NPROC 500
ARG_MAX 51200
SFNOLIM 400
SFSZLIM 0x7FFFFFFF
HFSZLIM 0x7FFFFFFF
SDATLIM 0x7FFFFFFF
HDATLIM 0x7FFFFFFF
SCORLIM 0x7FFFFFFF
HCORLIM 0x7FFFFFFF
SVMMLIM 0x7FFFFFFF
HVMMLIM 0x7FFFFFFF
SSTKLIM 0x7FFFFFFF
HSTKLIM 0x7FFFFFFF
-----------------------------------------------------
若系统作为专门的数据库服务器可加入：
ET_AGE_INTERVAL 10
INIT_AGEQUANTUM 100
MAX_AGEQUANTUM 120
MIN_AGEQUANTUM 50
MAXRSS 125000
若系统内存大于4GB需加入：
DEDICATED_MEMORY 1011712
UVIRT_EXTENSION 237568
重建内核，#/etc/conf/bin/idbuild -B，重启计算机。检查/etc/conf/cf.d/stune.current 中的SHMMAX项是否已经生效。
2)将Aasynchronism IO设置为Available
更改核心参数文件：
# vi /etc/conf/node.d/async 改600 为777
# /etc/conf/bin/idbuild CB
#shutdown Cy Cg0 Ci6
-----------------------------------------------------
sybase .profile文件参数
SYBASE=/sybase
DSQUERY=SYBASE
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SYBASE/lib:/usr/local/lib:.
LD_RUN_PATH=$LD_RUN_PATH:$SYSBASE/lib:/usr/local/lib:.
PATH=$SYBASE/bin:$SYBASE/install:$PATH:.
export SYBASE DSQUERY PATH LD_LIBRARY_PATH LD_RUN_PATH
BANKCOM=/mbfe
BEPSMBFE=/bepsmbfe
BEMUHOME=/bemu/mbfeemu
export BANKCOM BEPSMBFE BEMUHOME
-----------------------------------------------------------
mknod /sybase/data/master b 7679 16
mknod /sybase/data/systemdb b 7679 17
mknod /sybase/data/tempdb b 7679 18
mknod /sybase/data/systemprocs b 7679 19
mknod /sybase/data/wkdatadb b 7679 20
mknod /sybase/data/wkindexdb b 7679 21
mknod /sybase/data/wkdblog b 7679 22
mknod /sybase/data/hisdatadb b 7679 23
mknod /sybase/data/hisindexdb b 7679 24
mknod /sybase/data/hisdblog b 7679 25
mknod /sybase/data/ssyscdt b 7679 26
mknod /sybase/data/cmtmsgdt1 b 7679 27
mknod /sybase/data/cmtmsgdt2 b 7679 28
mknod /sybase/data/cmtmsgdt3 b 7679 29
mknod /sybase/data/apiqueudt b 7679 30
mknod /sybase/data/comqueudt b 7679 31
mknod /sybase/data/bepstrxsdt b 7679 32
mknod /sybase/data/bepsinfodt b 7679 33
mknod /sybase/data/bepspmisdt b 7679 34
mknod /sybase/data/dirwaysidx b 7679 35
mknod /sybase/data/dirwayslog b 7679 36
mknod /sybase/data/diswayswkdt b 7679 37
mknod /sybase/data/diswayshisdt b 7679 38
mknod /sybase/data/diswaysidx b 7679 39
mknod /sybase/data/diswayslog b 7679 40
mknod /sybase/data/simudatadb b 7679 41
mknod /sybase/data/simuindexdb b 7679 42
mknod /sybase/data/simudblog b 7679 43
chown -R sybase:sybase /sybase/data;chmod 770 /sybase/data
chown sybase:sybase /sybase/data/*;chmod 660 /sybase/data/*
-----------------------------------------------------------
/cdrom/sybload -D
Y
L
/cdrom/sybimage
Y
BKBYBK BKBKBY BFKZBK BKBYBY TMVOVG ZEBQ
1,5
两次回车
-----------------------------------------------------
vi ase.rs(master 120M / tempdb 140M / systemdb 240M / systemprocs 240M)
sybinit.release_directory: /sybase
sybinit.product: sqlsrv
sqlsrv.server_name: SYBASE
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tli tcp
sqlsrv.network_hostname_list: 192.168.0.77
sqlsrv.network_port_list: 8000
sqlsrv.master_device_physical_name: /sybase/data/master
sqlsrv.master_device_size: 66
sqlsrv.master_database_size: 50
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /sybase/data/systemprocs
sqlsrv.sybsystemprocs_device_size: 60
sqlsrv.sybsystemprocs_database_size: 50
sqlsrv.sybsystemdb_device_physical_name: /sybase/data/systemdb
sqlsrv.sybsystemdb_device_size: 60
sqlsrv.sybsystemdb_database_size: 50
sqlsrv.default_backup_server: SYB_BACKUP
-----------------------------------------------------
vi back.rs
sybinit.release_directory: /sybase
sybinit.product: bsrv
bsrv.server_name: SYB_BACKUP
bsrv.do_add_backup_server: yes
bsrv.network_protocol_list: tli tcp
bsrv.network_hostname_list: 192.168.0.77
bsrv.network_port_list: 8001
bsrv.language: USE_DEFAULT
bsrv.character_set: USE_DEFAULT
bsrv.tape_config_file: USE_DEFAULT
bsrv.errorlog: USE_DEFAULT
-----------------------------------------------------
初始化
srvbuildres -r ase.rs;srvbuildres -r back.rs
-----------------------------------------------------
自动启动和关闭/etc/rc2.d和/etc/rc0.d
S99sybase文件内容如下：
su - sybase -c "/sybase/install/startserver -f /sybase/install/RUN_SYBASE"
su - sybase -c "/sybase/install/startserver -f /sybase/install/RUN_SYB_BACKUP"
K21sybase文件内容如下：
su - sybase -c "/sybase/bin/isql -Usa -P -i /sybase/down.sql"
down.sql文件内容如下：
shutdown SYB_BACKUP
go
shutdown
go
-----------------------------------------------------
/*参数调整（小枫制作）*/
/*说明
select @@max_connections
number of user connections + (number of devices * max online engines * 2)
+ number of remote sites + max number network listeners<=@@max_connections
以下是影响内存的参数，其它参数影响较小。
total memory 以2k为单位。
procedure cache percent 缺省20，
number of open databases 缺省12，17KB/1。
number of devices 缺省10，512B/1。
number of open objects 缺省500，1KB/1。
number of user connectons 缺省25，70KB/1
number of open indexes 缺省500，
number of locks 缺省5000，100B/1。
*/
select @@version
go
sp_configure 'total memory', 51200
go
sp_configure 'procedure cache percent', 30
go
sp_configure 'number of devices', 99
go
sp_configure 'number of user connections', 60
go
sp_configure 'number of locks', 200000
go
sp_configure 'number of large i/o buffers', 20
go
sp_configure 'number of open databases', 20
go
sp_configure 'number of open objects', 600
go
sp_configure 'max online engine', 1
go
sp_diskdefault 'master', defaultoff
go
-----------------------------------------------------
sp_help
sp_helpdb
sp_helpxxx
---清日志方法---
dump tran MBFEWKDB with trncate_only
dump tran MBFEHISDB with trncate_only
dump tran DIRWAYSDB with trncate_only
dump tran DISWAYSDB with trncate_only
dump tran MBFESIMUDB with trncate_only
---备份数据库---
dump database MBFEWKDB to '/sybase/MBFEWKDB`date +%w`'
dump database MBFEHISDB to '/sybase/MBFEHISDB`date +%w`'
dump database DIRWAYSDB to '/sybase/DIRWAYSDB`date +%w`'
dump database DISWAYSDB to '/sybase/DISWAYSDB`date +%w`'
dump database MBFESIMUDB to '/sybase/MBFESIMUDB`date +%w`'
---备份日志---
dump transaction 数据库 to 文件
---恢复数据库---
load database MBFEWKDB from '/sybase/MBFEWKDB`date +%w`'
load database MBFEHISDB from '/sybase/MBFEHISDB`date +%w`'
load database DIRWAYSDB from '/sybase/DIRWAYSDB`date +%w`'
load database DISWAYSDB from '/sybase/DISWAYSDB`date +%w`'
load database MBFESIMUDB from '/sybase/MBFESIMUDB`date +%w`'
---注：恢复数据库后，要重新激活---
online 数据库
---恢复日志---
load transaction 数据库 from 文件
-----------------------------------------------------
-----------------------------------------------------
/*建库模版（小枫制作）*/
use master
go
disk init name='lcf1',physname='/sybase/data/lcf1',vdevno=10,size=51200
disk init name='lcf2',physname='/sybase/data/lcf2',vdevno=11,size=51200
disk init name='lcf3',physname='/sybase/data/lcf3',vdevno=12,size=51200
disk init name='lcf4',physname='/sybase/data/lcf4',vdevno=13,size=51200
go
create database LCFDB on lcf1=100,lcf2=100 log on lcf3=100
go
/*修改数据库参数*/
sp_diskdefault 'master', defaultoff
go
sp_diskdefault 'LCFDB', defaulton
go
alter database tempdb on lcf4=100
go
sp_dboption LCFDB,'trunc log on chkpt',true
go
sp_dboption LCFDB,'select into/bulkcopy',true
go
sp_dboption LCFDB.'ddl in tran',true
go
/*建登陆用户，建组，建用户*/
sp_addlogin lcfuser,123456,LCFDB
go
sp_role "grant",sa_role,lcfdb
go
set role sa_role on
go
use LCFDB
go
sp_addgroup lcfgrp
go
sp_adduser lcfuser,lcfuser,lcfgrp
go
-----------------------------------------------------
大额
小额
http://219.133.5.218/downloads/cnapsspatch.htm
金融联
http://219.133.5.218/cn
-----------------------------------------------------