Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    4

    Unanswered: Changing a tablespace's bufferpool

    I'm running DB2 9.5 on AIX

    I would like to know if there is an easier way to remove a bufferpool form a tablespace without having to drop it and re-create it.

    Simon G.

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi Simon,

    you can do it with alter tablespace ...
    The Database needs to be deactivated/activated.

    Cheers,
    nvk

Posting Permissions

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