December 14, 1999 12:37 PM
(in response to Jim Knisley)
I want to have the latest information and need multiple releases
so I download the PDF files from the DB2 web. That way, I have the
in the diagnosis information.
I just noted the latest white paper on DB2 performance for the
Storage Server (a.k.a. Shark).
From the DB2 for OS/390 home page,
Click on Library, then on
DB2 for OS/390 Performance on IBM Enterprise Storage Server
for a 25 page paper discussing our benchmarking on the new disk
Here are some highlights, extracted from an earlier flash.
New measurements from IBM's Santa Teresa Laboratory now confirm
Enterprise Storage Server is a truly outstanding choice for
applications using DB2 UDB for OS/390. In particular, these results
that S/390 and the Enterprise Storage Server are the ideal
data warehouse and Business Intelligence applications.
The Enterprise Storage Server supports a Query Single Stream rate
approximately 11.5 MB/sec, about double the previous best
This data rate is significant for improving the elapsed time of
applications that must scan large amounts of data, for example
DB2 parallelism is multiplied by the device speeds and Parallel
Volumes (PAV). An ESS has already been measured at 155 MB/sec
throughput for DB2. To put this into perspective, it took
3990 controllers to achieve a total data rate of 270 MB/sec running
massive Teraplex query in 1997. This could be achieved today with
PAV also enables multiple partitions to be stored on the same
negligible performance degradation. The ESS showed almost no
when a parallel query scanned one, two or three partitions
on the same volume. (RAMAC 3 degraded up to 300% in this test).
the ESS is so much less sensitive to data placement, management of
sets for DB2 is very much easier.
Elapsed times for DB2 utilities (such as Load and Copy) show a
improvements from 40%-50% on the ESS compared to the RVA X82.