How to migrate indexes

You can control automatic migration processing by scheduling the STRDSMOND command to run with the appropriate options. You can also manually start migration processing by running the STRDSMOND command from the command line.

When the STRDSMOND command migrates indexes, it saves the following messages in the System Log. A set of three messages should be saved in the System Log for each table that is migrated from the database to archive storage:

166 Application Group Segment Export: Name(ApplGrp_Name) Agid(AGID) SegName(Segment)

14 DB Info: Exported(rows_exported) SqlCode(SQL Code)

87 Application Group Load: Name(System Migration)

The first message identifies a table of application group index data that is to be migrated from the database to archive storage. The second message reports the status of exporting the table from the database to temporary storage. The third message reports the loading of information about the migrated table into the System Migration application group. The System Migration application group must be assigned to a storage set that identifies an archive storage media type (such as cloud storage, a disk pool, optical, or tape).