BrocAde Host Bus AdApter tecHnology leAdersHip

triparkansasData Management

Oct 31, 2013 (4 years and 10 days ago)


At A glAnce
Host Bus AdApter
iBM offers a broad information
Management software line. dB2 is one of
iBM’s relational database Management
system (rdBMs) software products—with
industry-leading performance on distributed
systems, offering unparalleled efficiencies
for staffing and storage.
Fibre channel (Fc) Host Bus
Adapters (HBAs) offer:
the best performance at lower power and

cost for both sequential and random i/o
The ability to prioritize and isolate traffic

and minimize the effects of congestion in
storage Area networks
the lowest latency for host-to-storage

reduced server downtime with hot-

swappable optics and tightly coupled os
driver and firmware
Unified SAN and HBA management and

Leveraging Brocade Host Bus
Adapters with IBM DB2
it organizations must contain costs, yet
business demands must still be met.
the mandate is to “do more with less.”
even when businesses are not growing,
databases continue to expand and costs
for database software, storage systems,
and servers to support them continue to
increase. At the same time, demand for
information now extends beyond specialist
communities to include mass populations

of internal users, customers, and partners.
CHaLLenGeS Today
the top challenges today are not only to
reduce costs, but also to improve work
processes and employee efficiency and
better utilize and analyze information.
A Forrester report dated december
2008 states that it spend about 68% for
Maintenance, operations and ongoing
support of systems and equipment
(Moose) and only 32% for new projects.
today, many cios mandate a centralized
infrastructure based on standards.
in a world with networked and highly
virtualized storage, database storage
design can appear to be a dauntingly task.
poor database storage design can have a
significant negative impact on a database
server. cpus are so much faster than
physical disks that it is not uncommon to
find poorly performing database servers
significantly I/O bound and underperforming
by many times their true potential.
simplicity is the key to good database
storage design. And an adequate number
of physical disks must be deployed to keep
the system from becoming i/o bound.
important for good design is a fundamental
understanding of the dB2 environment,
instances, and databases. The first order
of business for database rollout is the
underlying configuration of storage.
databases make many small frequent reads
and writes, and the capability of storage to
keep up with i/o governs the performance
of databases. databases perform two
types of operations: read data from a
transactional database file and write data
to a log. Because of the separate nature of
these operations, it is always advantageous
to split them across separate arrays. the
same caveats about rAid types apply
when splitting the reads and writes across
separate arrays, and you must match your
i/o to the appropriate rAid type for both the
data and log luns or volumes.
dB2 PeRFoRManCe
DB2 was specifically designed to operate
in the most efficient manner possible in
all facets of the dB2 database engine.
As a result, dB2 enjoys a strong record in
database benchmarks.
At A glAnce
© 2010 Brocade communications systems, inc. All rights reserved. 04/10 gA-Ag-271-00
Brocade, the B-wing symbol, Bigiron, dcX, Fabric os, Fastiron, ironView, netiron, sAn Health, serveriron, and turboiron
are registered trademarks, and Brocade Assurance, dcFM, extraordinary networks, and Brocade net Health are
trademarks of Brocade communications systems, inc., in the united states and/or in other countries. other brands,
products, or service names mentioned are or may be trademarks or service marks of their respective owners.
notice: this document is for informational purposes only and does not set forth any warranty, expressed or implied,
concerning any equipment, equipment feature, or service offered or to be offered by Brocade. Brocade reserves the
right to make changes to this document at any time, without notice, and assumes no responsibility for its use. this
informational document describes features that may not be currently available. Contact a Brocade sales office for
information on feature and product availability. export of technical data contained in this document may require an
export license from the united states government.
Corporate Headquarters

san Jose, cA usA
t: +1-408-333-8000
european Headquarters

geneva, switzerland
t: +41-22-799-56-40
Asia Pacific Headquarters

t: +65-6538-4700
As of August 2009, dB2 holds the leading
performance benchmark result for
numerous benchmarks including tpc-c
(transactional workloads), tpc-H 10tB
(analytical workloads), and sAp sd 3-tier
(application workloads). it is this ability
to simultaneously lead the performance
benchmarks for diverse workloads that sets
dB2 apart from the competition.
I/O Profile.
to achieve these goals requires
not only dB2 industry-leading performance
across mixed workloads but also excellent
i/o-performance. if raw i/o in dB2 is
planned, only one device over multiple disks
(striping) at the operating system level is
allowed. dB2 will usually attempt to write
in 4 KB pages. Also the tpc-c benchmarks
mentioned above typically use 8 blocks at
512 Bytes. large database query tests were
run at 1, 64, and 256 KB transfer sizes.
the type of storage array required
to handle i/o is the same regardless
of whether or not the environment is
virtualized. For storage Area networks
(sAns), satisfying i/o requirements is
a matter of provisioning luns (storage)
with the correct rAid levels, and the
same wisdom applies to local storage
configurations. RAID 5 is not a good choice
for databases, especially for log files, as the
parity calculations involved in spanning the
data across the disks dramatically slows
down write times.
rAid 1 is a better performer in this arena,
but it’s still not ideal. you can get away
with proprietary rAid 6, but make sure
that the storage controller offloads the
parity calculations to a separate storage
processor. Among traditional rAid types,
RAID 10 is definitely the best choice. RAID
10 has excellent read and write times,
and it doesn’t slow appreciably for storage
calculations. A number of proprietary rAid
variations are good, as are other nested
RAID configurations such as RAID 15, 51,
05, and 50. All of these high-end nested
RAID configurations have good read and
write performance and are suitable for
databases, but they are fairly expensive.
BRoCade advanTaGeS
I/O Performance.
there are differences
in the way sequential i/o performance
is measured and the way random i/o is
measured. For sequential i/o performance,
throughput is measured in megabytes per
second, whereas random i/o performance
is measured as the number of iops. in all
cases, latency is the key factor.
Brocade HBAs offer up to 500K iops
per port, demonstrating best-in-class
performance. numbers are published in
the iBM white paper titled, “enabling 8gbps
Fibre channel end-to-end performance”
). Based on testing in a real-world
environment, the numbers demonstrated
world-beating throughput at 4 and 8 KB
transfer sizes, as shown in the graph below.
in addition, tolly states that Brocade HBAs
have the lowest latency, “in these tests,
Brocade consistently delivered the lowest
latency across the entire range ....” (tolly
report document # 209102, April 2008)
Ensuring Service Levels.
customers configure multiple smaller
oltp databases that support different
business units, such as order entry, human
resources, and accounting. these different
databases have vastly different i/o patterns
and also service level Agreements (slAs),
though all share the same storage, sAn,
and possibly server resources via use
of server virtualization technology. only
Brocade HBAs can isolate and prioritize
individual database and transaction log
i/o streams, maintaining Quality of service
priorities from server to storage by using
Brocade’s server Application optimization
(sAo) and Adaptive networking (An).
Highest Levels of Availability.
such as hot-swappable optics allow most
HBA hardware problems to be corrected
without taking the server offline or
adversely impacting the sAn or storage
configurations. Brocade provides a single
driver and firmware package tightly coupled
to eliminate version incompatibility issues
and allow user-friendly installation with
the host os. these features minimize it
operational risk and lead to the highest
levels of availability and stability.
True Unified Management.
Brocade HBAs
leverage the same hardware platforms
as Brocade Fc switches and directors to
enable end-to-end monitoring and reporting
capabilities unique to Brocade. this
unified solution provides local and remote
management through a native element
manager, Brocade Host connectivity
Manager (HcM), and a cli, which enables
users to configure and monitor HBAs. In
addition, Brocade dcFM
provides a unified
view from the fabric into the host and target
across Brocade fabrics. server and sAn
management from a single “pane of glass”
enables unparalleled ease of use and
To find out more about Brocade HBAs and
third-party performance reports, visit www.
4 KB 8 KB
Brand A
Brand B