Home
Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
Backup and Restore Guide
The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
Backup and restore configuration parameter reference
Backup and restore configuration parameters
These topics describe the configuration parameters that you use with the ON-Bar, ontape, and archecker utilities.
Informix® Primary Storage Manager configuration parameters
The Informix® Primary Storage Manager uses the information in some specific configuration parameters.
PSM_ACT_LOG configuration parameter
Use the PSM_ACT_LOG configuration parameter to specify the location of the Informix® Primary Storage Manager activity log if you do not want the log information included in the ON-Bar activity log.

Administering
In addition to administering the database server, you can tune performance, replicate data, and archive data.
- System administration
  These topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
- Backup and Restore Guide
  The Informix® Backup and Restore Guide describes how to use the Informix ON-Bar and ontape utilities to back up and restore database server data. These utilities enable you to recover your databases after data is lost or becomes corrupted due to hardware or software failure or accident.
  - Overview of backup and restore
    These topics provide an overview of backup and restore concepts. They also provide information about planning for backup and restore operations.
  - ON-Bar backup and restore system
  - ontape backup and restore system
  - Backup and restore a Remote Secondary Server(RSS)
  - Integrated Backup Encryption
    These topics provide information about Integrated Backup Encryption.
  - Informix® Primary Storage Manager
    The Informix® Primary Storage Manager manages storage for ON-Bar backup and restore operations, including parallel backups, that use file devices (disks).
  - archecker table level restore utility
  - Backup and restore configuration parameter reference
    - Backup and restore configuration parameters
      These topics describe the configuration parameters that you use with the ON-Bar, ontape, and archecker utilities.
      - ON-Bar and ontape configuration parameters and environment variable
        Many properties of the ON-Bar and ontape utilities are controlled by configuration parameters in the onconfig file. ON-Bar also has an environment variable.
      - The archecker utility configuration parameters and environment variable
        These topics describe the AC_CONFIG environment variable and the configuration parameters that you use with the archecker utility.
      - Informix® Primary Storage Manager configuration parameters
        The Informix® Primary Storage Manager uses the information in some specific configuration parameters.
        PSM_ACT_LOG configuration parameter
        Use the PSM_ACT_LOG configuration parameter to specify the location of the Informix® Primary Storage Manager activity log if you do not want the log information included in the ON-Bar activity log.
        PSM_CATALOG_PATH configuration parameter
        Use the PSM_CATALOG_PATH configuration parameter to specify the full path to the directory that contains the Informix® Primary Storage Manager catalog tables. These catalog tables contain information about the pools, devices, and objects managed by the storage manager.
        PSM_DBS_POOL configuration parameter
        Use the PSM_DBS_POOL configuration parameter to change the name of the pool in which the Informix® Primary Storage Manager places backup and restore dbspace data.
        PSM_DEBUG configuration parameter
        Use the PSM_DEBUG configuration parameter to specify the amount of debugging information that prints in the Informix® Primary Storage Manager debug log if you want to use a debug level that is different from the one used by ON-Bar.
        PSM_DEBUG_LOG configuration parameter
        Use the PSM_DEBUG_LOG configuration parameter to specify the location of the debug log to which the Informix® Primary Storage Manager writes debugging messages if you do not want the log information included in the ON-Bar debug log.
        PSM_LOG_POOL configuration parameter
        Use the PSM_LOG_POOL configuration parameter to change the name of the pool in which the Informix® Primary Storage Manager places backup and restore log data.
      - Event alarm configuration parameters
        When you set configuration parameters for use with the ON-Bar and ontape utilities, also determine if you need to adjust the ALARMPROGRAM and ALRM_ALL_EVENTS configuration parameters.
  - Cloud Backup
    These topics provide information about storing and retrieving the backups directly to the ecosystem of selected cloud providers, namely Amazon S3 and Softlayer Object Storage.
  - Appendixes
- Enterprise Replication
  The HCL® Informix® Enterprise Replication Guide describes the concepts of data replication using Informix Enterprise Replication, including how to design your replication system, as well as administer and manage data replication throughout your enterprise.

PSM_ACT_LOG configuration parameter

Use the PSM_ACT_LOG configuration parameter to specify the location of the Informix® Primary Storage Manager activity log if you do not want the log information included in the ON-Bar activity log.

onconfig.std value: none
if value not present: The value of the BAR_ACT_LOG configuration parameter is used
range of values: Full path name
takes effect: When the onpsm utility starts; When you reset the value dynamically in your onconfig file by running the onmode -wf command.

Usage

Specify a path to an existing directory with an appropriate amount of space available or use $INFORMIXDIR/psm_act.log. If you specify a file name only, the storage manager creates the activity log in the working directory in which you started the storage manager.

If the PSM_ACT_LOG configuration parameter is not set, the Informix® Primary Storage Manager puts activity information in the directory specified with the BAR_ACT_LOG configuration parameter. To clearly distinguish ON-Bar and Informix® Primary Storage Manager activity information, use the PSM_ACT_LOG to specify a different location for the storage manager activity log.

The format of the file resembles the format of the database server message log. You can examine the activity log to determine the results of storage manager actions.

The file specified by the PSM_ACT_LOG configuration parameter is created if it does not exist.

You can also use the PSM_ACT_LOG environment variable to specify the location of the Informix® Primary Storage Manager activity log for your environment, for example, for a single session.