Tips for archiving to tape

If you choose to archive to tape, following certain tips can help you avoid problems.

If the unit name reflects a tape device, Db2 can extend to a maximum of twenty volumes. Db2 passes a file sequence number of 1 on the catalog request for the first file on the next volume. Although a file sequence number of 1 might appear to be an error in the integrated catalog facility catalog, be aware that this situation causes no problems in Db2 processing.

If you choose to offload to tape, consider adjusting the size of your active log data sets so that each data set contains the amount of space that can be stored on a nearly full tape volume. That adjustment minimizes tape handling and volume mounts, and it maximizes the use of tape resources. However, such an adjustment is not always necessary.

If you want the active log data set to fit on one tape volume, consider placing a copy of the BSDS on the same tape volume as the copy of the active log data set. Adjust the size of the active log data set downward to offset the space that is required for the BSDS.