Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2007
    Posts
    30

    Unanswered: tablespace containers

    Hi guys
    i have an SMS table space with 14 containers on it.and all these containers are on the same disk. because of this there are some performance issues. there is I/o contention goin on.so can i decrease the 14 containers to 1 container using the redirected restore.
    the database is on DB2V8.2 fp5 --solaris.
    any help would be appreciated.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    This is not something I have done, but in looking at the redirected restore commands, it should be possible. I would recommend that you try it on a test system before you do a production system.

    Andy

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    Where is the I/O contention? On disk controller? Changing to 1 container, i do not think, will improve much. Sometimes having DMS containers will help.
    mota

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    Where is the I/O contention? On disk controller? Changing to 1 container, i do not think, will improve much. Sometimes having DMS containers will help.
    mota

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Redirected restore will do what you want, assuming that all containers really belong to the same table space.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jan 2008
    Posts
    88
    just an idea...try to create 2 containers DMS

Posting Permissions

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