Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004

    Unanswered: how do I restore this database with different pagesize table spaces.?

    I have a database mostly with tablespaces of regular size of 4K but I have 2 tables using the tablespaces of size 8k and 16k.

    Now I am trying to restore the database from a backup on to a different machine using the command restore ....

    I get the error 'SQL0298N Bad container path. SQLSTATE=428B2'.

    Can anyone suggest how do I go about restoring this database?

  2. #2
    Join Date
    May 2003
    Page size must be the same for the restore. You will have to move the tables to a new tablespace after the restore with the desired page size.
    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
    Nov 2005
    Are you specifying a new path for your containers? If no, then unless you have the same file structure set up pn a new machine direct restore will not work.

    You would need to run "set tablespace containers for..." after you run a restore command to specify a new path.
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os

  4. #4
    Join Date
    Jan 2007
    Jena, Germany
    The SET TABLESPACE CONTAINERS command is applicable for "redirected restore". This has been discussed quite extensively here and elsewhere.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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