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 v3 | AIX, HP-UX, Solaris |
EMC CLARiiON CX300/CX500/CX700 with PowerPath 3.0.4 and DB2 UDB v8.1.3 or later | NFS v3 | AIX, HP-UX, Solaris |
EMC CLARiiON CX Series with PowerPath 4.3.1 and DB2 UDB v8.2 or later | NFS v3 | RedHat 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 | GPFS | AIX 5.2.0.0 with RSCT 2.3.2.0 |
IBM GPFS v3.2.0.2 with DB2 9.5 | GPFS | AIX 5.3 TL7 with RSCT 2.4.9.0 |
IBM GPFS 3.2 PTF 12 with DB2 9.5 fp1 | GPFS | Linux SLES 10 SP2 |
IBM N-series with Data ONTAP 7.x, 8.x | FCP | AIX, HP-UX, Linux, Solaris, Windows |
IBM N-series with Data ONTAP 7.x, 8.x | iSCSI | AIX, HP-UX, Linux, Solaris, Windows |
IBM N-series with Data ONTAP 7.x, 8.x | NFS v3 | AIX, HP-UX, Linux, Solaris |
IBM N-series with Data ONTAP 7.x, 8.x | NFS v4 | AIX, Linux |
IBM TotalStorage IP Storage 100i & 200i | iSCSI | Linux, Windows |
IBM TotalStorage NAS 200 & 300 series | NFS v3 | Linux |
IBM TotalStorage NAS 200 & 300 series | CIFS | Windows |
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/A | AIX 5.1 (32-bit), Windows 2000 Advanced Server |
IBM TotalStorage SAN File System R2.1 | N/A | AIX 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/A | AIX 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.x | FCP | AIX, HP-UX, Linux, Solaris, Windows |
Network Appliance Filers with Data ONTAP 6.x, 7.x, and 8.x | iSCSI | AIX, HP-UX, Linux, Windows |
Network Appliance Filers with Data ONTAP 7.x, and 8.x | iSCSI | Solaris |
Network Appliance Filers with Data ONTAP 6.x , 7.x and 8.x | NFS v3 | AIX, HP-UX, Linux, Solaris |
Network Appliance Filers with Data ONTAP 7.x and 8.x | NFS v4 | AIX, Linux |
Network Appliance Filers with Data ONTAP 6.x | CIFS | Windows 2000 |
Network Appliance Filers with Data ONTAP 6.x | DAFS | Solaris |
NEC iStorage S2100, S2200, S4100 | iSCSI | AIX, HP-UX, Linux, Solaris, Windows |
NEC iStorage NS Series (NS430, NS440) | NFS v3 | Linux |
NEC iStorage NS Series (NS430, NS440) | CIFS | Windows |
NEC iStorage NS Series (NS42P,NS22P) | CIFS | Windows |
NEC iStorage NV Series(NV7200S, NV7200, NV8210, NV8220) | CIFS | Windows |
* 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"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21169938