Latest I heard is that IBM DB2 guys are recommending using fileystems as opposed to devices due to higher management cost and also the fact that recent technological advances have made filesystems performance par with devices...any comment/input?

DB2 UDB V8 on AIX.

Thanks.

This is generally true.

But it also depends on what type of database you have (OLTP vs. Data Warehouse), and what type of disk you have (JBOD internal, RAID-5, SAN, NAS, etc.

Unless you do a lot of table scans (typical in data warehouse databases) you are unlikely to see any difference, especially if you have a lot of memory allocated to your bufferpools.

Even with table scans, if you have SAN or NAS disk, you are unlikely to see any difference.

System temporary tablespaces should always use SMS because DB2 can create temporary tables much faster on SMS than on DMS. When creating tables on DMS, DB2 spends more time looking for the optimum contiguous space to place the table.

Some food for thought: http://www3.software.ibm.com/ibmdl/p...IO-article.pdf