Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Questions on LUNs, containers and DB2_PARALLEL_IO

In my research on storage configuration (DB2 v9.1 on AIX 5.3) I am getting conflicting advice. Therefore, let me throw out a couple of questions for comment.

1) When using a virtualized SAN storage system (ie. Hitachi 9990V) is using one large LUN (spread over lots of disk) for sapdata as good as using several LUNs (spread over the same number of disks)? Why or why not?

2) Is using one container per tablespace with DB2_PARALLEL_IO properly set as good as using several containers per tablespace?

My goal is maximum performance, but I would like the simplicity of fewer LUNs and containers to manage.

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question