Start of Content Area

Process documentation Checklist: Occasional Activities  Locate the document in its SAP Library structure

Purpose

You need to perform certain activities from time to time – depending on the nature of your setup – so that the database functions optimally in productive operation.

Process Flow

You might occasionally need to perform the following activities:

In the event that you need to restore the database after a failure, see Restore. If the database recovery report is regularly created (that is, after every archive and backup), it can significantly reduce the time taken to restore the database. Refer to Recovery Report with SAPDBA.

SAPDBA offers you a simple interface for the most commonly used commands to look in detail at particular aspects of the database. Refer to System Information with SAPDBA. For more detailed information about the full range of commands offered by Informix, see the Informix documentation.

In the unfortunate event that the logical-log files have completely filled up, you must perform an emergency backup. Refer to Emergency Logical-Log Backup. This should not be necessary if you have developed a thorough approach to logical-log backup. Refer to: