Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Location
    Ukraine
    Posts
    24

    Unanswered: Placing large tables into dedicated tablespace

    Hello Everyone,

    I have about 1500 tables in my DB, 3 of them are significantly larger than the others and the most activity is performed on them. Is that a good idea to create dedicated tablespaces for each of them for performance reasons?

    Deployment: DB 10.1.0.2 Purescale on RHEL 6.3.

    BR,
    Roman

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It might be a good idea to do that in order to improve backup and restore performance, since DB2 can better parallelize those activities if the tables are different tablespaces. Also, you have more flexibility in terms of specifying bufferpools in case you need to put them in different bufferpools. It might have a very small benefit in terms of page cleaners if you have them in separate bufferpools. Since there are only 3 of these very large tables, it would not hurt anything to put them in there own tablespaces, so long as the number of tablespaces does not get out of hand.
    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
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by xat View Post
    Is that a good idea to create dedicated tablespaces for each of them for performance reasons?
    What is your current performance bottleneck? If it's the bufferpool efficiency, then, as Marcus said, it might make sense to isolate large tables into a separate bufferpool (or bufferpools), for which you need to move them to a separate tablespace (tablespaces). Otherwise you'll just waste your time.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Dec 2012
    Location
    Ukraine
    Posts
    24
    Thanks for comments guys

Posting Permissions

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