IBM Support

Verified network-attached storage systems for use with DB2 Universal Database Version 8.x, DB2 9.x, DB2 10.x

Question & Answer


Question

DB2 Universal Database Version 8.x, DB2 9.x and DB2 10.x do not generally support the creation of databases and table space containers on network-attached storage subsystems [remote resources]. There are, however, a number of storage systems that IBM has validated for use as remote resources on the CREATE DATABASE and CREATE TABLESPACE statements.

Answer

Following is the list of all storage systems that have been validated and are supported for use with DB2 UDB Version 8.x, DB2 9.x and DB2 10.x:


Product*
Protocol**
Operating System of the DB2 Server***
AIX 5.3 (usage of the DIO mount option is optional)
NFS v3 and v4
AIX
EMC Celerra CNS, NS Series/Gateway, and NS Series/Integrated with NAS (software version) 5.3.13.2 or later, and DB2 v8.1.3 or later NFS v3AIX, HP-UX, Solaris
EMC CLARiiON CX300/CX500/CX700 with PowerPath 3.0.4 and DB2 UDB v8.1.3 or later NFS v3AIX, HP-UX, Solaris
EMC CLARiiON CX Series with PowerPath 4.3.1 and DB2 UDB v8.2 or later NFS v3RedHat Enterprise Linux V3 Update 4
EMC CLARiiON CX Series with PowerPath 4.3.1 and DB2 UDB v8.2 or later FCP MS Windows Server 2003 V5.2
IBM GPFS v2.1 with PTF for APAR IY34917, and DB2 v8.1.2 or later GPFSAIX 5.2.0.0 with RSCT 2.3.2.0
IBM GPFS v3.2.0.2 with DB2 9.5 GPFSAIX 5.3 TL7 with RSCT 2.4.9.0
IBM GPFS 3.2 PTF 12 with DB2 9.5 fp1 GPFSLinux SLES 10 SP2
IBM N-series with Data ONTAP 7.x, 8.x FCPAIX, HP-UX, Linux, Solaris, Windows
IBM N-series with Data ONTAP 7.x, 8.x iSCSIAIX, HP-UX, Linux, Solaris, Windows
IBM N-series with Data ONTAP 7.x, 8.x NFS v3AIX, HP-UX, Linux, Solaris
IBM N-series with Data ONTAP 7.x, 8.x NFS v4AIX, Linux
IBM TotalStorage IP Storage 100i & 200iiSCSILinux, Windows
IBM TotalStorage NAS 200 & 300 seriesNFS v3Linux
IBM TotalStorage NAS 200 & 300 seriesCIFSWindows
IBM TotalStorage NAS Gateway 500
minimum version for FastConnect : 3.2.0.2
NFS v3 Linux
IBM TotalStorage NAS Gateway 500
minimum version for FastConnect : 3.2.0.2
CIFS Windows
IBM TotalStorage SAN File System R1.1 N/AAIX 5.1 (32-bit), Windows 2000 Advanced Server
IBM TotalStorage SAN File System R2.1 N/AAIX 5.1 (32-bit), AIX 5.2, Linux (Redhat Enterprise Linux AS 3, x86), Solaris 9 (64-bit), Windows 2000 Advanced Server
IBM TotalStorage SAN File System R2.2 N/AAIX 5.1 (32-bit), AIX 5.2, AIX 5.3, Linux (Redhat Enterprise Linux AS 3, x86; SuSE Linux Enterprise Server 8, x86), Solaris 9 (64-bit), Windows 2000 Advanced Server, Windows 2003 Enterprise Server (See '9324.note' in SAN FS 2.2 release notes)
Network Appliance Filers with Data ONTAP 6.x, 7.x and 8.xFCPAIX, HP-UX, Linux, Solaris, Windows
Network Appliance Filers with Data ONTAP 6.x, 7.x, and 8.xiSCSIAIX, HP-UX, Linux, Windows
Network Appliance Filers with Data ONTAP 7.x, and 8.x iSCSISolaris
Network Appliance Filers with Data ONTAP 6.x , 7.x and 8.xNFS v3AIX, HP-UX, Linux, Solaris
Network Appliance Filers with Data ONTAP 7.x and 8.x NFS v4AIX, Linux
Network Appliance Filers with Data ONTAP 6.x CIFSWindows 2000
Network Appliance Filers with Data ONTAP 6.xDAFSSolaris
NEC iStorage S2100, S2200, S4100iSCSIAIX, HP-UX, Linux, Solaris, Windows
NEC iStorage NS Series (NS430, NS440) NFS v3 Linux
NEC iStorage NS Series (NS430, NS440)CIFSWindows
NEC iStorage NS Series (NS42P,NS22P)CIFSWindows
NEC iStorage NV Series(NV7200S, NV7200, NV8210, NV8220)CIFSWindows

* The use of either non-volatile RAM or a UPS is required for all storage systems. Some storage systems come with non-volatile RAM. Contact your vendor for details. Contact the vendor for details on the availability of specific storage system models.
** When the protocol used is NFS, the hard and nointr mount options should be used.
When using NFS, to reduce the possibility of a partial page write it is highly recommended that the wsize mount option be set to equal or larger than the biggest DB2 tablespace pagesize. For example, if the largest page size among your table spaces is 16 K, set wsize to at least 16 K.
When using NFS v3, if an NFS client which functions as a db2 server comes down, the locks held by the dead NFS client will need to be released. This can generally be done by either restarting the NFS client, restarting NFS on the NFS server, or explicitly releasing the clients locks at the NFS server.
*** See the DB2 documentation for details on OS versions/levels supported by DB2, and the storage vendor's documentation for details on OS versions/levels supported by the storage system.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tablespaces","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7;9.5;9.1;8.2;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21169938