Move Database Space

The Move command is used to move a database space (data, index, journal or journal overflow) to a new physical location. The database that contains the space to be moved must be inactive (stopped).

For Journal Overflow Space, this is the only command that is available. Journal overflow is automatically created or extended if it is necessary, and it will also be automatically removed or decreased during server shutdown. Hence no administration is necessary.

Start of instruction setTo move a database space

  1. Expand the database object that contains the space that you want to move.

  2. Expand the object Database Spaces and the type of space that you want to move (for example, data space). Then select the space that you want to move and choose Move from the context menu. The Move Data Space page appears.

    graphics/move.png

  3. Select the new location where the space is to be moved to from the New Location drop-down list box. The following information about the new location is displayed:

    • the location path

    • the location type

    • the amount of size used

    • the amount of size free

  4. Choose OK to move the space.