Archiving and Restoring Data in IT Service Vision

Table Of ContentsIT Service Vision Help


To initiate archiving for any table in IT Service Vision, you must turn on the archive flag for that table in the PDB's data dictionary. You can do this from the interactive user interface (describe it on MVS and the new GUI), or you can submit dictionary utility statements, using the CPDDUTL macro. For example, to turn on archiving for the XJOBS table, you would execute the statement


Data is archived in IT Service Vision at the time that it is processed into a PDB. All tables that are processed together will be written to a single archive library. These libraries are created dynamically by the PROCESS step, and are allocated and named according to parameters that you can specify via the interactive interface. You can control whether the archive libraries are stored on tape or disk, the root name of the archive libraries, and many other parameters, such as the retention period, LABEL for tapes, etc.

For additional information on archiving and retrieval of your data, read the sections on the % CPARC and %CPRETR macros in the Reference Documentation.


In IT Service Vision release 2 on MVS, you set these parameters by selecting PDB Admin --> Set Active PDB Options. The following fields are among those displayed:

Archive type: Select either DASD or tape, depending on what media you wish to store your archives on.
Archive unit: The UNIT= parameter that you would use in your JCL to allocate a library on this media, for example, CART or 3490 or SYSDA.
Archive root: The high-level qualifier that you want assigned to the archive libraries for this PDB. The default is the same high-level qualifier used for the PDB. The final qualifier will be of the form Znnnnnnn, where n begins with 1 and increases each time an archive library is created.
Archive library allocation parameter string: Any other parameters that you wish to include in the allocation of the archive library. For example, you might wish to set the LABEL parameter if the library is on tape, or the RETPD parameter so that the libraries will be deleted after the specified period of time. For example, if you want your archives to be on tape and be retained for 3 months, your parameter string might look like:


In batch mode, you can update all of these parameters using the %CPPDBOPT macro. You specify the values for archiving in the macro parameters ENGINE=[DISK|TAPE], ARCDEV=unit, ARCPATH=arcroot, and ARCHPARM=parmstring, respectively.

UNIX and Windows NT:

To activate the archiving facility for your PDB, follow this path from the main window:

Manage PDBs -> Properties -> Archive

The parameters here are the same as described for MVS.


To restore data from an archive library, you must have executed the CPSTART macro with a new, empty PDB where you wish to store the restored data. The CPARCRET macro restores the data to the PDB specified in the CPSTART macro. CPARCRET has the following parameters:

ARCHPDB The PDB whose data you wish to restore. The dictionary from this PDB contains information about what tables and date ranges each archive library contains, so that ITSV can determine where to obtain the data you request.
BEGIN The beginning date/time of the range you wish to restore. This can be specified just as in any other ITSV macro, where BEGIN can be just the date(ddmmmyyyy) and the time of 00:00 is assumed, or TODAY, TODAY-1@12:00, etc.
END The ending date/time of the range you wish to restore. This can be specified just as in any other ITSV macro, where END can be just the date (ddmmmyyyy) and the time of 23:59 is assumed, or TODAY, TODAY-n@12:00, etc. If no END value is given, CPARCRET restores all data for the specified tables from after the BEGIN specification.
TABLES The list of tables whose data you wish to restore. To restore all tables with archived data within the date range you give, specify TABLES=_ALL_ .

Current known limitations:

  1. You must be running SAS 6.09 TS455 on MVS.
  2. If you execute the MAINTAIN TABLE dictionary utility statement on a table, it will set the ARCHIVE flag to N.
  3. The macro does not check for the possibility that some of the archives are on tape and some are on disk. It assumes that all are on the same media as currently defined in the dictionary of the ARCHPDB.
  4. Archives are restored in their entirety. That is, if you request a time span starting at noon, and the archive starts at 8:00 a.m., the data from 8:00 a.m. until noon will also be restored.