Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: solving filesystem full problem with tablespaces using SMS containers

    We have several large tablespaces on our production DB2 database that use SMS containers. After research we found out that the containers are on a filesystem (AIX) that is not enabled for large files >2Gb. How can I migrate these tablespaces that are out of space (SQL -0968C error) to a new filesystem that is enabled for large file sizes? Thanks !

    Scott

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: solving filesystem full problem with tablespaces using SMS containers

    If you are atleast on DB2 V7 FP7 , you can use the db2relocatedb command ...

    http://www-3.ibm.com/software/data/d...7/db2ir126.htm

    Cheers

    Sathyaram


    Originally posted by mixxalot
    We have several large tablespaces on our production DB2 database that use SMS containers. After research we found out that the containers are on a filesystem (AIX) that is not enabled for large files >2Gb. How can I migrate these tablespaces that are out of space (SQL -0968C error) to a new filesystem that is enabled for large file sizes? Thanks !

    Scott
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Posts
    369

    redirected restore for full tablespaces?

    Can we do a redirected restore from DB2 7.2 to recreate the tablespaces and migrate them to a new filesystem that has large file size enabled? We have fixpack 6 installed on our production DB2 system so I cannot run the command you recommended.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: redirected restore for full tablespaces?

    Scott

    I'm sorry ... The fixpack was available even earlier to FP7 , FP4 ...

    I missed ...

    Cheers

    Sathyaram

    Originally posted by mixxalot
    Can we do a redirected restore from DB2 7.2 to recreate the tablespaces and migrate them to a new filesystem that has large file size enabled? We have fixpack 6 installed on our production DB2 system so I cannot run the command you recommended.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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