Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2008
    Posts
    136

    Unanswered: file system is about to reach at max

    Hi,



    OS : AIX 32 Bit

    DB2 V8.2 Single Partition

    All SMS Tablespace



    As AIX 32 bit support maximum 1 TB for one file system and now file system is about to reach 1TB?

    so what should I do??

    we can not add container in sms tablespace...



    Please suggest approch?



    Regards

    Pawan Kumar
    Regards
    Pawan Kumar

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Do you have only one tablespace?

    Andy

  3. #3
    Join Date
    Mar 2008
    Posts
    136
    no more than one tablespace but all are SMS
    Regards
    Pawan Kumar

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look here:

    DB2 Universal Database

    Andy

  5. #5
    Join Date
    Mar 2008
    Posts
    136
    but for this need a long down time?
    Regards
    Pawan Kumar

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Your only solution is to move some of the data to another file system. The quickest way I know is the db2relocatedb command. To use it you will have to do the following:

    1) kick out the users and quiesce the instance (this will prevent anyone getting in while you perform the maintenance)
    2) copy some of the tablespaces to a new file system. The amount of time this takes determines how long you will be down.
    3) run the db2relocatedb command.
    4) connect to the database and query some of the data you moved.
    5) if all is working well, delete the tablespaces you copied from
    6) unquiesce the instance and let users back in.

    Before you start any of this you should determine which tablespaces you want to move and where. Then you setup the db2relocatedb config file.

    Andy

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    My crystal ball telling me it will be longer if you do not do anything.

    You can ask your admin to add more path/drives. Create new tbs on them and start moving your table to a new location. I am amazed that you only have one path for 1tb size db.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Mar 2008
    Posts
    136
    what about redirect of tablespaces?
    Regards
    Pawan Kumar

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    will need much longer to restore, than using relocatedb.

    one option you can use if you have enough disk space is to rediected restore the db, shut down the original db, ship logs to the new db and roll forward to end of logs and rename the new db to old db using relocatedb.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  10. #10
    Join Date
    Mar 2008
    Posts
    136
    thanks to all... I try to do.
    Regards
    Pawan Kumar

Posting Permissions

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