Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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: