tpcso.f revision f2fc321be9b4df7748e8c31a5edd154b0177b139
#
# CDDL HEADER START
#
# The contents of this file are subject to the terms of the
# Common Development and Distribution License (the "License").
# You may not use this file except in compliance with the License.
#
# You can obtain a copy of the license at usr/src/OPENSOLARIS.LICENSE
# or http://www.opensolaris.org/os/licensing.
# See the License for the specific language governing permissions
# and limitations under the License.
#
# When distributing Covered Code, include this CDDL HEADER in each
# file and include the License file at usr/src/OPENSOLARIS.LICENSE.
# If applicable, add the following below this CDDL HEADER, with the
# fields enclosed by brackets "[]" replaced with your own identifying
# information: Portions Copyright [yyyy] [name of copyright owner]
#
# CDDL HEADER END
#
#
# Copyright 2007 Sun Microsystems, Inc. All rights reserved.
# Use is subject to license terms.
#
# ident "%Z%%M% %I% %E% SMI"
# $iosize - iosize for database block access
# $dir - directory for datafiles
# $nshadows - number of shadow processes
# $ndbwriters - number of database writers
set $dir=/tmp
set $runtime=30
set $iosize=2k
set $nshadows=200
set $ndbwriters=10
set $usermode=20000
set $memperthread=1m
debug 1
# Define a datafile and logfile
define file name=aux.df,path=$dir,size=251m,reuse,prealloc,paralloc
define file name=control_001,path=$dir,size=2m,reuse,prealloc,paralloc
define file name=cust_0_0,path=$dir,size=6704m,reuse,prealloc,paralloc
define file name=cust_0_1,path=$dir,size=6704m,reuse,prealloc,paralloc
define file name=cust_0_2,path=$dir,size=6704m,reuse,prealloc,paralloc
define file name=cust_0_3,path=$dir,size=6704m,reuse,prealloc,paralloc
define file name=dist_0_0,path=$dir,size=31m,reuse,prealloc,paralloc
define file name=hist_0_0,path=$dir,size=3002m,reuse,prealloc,paralloc
define file name=icust1_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
define file name=icust2_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
define file name=idist_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
define file name=iitem_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
define file name=iordr2_0_0,path=$dir,size=1651m,reuse,prealloc,paralloc
define file name=istok_0_0,path=$dir,size=2262m,reuse,prealloc,paralloc
define file name=item_0_0,path=$dir,size=21m,reuse,prealloc,paralloc
define file name=iware_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
define file name=nord_0_0,path=$dir,size=561m,reuse,prealloc,paralloc
define file name=ordr_0_0,path=$dir,size=44301m,reuse,prealloc,paralloc
define file name=roll1,path=$dir,size=2001m,reuse,prealloc,paralloc
define file name=sp_0,path=$dir,size=1001m,reuse,prealloc,paralloc
define file name=stok_0_0,path=$dir,size=8052m,reuse,prealloc,paralloc
define file name=stok_0_1,path=$dir,size=8052m,reuse,prealloc,paralloc
define file name=stok_0_2,path=$dir,size=8052m,reuse,prealloc,paralloc
define file name=stok_0_3,path=$dir,size=8052m,reuse,prealloc,paralloc
define file name=stok_0_4,path=$dir,size=8052m,reuse,prealloc,paralloc
define file name=system_1,path=$dir,size=401m,reuse,prealloc,paralloc
define file name=temp_0_0,path=$dir,size=4943m,reuse,prealloc,paralloc
define file name=temp_0_1,path=$dir,size=4943m,reuse,prealloc,paralloc
define file name=ware_0_0,path=$dir,size=11m,reuse,prealloc,paralloc
define file name=log_1_1,path=$dir,size=1021m,reuse,prealloc,paralloc
# Define database writer processes
define process name=dbwr,instances=$ndbwriters
{
{
}
}
define process name=lgwr,instances=1
{
{
# flowop delay name=lg-delay,value=1
}
}
define process name=shadow,instances=$nshadows
{
{
}
}
echo "Tpcso Version 2.0 personality successfully loaded"
usage "Usage: set \$dir=<dir>"
usage " "
usage " set \$iosize=<value> defaults to $iosize, typically 2k or 8k"
usage " "
usage " set \$memperthread=<value> defaults to $memperthread, there are 211 threads"
usage " "
usage " run runtime (e.g. run 60)"
usage " "
usage "Note - this workload needs at least 512MB of of memory"
usage " "