Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

URGENT: OnBar Backup With ISM

Status
Not open for further replies.

stjacqd

Programmer
Jan 26, 2004
8
CA
Hello everyone

I do have 3 Informix instance at the same server.

I would like to backup all 3 databases on 3 different devices on the same time.

I am using OnBar with ISM.

I was thinking to use different spool name to do it.

It is doesn't wotk.

Here is what I did.

onconfig file of the database 1:
ISM_DATA_POOL DEVDISK
ISM_LOG_POOL DEVDISK

onconfig file of database 2
ISM_DATA_POOL QASDISK
ISM_LOG_POOL QASDISK

onconfig file of database 3
ISM_DATA_POOL TSTDISK
ISM_LOG_POOL TSTDISK

I did create devices on ISM.
ism_add -device /backup/dev/data -type file
ism_add -device /backup/qas/data -type file
ism_add -device /backup/tst/data -type file

I did try to create volumes on ISM
ism_op -label /backup/dev/data -volume dev -pool DEVDISK -force
ism_op -label /backup/qas/data -volume qas -pool QASDISK -force
ism_op -label /backup/tst/data -volume tst -pool TSTDISK -force

That part didn't work. I always obtain the following error message:
nsrmm: Invalid pool name `DEVDISK'
nsrmm: Invalid pool name `QASDISK'
nsrmm: Invalid pool name `TSTDISK'

The Question:
How can we start 3 onbar on 3 different devices at the same time?




 
Hi¡
The ISMDiskData pool are provided for backup data being written to disk.

If you are using a disk directory device (-type file)
ism_add -device /backup/dev/data -type file

then you should to use the ISMDiskData pool in your ONCONFIG file

ISM_DATA_POOL ISMDiskData

and create the volumes with:

ism_op -label /backup/dev/data -volume dev -pool ISMDiskData -force

Sorry for my english, but I don't know very well.

Good luck ¡
 
Thank you coquito for your reply.
( I can explain my problem in frensh if it is easier for you )

Your reply doesn't answer my question.

I understand that I am limited on the pool name.
ISMData
ISMLogs
ISMDiskData

Is there other name that I can use to distinguish each informix database sharing the same Server to perform backups of those 3 databases at the same time?

I whish to backup on disk and at different places each databases.

Example:
Informix database Path to backup
dev /backup/dev/data
qas /backup/qas/data
tst /backup/tst/data

Now to do that, I have to rebuild the volume and the device into ISM.

What I would like to do, is build only once the ISM catalog.
like:
Spool Volume Device
ISMxxxxxx1 dev /backup/dev/data
ISMxxxxxx2 qas /backup/qas/data
ISMxxxxxx3 tst /backup/tst/data

This way, I do not have to unmount volume remove volume and devices to rebuild it each time I have a backup to do.

When I am doing "onbar", the system has to be smart enough to select the right device. (dev or qas or tst).
 
Hi stjacqd¡

( I can explain my problem in frensh if it is easier for you )
thanks but I'm mexican

I understand that I am limited on the pool name.
ISMData
ISMLogs
ISMDiskData
AND ISMDiskLogs

Is there other name that I can use to distinguish each informix database sharing the same Server to perform backups of those 3 databases at the same time?
No, according to my experience ¡

I think that you can do this:
ism_add -device /backup/dev/data -type file
ism_add -device /backup/qas/data -type file
ism_add -device /backup/tst/data -type file

ism_op -label /backup/dev/data -volume dev -pool ISMDiskData -force
ism_op -label /backup/qas/data -volume qas -pool ISMDiskData -force
ism_op -label /backup/tst/data -volume tst -pool ISMDiskData -force

ism_op -mount /backup/dev/data
ism_op -mount /backup/qas/data
ism_op -mount /backup/tst/data


Sorry again ¡

Good luck ¡
 
Hello coquito

If I am doing those 3 mounts, is onbar will not using it to do parallel backups?
So 1 database will be splited into those 3 devices?

How to force onbar to use the right device?
/backup/dev/data for Informix database dev
/backup/qas/data for informix database qas
/backup/tst/data for informix database tst
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top