Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    14

    Unanswered: Reallocating tablespace

    Hi,

    Get 2 table space,
    one for contents "Any data" (11 containers of 1 GB each) and
    second for contents "Long data only" (9 containers of 1GB each)

    Tables have been created and data already loaded in each of the tablespaces.

    In DB2, is it possible to reallocate some of the space from the first to the second tablespace at this stage.

    Thanks in advance.
    M2001

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Reallocating tablespace

    In db2 version 7.x, no, in version 8.x yes, You could do a backup and restore to a smaller/larger tablespaces, the other option is to do a export of the data and drop the tablespace and re-create it.



    Originally posted by M2001
    Hi,

    Get 2 table space,
    one for contents "Any data" (11 containers of 1 GB each) and
    second for contents "Long data only" (9 containers of 1GB each)

    Tables have been created and data already loaded in each of the tablespaces.

    In DB2, is it possible to reallocate some of the space from the first to the second tablespace at this stage.

    Thanks in advance.

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

    Re: Reallocating tablespace

    You can do a redirected Restore of the tablespace(s) ...

    But make sure, before you do anything you have the data safe in a full offline backup of the database ...

    Cheers

    Sathyaram

    Originally posted by M2001
    Hi,

    Get 2 table space,
    one for contents "Any data" (11 containers of 1 GB each) and
    second for contents "Long data only" (9 containers of 1GB each)

    Tables have been created and data already loaded in each of the tablespaces.

    In DB2, is it possible to reallocate some of the space from the first to the second tablespace at this stage.

    Thanks in advance.

Posting Permissions

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