Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: adding sms space on aix

    We have a JFS filesystem on AIX that has reached its defined limit (64GB) and i was wondering what would be the best option, here is what our AIX admin laid out for us:

    Option 1. Create a new filesystem (either JFS or JFS2) of another SMS container and make DB2 to use new one as a expansion.

    Option 2. Create a JFS2 filesystem and migrate all data over to new one.

    Option 3. Create a new JFS filesystem with larger nbpi parameter and migrate all data.


    Option 2&3 are easy based on my knowledge of DB2 and the amount I work on it but option 1 seems like a good option but I am not sure how to go about it.

    If anyone has any ideas or suggestions that would be great

    Mark

    DB2 8.1 on AIX 5.2

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would do option 1 (add a new container to the existing tablespace). See the SQL Reference for ALTER TABLESPACE.
    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
    I'm not sure you can actually add containers to an SMS tablespace, except when creating a new database partition. You would have to do a redirected restore.

Posting Permissions

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