Use the NO BUILD keywords for all archives except the last one. Omit the NO BUILD option for the last archive, so that Teradata ARC can:
- Build indexes for tables.
- Sort change images for journal tables.
If the NO BUILD keywords are used during a RESTORE or COPY statement, run a separate BUILD statement for all databases and/or tables that were restored. The tables are not accessible until a BUILD statement is run.
If the NO BUILD keywords are used while copying a database or table that contains Join or Hash indexes, the database/table will be in a 'restoring' state when Teradata ARC attempts to copy the Join/Hash indexes. When in the 'restoring' state, the Teradata Database will not allow any access to the database/table. This will cause the copy of the Join/Hash index to fail.
In order to copy the Join/Hash indexes, follow this procedure:
- Run a separate BUILD job to build the fallback rows and secondary indexes for the database/table. This will clear the 'restoring' state and allow user access to the database/table.
- Copy the Join/Hash index by rerunning the copy job and just specifying the Join/Hash indexes to be copied as individual objects in the copy list.
If the NO BUILD keywords are used while copying a database or table that contains Stat Collections, use the same procedure above for Join/Hash indexes in order to copy them.