sybase 데이터베이스 생성하기

sybase>$isql -Usa

use master
go

# size 단위는 block (1024 = 2M) 이다. 500000 은 약 1G
disk init name = "TMS_DEV", physname = "/datafile/sybase/dev/TMS_DEV.dat", size = 500000
go

disk init name = "TMS_LOG", physname = "/datafile/sybase/dev/TMS_LOG.dat", size = 50000
go

# size 단위는 Mbyte
create database TMS on TMS_DEV = 1024 log on TMS_LOG = 100
go

sp_addlogin tmsadmin, tmsadmin, TMS
go

use TMS
go

sp_changedbowner tmsadmin, true
go

use master
go
sp_dboption TMS, "trunc log on chkpt", true
go

use TMS
go
checkpoint
go

use master
go
sp_dboption TMS, "allow nulls by default", true
go

use TMS
go    
checkpoint
go

use master
go 
sp_dboption TMS, "select into/bulkcopy/pllsort", true
go

use TMS
go
checkpoint
go

use master
go
sp_dboption TMS, "abort tran on log full", true
go

use TMS
go
checkpoint
go