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
(2) Set ONCONFIG parameters that need instance restart.
BAR_BSALIB_PATH to use PSM library in ONCONFIG file.
BAR_BSALIB_PATH $INFORMIXDIR/lib/libbsapsm.so
You may set auto logical logs backup whenever logical logs switched.
ALARMPROGRAM $INFORMIXDIR/etc/log_full.sh
Note: restart instance is required for these changes.
(3) You may use default media pools in ONCONFIG
PSM_DBS_POOL DBSPOOL
PSM_LOG_POOL LOGPOOL
(4) To set the DIR for media pools:
$ onpsm -D add /infbak/psm/DBSPOOL -g DBSPOOL -p HIGHEST -t FILE
$ onpsm -D add /infbak/psm/LOGPOOL -g LOGPOOL -p HIGHEST -t FILE
$ onpsm -D list
Informix PSM Device List
Type Prio Block/Size (MB) Pool Name Device Name
FILE LOW –/– DBSPOOL /usr/informix_tst1_dba/backups
FILE HIGHEST –/– DBSPOOL /infbak/psm/DBSPOOL
FILE LOW –/– LOGPOOL /usr/informix_tst1_dba/backups
FILE HIGHEST –/– LOGPOOL /infbak/psm/LOGPOOL
Note: You notice there are default devices set as LOW priority. Devices with HIGHEST priority will be utitilized first before LOW.
(5) Optional: If you don’t like LOW priority devices, you may remove from the Device List.
$ onpsm -D del /usr/informix_tst1_dba/backups -d -g DBSPOOL -y
$ onpsm -D del /usr/informix_tst1_dba/backups -d -g LOGPOOL -y
$ onpsm -D list
Informix PSM Device List
Type Prio Block/Size (MB) Pool Name Device Name
FILE HIGHEST –/– DBSPOOL /infbak/psm/DBSPOOL
FILE HIGHEST –/– LOGPOOL /infbak/psm/LOGPOOL
(6) By default, PSM catalog is set to $INFORMIXDIR/etc/psm.
(7) Run level 0 backup with onbar:
$ onbar -b -L 0
You should able to find Level 0, logical logs and critical files backup successfully from BAR_ACT_LOG.
Example:
2013-10-28 16:19:42 30165 30163 Archive on dba_tst1_rootdbs, dba_tst1_dbs1, dba_tst1_dbs2 Completed (Request
ed Level 0).
2013-10-28 16:19:43 30165 30163 Completed backup logical log 35 (Storage Manager copy ID: 0 4).
2013-10-28 16:19:43 30165 30163 Completed backup of critical file ‘/usr/informix_tst1_dba/etc/ixbar.50’ (Storage Manager copy ID: 0 5).
2013-10-28 16:19:43 30165 30163 Completed backup of critical file ‘/usr/informix_tst1_dba/etc/oncfg_dba_tst1_srv.50’ (Storage Manager copy ID: 0 6).
2013-10-28 16:19:43 30165 30163 Completed backup of critical file ‘/usr/informix_tst1_dba/etc/onconfig.dba_tst1’ (Storage Manager copy ID: 0 7).
2013-10-28 16:19:43 30165 30163 Completed backup of critical file ‘/usr/informix_tst1_dba/etc/sqlhosts’ (Storage Manager copy ID: 0 8).
(8) Auto logcal logs backup triggered when swtich logical logs.
$ onmode -l
$ onstat -m | tail -3
16:33:55 Logical Log 36 – Backup Started
16:33:55 Logical Log 36 – Backup Completed
(9) Check backup objects in catalog.
$ onpsm -O list
Informix PSM Object List
Object ID Date Created Size (MB) Logical path (name.version)
1 2013-10-28 16:19:39 18.5 /dba_tst1_srv/dba_tst1_rootdbs/0/dba_tst1_srv.1
2 2013-10-28 16:19:41 2.9 /dba_tst1_srv/dba_tst1_dbs1/0/dba_tst1_srv.1
3 2013-10-28 16:19:41 0.1 /dba_tst1_srv/dba_tst1_dbs2/0/dba_tst1_srv.1
4 2013-10-28 16:19:42 7.4 /dba_tst1_srv/50/35/dba_tst1_srv.1
5 2013-10-28 16:19:43 0.0 /dba_tst1_srv/critical_files/ixbar/dba_tst1_srv.1
6 2013-10-28 16:19:43 0.0 /dba_tst1_srv/critical_files/oncfg/dba_tst1_srv.1
7 2013-10-28 16:19:43 0.1 /dba_tst1_srv/critical_files/onconfig/dba_tst1_srv.1
8 2013-10-28 16:19:43 0.0 /dba_tst1_srv/critical_files/sqlhosts/dba_tst1_srv.1
9 2013-10-28 16:33:55 0.0 /dba_tst1_srv/50/36/dba_tst1_srv.1
(10) You may also use onbar to restore and recover as usual.
For example: “onbar -r” or “onbar -r -p ; onbar -r -l”