Moving data without REORG or RECOVER

You can move data that you do not want to reorganize or recover.

Procedure

To move data without using the REORG or RECOVER utilities:

  1. Stop the database by issuing a STOP DATABASE command.

    Begin general-use programming interface information.

    -STOP DATABASE(dbname) SPACENAM(*)

    End general-use programming interface information.

  2. Move the data, using DSN1COPY or a non-Db2 facility.
  3. Begin general-use programming interface information.Issue the ALTER INDEX or ALTER TABLESPACE statement to use the new integrated catalog facility catalog name or Db2 storage group name.
  4. Start the database by issuing a START DATABASE command. 
    -START DATABASE(dbname) SPACENAM(*)

    End general-use programming interface information.