Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
pais:db2dpf2nodes [2016/08/04 18:52] master |
pais:db2dpf2nodes [2016/08/05 11:51] (current) master [I/O Consideration] |
||
|---|---|---|---|
| Line 276: | Line 276: | ||
| ''numactl –hardware'' | ''numactl –hardware'' | ||
| - | ===== IO Consideration ===== | + | ===== I/O Consideration ===== |
| DB2 doc: "Optimizing table space performance when data is on RAID devices" | DB2 doc: "Optimizing table space performance when data is on RAID devices" | ||
| Line 286: | Line 286: | ||
| Chunk size is also "segment size of disk". | Chunk size is also "segment size of disk". | ||
| - | RAID5 chunk size: 64K | + | * RAID5 chunk size: 64K |
| - | + | * Disk segment size: 64K | |
| - | Disk segment size: 64K | + | * RAID5 Strip size: 320K |
| - | + | ||
| - | RAID5 Strip size: 320K | + | |
| The DB2 extent size for a tablespace is the amount of data that the database manager writes to a container before writing to the next container. | The DB2 extent size for a tablespace is the amount of data that the database manager writes to a container before writing to the next container. | ||
| Line 296: | Line 294: | ||
| The extent size should be a multiple of the underlying segment size of the disks. Also a multiply of the page size. | The extent size should be a multiple of the underlying segment size of the disks. Also a multiply of the page size. | ||
| - | Page size (large table): 32KB | + | * Page size (large table): 32KB |
| - | + | * Extent size = 320K x N | |
| - | Extent size = 320K x N | + | * Prefetch size = 320K x N |
| - | + | ||
| - | Prefetch size = 320K x N | + | |
| Check raid level: | Check raid level: | ||
