Reorg and then Image Copy

[James Gallegos]

If a Reorg is performed on a table space and an Image copy is taken of that table space, when the Image copy is later refreshed back into the table space, will the data be automatically reorged again after the refresh?

[vijay2082]

Hi James,

Probably you need to re look as to what happens under the cover.

Guess with image copy you mean below backup types that will include log directories by default:

The following backups will include the log directories in the image created:
db2 backup db sample use snapshot
db2 backup db sample online use snapshot
db2 backup db sample use snapshot INCLUDE LOGS
db2 backup db sample online use snapshot INCLUDE LOGS

Below link will show the compatibility of utilities with online backup:

http://publib.boulder.ibm.com/infoce.../c0021554.html

Point here is that if a backup is successful, even if one utility is running, it will try to make a consistent view of the database post restore ( rolling forward and backward through the logs as and when required).

If you are rolling past the logs for the reorg then, yes it will do a reorg during the restore phase only and you can see it happening as the messages will be logged. Accordingly the tablespace utilization will be increased.

Cheers, Vijay