Moves a LOB to a different storage area in the database.

Syntax

proutil db-name -C lobmove [ owner-name. ] table-name 
     lob-name lob-area

Parameters

db-name
Specifies the name of the database that contains the table with the LOB that will be moved.
owner-name
Specifies the owner of the table that contains the LOB. You must specify an owner name unless the table name is unique within the database or the table is owned by PUB. By default, ABL tables are owned by PUB.
table-name
Specifies the name of the table to be moved.
lob-name
Specifies the name of the LOB to be moved. If the LOB includes a space, enclose the name in quotation marks. For example, "LOB Name".
lob-area

Specifies the name of the target area into which the LOB is to be moved. If an area name includes a space, enclose the name in quotation marks. For example, “Area Name”.

Notes

  • You can run multiple instances of LOBMOVE at the same time.
  • If LOBMOVE is interrupted with an interrupt signal or fails due to internal error, the database is left in an inconsistent state. The LOBMOVE must be restarted and run to completion to return the database to a consistent state.
  • The LOBMOVE command does not work on databases enabled for multi-tenancy or table partitioning.
  • When a LOB is in the LOBMOVE_PENDING state, CRUD operations process as follow:
    • CREATE—LOB data is created in the LOBMOVE target area.
    • READ/UPDATE/DELETE—The move counter in the LOB locator is used to determine the correct area to access the LOB data.
      • If the LOB data has been moved to the target area, the operations occur in the target area.
      • If the LOB data has not been moved, the operations occur in the source area.