October 28 2013

Setup Informix 12.10 PSM for dummy

Tagged Under : , , , , ,

Informix IDS 12.10 has replaced ISM with PSM (Primary Storage Manager). PSM is a simple storage manager for backup/restore operation with basic features (yet to reach the enterprise backup/restore solution like Netbackup, Data Protector, TSM ..). At this moment, PSM supports only DISK (filesystem) as media.

PSM is suitable for small environment and does not have 3rd party storage manager for backup.

Please find the following steps that I setup PSM 🙂

(1) Pre-requisite:
– Use informix userid
– prepare a filesystem with adequate size to hold onbar backup files

September 30 2013

How to restore critical administrative files using onbar (IDS 12.10.xC2 and above) ?

Tagged Under : , , , , , , , , ,

I notice critical files are being backup by onbar since IDS 11.70, and I have confirmed with IBM Informix support that these files are not able to restore with IDS 11.70.

From IDS 12.10.xC2 onwards, critical files are able to be restored if previous onbar backup completed successfully.

Critical files that we mentioned:
– ixbar.servernum
– oncfg_servername.servernum

To restore critical files in IDS 12.10.xC2 and above, you have 2 options:
(1) Use ‘onbar -r -cf yes’ to restore critical file during cold restore.
(2) Alternatively, you can use ‘onbar -r -cf only’ to extract critical files while Informix server is offline.