August 21 2014

Informix Archecker – point in time restore/recover table (Scenario 2)

Tagged Under : , , , ,

I would like to share this feature with all of you – Informix Archecker.
It can be used to restore/recover (point-in-time) to a new target table (new table name) from backup.

Scenario 2:
– Someone accidentally performed a mass update for all rows in table “customer” on 2014-08-21 10:48:00.
– You need to restore & recover (point in time) to a new table called “customer_res” until 2014-08-21 10:46:00. (Current table “customer” will be maintained)
– Database = stores_demo, Source Table = customer, Target New Table = customer_res
– You are using Informix Archecker with Netbackup Informix Agent for backup/restore.

Note: Informix Archecker is available since IDS 10.00 or higher.

(1) 2014-08-21 09:50:00:

$ dbaccess stores_demo –
> select count(*) from customer ;

(count(*))

28

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:
– ONCONFIG
– SQLHOSTS
– 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.