Database Options

Enabled Options

select into/bulkcopy/pllsort

trunc log on chkpt

Placement

Device Name	Size	Usage
data_dev5	500	data only
data_dev7	100	data only
data_dev7	100	data only
log_dev1	110	log only
log_dev1	20	log only
log_dev4	50	log only
log_dev4	50	log only

Database Usage

Data	446.63 (63.80 %)
Indexes	89.62 (12.80 %)
Unused	10.50 (1.50 %)
Unreserved	153.24 (21.89 %)

Log Usage

Log Used	24.56 (10.68 %)
Log Unused	205.44 (89.32 %)

DDL

USE master
go
CREATE DATABASE icsa_tmp
    ON data_dev5=500
    LOG ON log_dev1=110
go
ALTER DATABASE icsa_tmp 
    ON data_dev7=100
go
ALTER DATABASE icsa_tmp 
    ON data_dev7=100
go
ALTER DATABASE icsa_tmp 
    LOG ON log_dev1=20
go
ALTER DATABASE icsa_tmp 
    LOG ON log_dev4=50
go
ALTER DATABASE icsa_tmp 
    LOG ON log_dev4=50
go
USE master
go
EXEC sp_dboption 'icsa_tmp','select into/bulkcopy/pllsort',true
go
EXEC sp_dboption 'icsa_tmp','trunc log on chkpt',true
go
USE icsa_tmp
go
CHECKPOINT
go
USE icsa_tmp
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','icsa_tmp','data_dev5'
go
EXEC sp_extendsegment 'default','icsa_tmp','data_dev7'
go
EXEC sp_addsegment 'logsegment','icsa_tmp','log_dev1'
go
EXEC sp_extendsegment 'logsegment','icsa_tmp','log_dev4'
go
EXEC sp_addthreshold 'icsa_tmp','logsegment',6944,'sp_thresholdaction'
go
EXEC sp_addsegment 'system','icsa_tmp','data_dev5'
go
EXEC sp_extendsegment 'system','icsa_tmp','data_dev7'
go