set shmsys:shminfo_shmmax=1310720000 .profile SYBASE=/usrlocal/vlol001/sybase DSQUERY=e3500 export SYBASE DSQUERY SYBASE_FTS=FTS-12_0 export SYBASE_FTS SYBASE_REP=REP-12_0 export SYBASE_REP PATH=/usr/bin:/usr/ucb:/etc:. export PATH PATH=/usrlocal/vlol001/sybase/ASE-12_0/bin:/usrlocal/vlol001/sybase/ASE-12_0/install:/usrlocal/vlol001/sybase/REP-12_0/bin:/usrlocal/vlol001/sybase/OCS-12_0/bin:$PATH export PATH SYBASE_OCS=OCS-12_0 export SYBASE_OCS SYBASE_ASE=ASE-12_0 export SYBASE_ASE LM_LICENSE_FILE=/usrlocal/vlol001/sybase/SYSAM-1_0/licenses/license.dat:$LM_LICENSE_FILE export LM_LICENSE_FILE LD_LIBRARY_PATH=/usrlocal/vlol001/sybase/ASE-12_0/lib:/usr/local/openwin/lib:/usrlocal/vlol001/sybase/FTS-12_0/lib:/usrlocal/vlol001/sybase/OCS-12_0/lib:/usr/local/openwin/lib:/usr/lib:/usrlocal/vlol001/sybase/SQLRemote/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH SYBASE_SYSAM=SYSAM-1_0 export SYBASE_SYSAM stty istrip DISPLAY=e3500:0.0 export DISPLAY *****sybase的裸设备不能用0柱面****** 安装完毕后要进行一些必要的处理工作( 给sa加密码,把磁带机加入为dumpdevice,扩大tempdb的大小,disable temp在master device上的段,) isql -Usa -P use master go sp_password null, "password" go sp_dropserver local go sp_addserver FOO, local go sp_dropdevice tapedump1 go sp_dropdevice tapedump2 go sp_addumpdevice "tape", "dds2_tape", "/dev/rmt/0cn", 7000 go disk init name = "tempdb_dev", physname = "/sybase/devs/tempdb.dev", vdevno = 4, size = 25600 go
alter database tempdb on tempdb_dev = 50 go use tempdb go sp_dropsegment "default", tempdb, master go sp_dropsegment "logsegment", tempdb, master go sp_dropsegment "system", tempdb, master go |