DB2 on Sun OpenStorage Blueprint

My new article - "Deploying DB2 Database on the Sun Storage 7000 Unified Storage System" has been published as a Sun Blueprint.

You can also go to the wiki page to comment and rate it.

Here is the brief introduction.

For DB2 applications, Sun Storage 7000 Unified Storage Systems meet a range of functional requirements for availability, capacity, and performance. This Sun BluePrints™ article describes the steps needed to configure and install a DB2 database in a Sun Storage 7000 Unified Storage System environment. The article addresses the following topics:

• Preparing a Sun Storage 7000 Unified Storage System for DB2 database storage
• Preparing a server running the Solaris™ Operating System (Solaris OS) to use NFS file systems or Internet SCSI (iSCSI) logical unit numbers (LUNs)
• Installing the DB2 software on the server and creating a database on the storage system
• Separating database transaction log files from data files and storing them on the storage system
• Taking a snapshot of an online DB2 database and recovering from the snapshot

Comments:

Hello Cherry,

I'm in the process of setting up a largeish db2 install on a 7410 and it is exciting to see your paper. Thank you. But I have a question re. the 7000's configuration. In table 2 on page five it seems that the array in use is the 7210 model. The storage layout selected appears to be the raidz2 with wide stripes profile. In my experience and reading on Roch's[1] & Brendan's[2] blogs and some opensolaris.org forum postings from Jeff Bonwick[3], raidz is the worst case profile for a random read workload.

I've also seen that the current version of iscsi isn't as fast as nfs.

I'm afraid I'm missing something and wonder if you could speak to why you chose iscsi and a large raidz profile?

[1] http://blogs.sun.com/roch/entry/when_to_and_not_to
[2] http://blogs.sun.com/brendan/entry/l2arc_screenshots (subsection entitled "IOPS increased by 40x!")
[3] http://osdir.com/ml/os.solaris.opensolaris.zfs/2006-06/msg00006.html

Posted by Kurt Olsen on March 26, 2009 at 05:35 AM EDT #

Hi Kurt, the paper is focused on how to use nfs and iscsi deployment. Performance between nfs and iscsi is out of the scope. Need to mention that the iscsi performance is a fast moving target.

Posted by Cherry Shu on March 31, 2009 at 07:05 AM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

This is a blog to talk about technical information regarding running IBM DB2 database on Solaris.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today