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


TAG

댓글을 달아 주세요

1 ··· 565 566 567 568 569 570 571 572 573 ··· 724 

글 보관함

카운터

Total : 1,754,330 / Today : 10 / Yesterday : 20
get rsstistory!