Setting Up Tape Volumes for Archive (ON-Archive and ontape)
Use
You need to set up enough tape volumes with adequate capacity for Informix database archive with
ON-Archive and ontape .Procedure
Assign tape volumes for database archive, keeping the following in mind:
The amount of data you need to archive determines how many volumes you require for a single archive.
For example, how often you archive and at what
The longer you keep your tapes before overwriting them, the more volumes you require. The recommended period is 28 days or longer.
If you use
The following examples illustrate the number of tape volumes required for archiving a normal and a large database:

Assume you want to archive at level-0 (full) daily during the working week (Monday to Friday). This requires two tape volumes per archive.
Assume you want to have a four week (28-day) cycle (that is, the tapes are reused after this period).
Then you need:
2 volumes per day x 5 days per week x 4 weeks = 40 volumes

Assume you want to archive at level-1 (incremental) daily during the working week (Monday to Friday). This requires two tape volumes per archive. Also assume that you want to archive at level-0 (full) once a week on the weekend and this requires four volumes per archive
Assume you want to have an eight week (56-day) cycle (that is, the tapes are reused after this period).
Then you need:
Level-1 archives: 2 volumes per day x 5 days per week x 8 weeks = 80 volumes
Level-0 archives: 4 volumes per week x 8 weeks = 32 volumes
Therefore, you need 112 volumes in total.
Result
Your have set up tape volumes for optimal database archive with
ON-Archive and ontape .