星期二, 9月 23, 2014

如何手動建立sybase 資料庫 (ASE 15.7)

如何手動建立sybase 資料庫

Creates a new installation with a 100MB master device and a 4K page:

dataserver -d my_master_device -z 4k -b 100.02M

#
startserver -f /opt/sybase/ASE-15_0/install/RUN_sybdba

#我的server name為 sybdba
isql -U sa -P -S sybdba

#Initial 200MB的空間, vdevno 不可重複
disk init name= "users_device",
physname="/opt/sybase/data/users_device.dat",
vdevno = 4, size= 102400
go

#建立log device, 200MB, 102400 x 2k /1024=200
disk init
name=logdev,
physname="/opt/sybase/data/logdev.dat",
size=102400
go

create database sybdba on users_device = "20M"  log on logdev="20M"
go

#後來發現master空間還是不夠, 要再放大
disk resize name="master", size="130M"
go
disk resize name="logdev", size="130M"
go

isql -U sa -P -i ./ASE-15_0/scripts/installmaster -S sybdba


#vi /opt/sybase/ASE-15_0/bin/ddlgen , 把linux 的java 路徑改為
#ddlgen -Usa -Proy123 -Smaster:5000 -TDB -Nmaster

sp_password NULL, 'sybase@sap'
go
Password correctly set.
(return status = 0)
1>

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...