|
|
The Fastest Informix DBA and Grand Prize
Winner - Tatiana Saltykova
|
Fastest IBM Developer (IBM employee) -
Spokey Wheeler
|
Fastest DBA on Monday (First day of the
contest) - Tom Girsch
|
Fastest International DBA (Non USA
resident) - Denis Zhuravlev
|
Fastest Mid-Aged DBA (30-50) - Andrew
Ford
|
PHYSFILE
100000
|
PHYSFILE 200000
|
PHYSFILE
50000
|
PHYSFILE
50000
|
PHYSFILE 3000000
|
PHYSBUFF
128
|
PHYSBUFF
256
|
PHYSBUFF
128
|
PHYSBUFF
1024
|
PHYSBUFF
256
|
LOGBUFF
64
|
LOGBUFF
128
|
LOGBUFF
64
|
LOGBUFF
1024
|
LOGBUFF
128
|
LTXHWM
50
|
LTXHWM
70
|
LTXHWM
50
|
LTXHWM
50
|
LTXHWM
50
|
LTXEHWM
60
|
LTXEHWM
80
|
LTXEHWM
60
|
LTXEHWM
60
|
LTXEHWM
60
|
TBLSPACE_STATS
0
|
TBLSPACE_STATS
1
|
TBLSPACE_STATS
1
|
TBLSPACE_STATS
0
|
TBLSPACE_STATS
0
|
DBSPACETEMP tmpdbs,tmpdbs2,tmpdbs3
|
DBSPACETEMP
|
DBSPACETEMP
tmpdb1,tmpdb2,tmpdb3
|
DBSPACETEMP
tmpdbs
|
DBSPACETEMP
tmpdbs
|
NETTYPE
ipcshm,2,100,CPU
|
NETTYPE
ipcshm,1,50,CPU
|
NETTYPE
ipcshm,1,50,CPU
|
NETTYPE
ipcshm,1,200,CPU
|
NETTYPE
ipcshm,1,50,CPU
|
NETTYPE
soctcp,1,50,NET
|
NETTYPE
soctcp,2,100,NET
|
NETTYPE
soctcp,1,50,NET
|
NETTYPE
soctcp,1,200,NET
|
NETTYPE
soctcp,2,100,NET
|
VPCLASS
cpu,num=4,noage
|
VPCLASS
cpu,num=3,noage
|
VPCLASS
cpu,num=1,noage
|
VPCLASS
cpu,num=8,noage
|
VPCLASS
cpu,num=7,noage
|
CLEANERS
8
|
CLEANERS
9
|
CLEANERS
8
|
CLEANERS
8
|
CLEANERS
12
|
AUTO_AIOVPS
1
|
AUTO_AIOVPS
1
|
AUTO_AIOVPS
1
|
AUTO_AIOVPS
1
|
AUTO_AIOVPS
1
|
DIRECT_IO
1
|
DIRECT_IO
1
|
DIRECT_IO
0
|
DIRECT_IO
1
|
DIRECT_IO
1
|
LOCKS
10000
|
LOCKS
50000
|
LOCKS
2000
|
LOCKS
500000
|
LOCKS
1000000
|
RESIDENT
-1
|
RESIDENT
-1
|
RESIDENT
0
|
RESIDENT
1
|
RESIDENT
1
|
SHMVIRTSIZE
64656
|
SHMVIRTSIZE
256000
|
SHMVIRTSIZE
32656
|
SHMVIRTSIZE
500000
|
SHMVIRTSIZE
500000
|
SHMADD
8192
|
SHMADD
81920
|
SHMADD
8192
|
SHMADD
100000
|
SHMADD
8192
|
CKPTINTVL
900
|
CKPTINTVL
1200
|
CKPTINTVL
300
|
CKPTINTVL
9999
|
CKPTINTVL
300
|
STMT_CACHE
2
|
STMT_CACHE
0
|
STMT_CACHE
0
|
STMT_CACHE
1
|
STMT_CACHE
2
|
STMT_CACHE_HITS
0
|
STMT_CACHE_HITS
0
|
STMT_CACHE_HITS
0
|
STMT_CACHE_HITS
2
|
STMT_CACHE_HITS
0
|
STMT_CACHE_SIZE
512
|
STMT_CACHE_SIZE
512
|
STMT_CACHE_SIZE
512
|
STMT_CACHE_SIZE
5120
|
STMT_CACHE_SIZE
2048
|
STMT_CACHE_NOLIMIT
0
|
STMT_CACHE_NOLIMIT
0
|
STMT_CACHE_NOLIMIT
0
|
STMT_CACHE_NOLIMIT
0
|
STMT_CACHE_NOLIMIT
1
|
STMT_CACHE_NUMPOOL
1
|
STMT_CACHE_NUMPOOL
1
|
STMT_CACHE_NUMPOOL
1
|
STMT_CACHE_NUMPOOL
1
|
STMT_CACHE_NUMPOOL
26
|
FILLFACTOR
70
|
FILLFACTOR
90
|
FILLFACTOR
90
|
FILLFACTOR
95
|
FILLFACTOR
90
|
MAX_FILL_DATA_PAGES
0
|
MAX_FILL_DATA_PAGES
1
|
MAX_FILL_DATA_PAGES
0
|
MAX_FILL_DATA_PAGES
0
|
MAX_FILL_DATA_PAGES
0
|
BTSCANNER
num=1,threshold=5000,rangesize=-1,alice=6,compression=default
|
BTSCANNER
num=2,threshold=500000,rangesize=-1,alice=6,compression=default
|
BTSCANNER
num=1,threshold=5000,rangesize=-1,alice=6,compression=default
|
BTSCANNER
num=1,threshold=5000,rangesize=-1,alice=6,compression=default
|
BTSCANNER
num=1,threshold=5000,rangesize=-1,alice=6,compression=default
|
DS_MAX_QUERIES 1
|
DS_MAX_QUERIES
|
DS_MAX_QUERIES
|
DS_MAX_QUERIES
1
|
DS_MAX_QUERIES
1
|
DS_TOTAL_MEMORY 1048576
|
DS_TOTAL_MEMORY
|
DS_TOTAL_MEMORY
|
DS_TOTAL_MEMORY
100000
|
DS_TOTAL_MEMORY
250000
|
DS_MAX_SCANS
1048576
|
DS_MAX_SCANS
1048576
|
DS_MAX_SCANS
1048576
|
DS_MAX_SCANS
104
|
DS_MAX_SCANS
1048576
|
DS_NONPDQ_QUERY_MEM
1024
|
DS_NONPDQ_QUERY_MEM
128000
|
DS_NONPDQ_QUERY_MEM
128
|
DS_NONPDQ_QUERY_MEM
5000
|
DS_NONPDQ_QUERY_MEM
4096
|
OPTCOMPIND
0
|
OPTCOMPIND
2
|
OPTCOMPIND
2
|
OPTCOMPIND
0
|
OPTCOMPIND
0
|
BUFFERPOOL
default,buffers=800000,lrus=254,lru_min_dirty=80.000000,lru_max_dirty=90.500000
|
BUFFERPOOL
default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
|
BUFFERPOOL
default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
|
#BUFFERPOOL
default,buffers=450000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
|
BUFFERPOOL
default,buffers=10000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
|
#BUFFERPOOL
size=2K,buffers=1000000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
|
BUFFERPOOL
size=2K,buffers=750000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
|
BUFFERPOOL
size=2K,buffers=200000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
|
BUFFERPOOL
size=2K,buffers=850000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
|
BUFFERPOOL
size=2K,buffers=500000,lrus=127,lru_min_dirty=70.000000,lru_max_dirty=75.000000
|
|
|
BUFFERPOOL
size=16K,buffers=25000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
|
|
|
AUTO_LRU_TUNING
0
|
AUTO_LRU_TUNING
1
|
AUTO_LRU_TUNING
1
|
AUTO_LRU_TUNING
0
|
AUTO_LRU_TUNING
1
|
|
 |
