It seems I may have introduced a bottleneck on my server by switching to
"mirrorwrite db parrallel" and addig dbpageshadow. The default
dbpageshadow file goes in with /usr/tivoli/tsm/server/bin, which is on
my root vg (AIX server, 4.3.3 ML08). It is mirrored SCSI disks. I
noticed last night that hdisk0 and hdisk1 are getting hammered, with
little or no paging. The manual seems unclear whether I can specify a
path before the filename or not. Also, I am unsure whether the file is
needed in a disaster recovery scenario, when I have to restore my
database. My gut says no, but I am not sure. Any ideas? What are
other people doing? Thanks.
Andy Carlson |\ _,,,---,,_
andyc AT andyc.carenet DOT org ZZZzz /,`.-'`' -. ;-;;,_
BJC Health System |,4- ) )-,_. ,\ ( `'-'
St. Louis, Missouri '---''(_/--' `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html
|