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

    Unanswered: redirected restore and renaming tablespaces

    Hi,

    DB2 Version 9.5.0.2a running on AIX Version 5.3

    I am performing a redirected restore using the redirect generate script option and I'm able to change the tablespace container names in the script, but is there also a way to change the tablespaces names.

    Regards,
    Simon Grzebieta

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Not that I am aware of. Containers don't actually have names (at least not ones that we see externally), they just have a file, path, or device specification. If you couldn't change these, then there would be no such thing as a redirected restore since that is what you are redirecting.
    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
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    You can change the tablespace name using the rename tablespace statements

Posting Permissions

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