Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    6

    Unanswered: DB2 tablespace configuration question

    Hi,

    Have a question on DB2 configuration. We are trying to configure a 500GB db2 database accross 6 RAID-groups of disks, and we think to use SMS for all tablespaces and stripe them to 6 disks. We know SMS will have data, index, long objects all mixed together, but since we do striping, it will not make much difference(?). The question is, what's the pros and cons for using SMS or DMS for user objects in configuring a new DB?

    Thanks in advance!

  2. #2
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    35
    Take a look at the DB2 docs such as :

    http://www-3.ibm.com/cgi-bin/db2www/...htm#HDRTSDESGN

    It is for V7 but you can find similar doc for V8.

    HTH,

    Dany

Posting Permissions

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