469,962 Members | 2,184 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,962 developers. It's quick & easy.

Designing tablespaces with a SAN in mind

Hi,

we've recently changed our db2 server from using a single RAID array to
a SAN. (machine is running 8.2.4 UDB on SLES 9, 2.6 kernel, 32 bit
Intel)

If we'd been using a RAID array, then we'd be tuning prefetch size
according to the number of discs and the stripe size. From what I
understand of the SAN configuration, there's an abstraction layer
between the physical storage and what gets presented to the machines
attached to it; eg there might be 50 discs in the SAN, but to the end
application it looks like either 1 disc, or 2 discs, or (potentially) a
RAID5 array with 6 discs, or any other permutation you care to think
of.

With that in mind, how should we be tuning the tablespace parameters?
Anyone have any pointers to useful documentation on this?

Thanks

JCSJF

Jun 28 '06 #1
1 1209
Ian
James Conrad StJohn Foreman wrote:
With that in mind, how should we be tuning the tablespace parameters?
Anyone have any pointers to useful documentation on this?


SANs should be no different than locally attached RAID arrays -- the
SAN just provides the connection between the host and storage array.
The fact that the storage array is typically HUGE, and may have a lot
of cache in front of it is just a detail.

Keep in mind that (no matter what the storage admins say), you should
have some understanding of how the storage is handled inside of the
storage device. i.e. are the LUNs presented to your system (which
appear as a single disk drive to the operating system) built on
5+P RAID5, 8+P RAID5, RAID-1 arrays, etc? What is the stripe size?
Are you getting more than 1 LUN from a single RAID array?

All of these things should play in to how you define your storage,
including extent size, prefetch size, NUM_IOSERVERS, DB2_PARALLEL_IO,
etc.

Most SAN vendors can provide best-practice white papers for using
their devices with DB2 (at least IBM, Hitachi, EMC and NetApp do.
Not sure about Compaq).
Jun 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CK | last post: by
8 posts views Thread by Joachim Mueller | last post: by
10 posts views Thread by rAinDeEr | last post: by
3 posts views Thread by dcruncher4 | last post: by
8 posts views Thread by alexhguerra | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.