Informix: Restoring with OnBAR from a TSM replica
Posted in 2026
Topics: Backup & Restore
Hi, We're trying to restore data from a TSM replica. An issue is that TSM assigns new OBJECT_IDs to each object replicated. As OnBAR requests objects by their OBJECT_IDs that are stored in ixbar, 7th & 8th columns, TSM cannot find them. So my question is, is there a script anywhere to substitute in ixbar OBJECT_IDs with their replica's counterparts for me to not invent bicycle? ------------------------------ Sincerely, Dennis ------------------------------
Hi Dennis, Unless TSM provides some sort of mapping then I don't know how you could update the ixbar file with the new object ids. I imagine you are getting that error about Informix not being able to find the rootdbs in the backup. Could there be another reason, like the DSMI environment variables, or settings in the dsm.opt/dsm.sys files? You may want to check to see if IFX_TSM_OBJINFO_OFF is set as this has something to do with replicated servers and changes of the object id. It looks like you do not want that set so that Informix should restore using the metadata rather than the object id to find the objects to restore. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------
Isn't there some sort of rebuild catalog under TSM or am I miss remembering On 11/6/2026 11:48 AM, Mike Walker via IBM Community wrote: Hi Dennis, Unless TSM provides some sort of mapping then I don't know how you could update the ixbar file with the new object ids. I... -posted to the "Informix" group
Hi Mike, Thank you so much for the answer. Unfortunately, our mammoth aged Informix does not have the variable implemented. ------------------------------ Sincerely, Dennis ------------------------------
You do have the DSMI variables though. Have you confirmed that they reference the replicated TSM server?
Can you post the exact message from onbar? I think that I know the one but would like to verify.
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
------------------------------
2026-11-06 16:36:35 3146160 2949624 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2026-11-06 16:36:35 3146160 2949624 Object information: bar_objdesc obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 412151 act_type 3 act_status 0 act_start '2026-11-06 16:36:35' act_end '2026-11-04 19:00:02' ins_time 0 rsam_time 378134585 seal_time 1793808002 prev_seal_time 1793807716 level 0 copyid hi:lo 0:1324904608 req_act_id 412151 logstream 0 est_pages hi:lo 0:0 first_log 821575 chpt_log 821575 last_log 0 partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name '' ins_verify 0 ins_verify_date '' restore order 0:0 objInfo '' retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0 bkup_host '' backup_order 14384 2026-11-06 16:36:35 2949624 2885264 Begin reserved pages restore (level 0 of rootdbs, Storage Manager copy ID: 0 1324904608). 2026-11-06 16:36:35 2949624 2885264 Failed to obtain current time information. 2026-11-06 16:36:35 2949624 2885264 Completed reserved pages restore (level 0 of rootdbs). 2026-11-06 16:36:35 2949624 2885264 There are no storage spaces/logical logs to backup/restore. 2026-11-06 16:36:40 2949624 2885264 (-43140) Due to the previous error, logical restore will not be attempted. 2026-11-06 16:36:40 2949624 2885264 /opt/informix/11.70fc5xe/bin/onbar_d complete, returning 147 (0x93) ------------------------------ Sincerely, Dennis ------------------------------
I don't know what the problem is. From what I can determine, the object in TSM should be read by metadata and not object id. Are you restoring this to the same server that the backup was run against, or a different server? Have you checked the basics - that the ixbar is from the same server that the backup was performed against, and that the server number is correct for that instance? That the ROOTPATH is correct? Are you positive that the TSM backup was replicated to the server you are restoring from? I don't know how to review the objects in TSM, but I am sure there is a way. Maybe check the TSM log for messages output during the restore attempt. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------
got access the TSM cli ? dsmc (I think) On 11/6/2026 1:02 PM, Dennis Melnikov via IBM Community wrote: 2026-11-06 16:36:35 3146160 2949624 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2026-11-06 16:36:35 3146160 ... -posted to the "Informix" group
Hi Mike, The server is different. It's been replicated via mksysb restore from the original one. ixbar is correct, the server number is, too. As the server is a carbon copy the ROOTPATH is correct as well. Positive. ------------------------------ Sincerely, Dennis ------------------------------
Hi Paul, Yes I did. ------------------------------ Sincerely, Dennis ------------------------------
Maybe just to verify that there isn't another issue, are you able to restore to this instance from the original TSM server rather than the replicated server? I know that it's not what you want to do, but it would be good to confirm that it is possible. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------
Hi all, FYI, I managed to restore data after replacing original OBJECT_IDs in ixbar with replica's ones. ------------------------------ Sincerely, Dennis ------------------------------
That's great! But unfortunate that you had to do that. How were you able to determine the new object ids and map them to the items listed in ixbar? ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------
Hi Mike,
That's not a big deal, you know. OBJECT_ID is a field in a BACKUPS table that is accessible via `dsmadmc` utility,
SELECT object_id, hl_name, backup_date FROM backups
WHERE node_name='<node>'
AND filespace_name='/<INFORMIXSERVER>'
AND hl_name<>'/<INFORMIXSERVER>/0/'
AND state='ACTIVE_VERSION'
ORDER BY object_id
------------------------------
Sincerely,
Dennis
------------------------------