I know that this documentation is correct for IDS 10.0 and 11.7. We had a situation where we hadn't run onsmsync in years. We had to drop the sysutils database, recreate it and load it from a truncated ixbar file using the procedure listed by JJ. I did this on 2 databases. Worked like a champ. Backups of database and ixbar files and shutting off logging were involved. I was working with support of IBM at the time.
-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org] On Behalf Of JJ
Sent: Thursday, April 18, 2013 9:45 AM
To: informix-***@iiug.org
Subject: Re: Sysutils query to create ixbar file
Hmmm ... this is not the answer you are looking for ... it is also from 11.70 :D
onsmsync -b ...
"If the ixbar file is empty or does not exist, onsmsync -b recreates the ixbar file and populates it from the syutils tables.
If the ixbar is not empty and contains object data, onsmsync -b updates the sysutils database and the ixbar file so that they are in sync.
If the ixbar file has entries and the sysutils database has been rebuilt, but is empty because it does not contain data, the onsmsync -b option recreates the sysutils data from the ixbar file.
The -b element is not used with the other onsmsync options. Additionally, it does not synchronize with the storage manager."
This might be enough ... it is fairly old info ...
http://www.iiug.org/onbar/ixbar.html
Post by red_valsenDoes anybody have the query which will create the ixbar file from the sysutils database? This is the disguised question, "What are the columns of the ixbar file?" The B&R manual for 11.70 erroneously documents the sysutils tables.