Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Location
    USA
    Posts
    53

    Unanswered: multiple containers on one physical disk

    Is there any benefit in creating multiple containers on one physical disk?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Good question. It depends on a number of things, including the throughput of the disk controller(s) on your server, and the performance characteristics of your disk array (cache, etc).

    Very few people would only have one disk (spindle) since some sort of RAID is pretty much standard these days. A single mount point might be spread over multiple spindles without you knowing about it. For example, a sophisticated SAN product with cache, and fiber channel host disk adapters on your server probably would benefit from multiple containers if you were doing huge amounts of I/O.

    But if you really did have only one spindle, then probably no benefit. If you have an OLTP system with high bufferpool hit ratios, the it even makes less of a difference.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2009
    Posts
    114
    Quote Originally Posted by db2aix
    Is there any benefit in creating multiple containers on one physical disk?

    multiple containers of the same tablespace? probably not
    Last edited by db2dummy1; 10-24-09 at 22:50.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •