Start of Content Area

Function documentation Informix Tools  Locate the document in its SAP Library structure

Use

Although Informix provides a range of tools for database administration, SAP recommends that you use the SAP tools when possible. However, some of the Informix tools are essential. For example, you must choose ontape , ON-Archive , or ON-Bar as the data recovery tool, because there is no equivalent supplied by SAP.

ontape , ON-Archive , and ON-Bar are the data recovery tools currently supplied by Informix. Data recovery includes archive (if you are using ON-Archive or ontape ), backup, and restore. Refer to Comparison of ON-Bar, ON-Archive, and ontape for Data Recovery.

Informix supplies the following for use with ON-Archive :

Name

Is used for

onarchive

Working interactively with ON-Archive

ondatartr

Performing offline operations, for example, to restore a database that is down

onautovop

Performing unattended operations

oncatlgr

Handling communication between ON-Archive and the database

 

Caution

You cannot use data migration tools (for example onload or dbexport ) for data recovery. These tools do not use information stored in the logical-log files and do not save the necessary system-overhead information required for data recovery.

You might also need to use the following Informix tools, which use a command-line interface:

Name

Is used to

oncheck

Check and repair disk structures

onmode

Perform a variety of functions, including changing operating mode of the Informix Dynamic Server

onspaces

Modify dbspaces and their associated chunks

onstat

Provide monitoring information about the Informix Dynamic Server

Integration

Integration of Informix Tools by SAP

Tool

Used

ON-Archive and ON-Bar

onstat

By SAPDBA to provide system information

 

See also:

Informix documentation at http://www.informix.com

ON-Bar for Data Recovery

ON-Archive for Data Recovery

ontape for Data Recovery