different striped file with file about container type

[Former Member]

All,

I found our system some containers type is striped file,but containers type is file,I want to know what different they have.whether concern system performance,thanks.

Best Regards,

Bill

[former_member640873]

Hi Jun Wei

By having striped filesystem in the same stripe set for a DMS container, data are written across different container in the unit of extents. For example, if a table space has 3 containers (that resides in different disk(s)) that belongs to the same set (stripe set).

1st extent, 4th extent, 7th extent.. -> container 1

2nd extent, 5th extent, 8th extent... -> container 2

3rd extent, 6th extent, 9th extent... -> container 3

When sequential prefetching happens, 3 extents can be fetched in one "scoop" in parallel.

For more information, refer to IBM Info Center:

[http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0008087.htm]

I hope it helps. Please let me know if you have any furthur question.

Regards,