onsmsync issue question
Art Kagel asked why onsmsync had run nearly 12 hours while the onbar log repeated 'dsmMakeObjectCursorList: No more records from object table'. David Williams suggested raising BAR_DEBUG and checking the storage manager; Jean-Francois Boudry had fixed slowness by adding indexes. Art solved it by rebuilding sysutils, manually cleaning the ixbar file, then running onsmsync -b.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Guys:
A client is trying to sync the onbar safety file and clean up sysutils with onsmsync . This message is printing in the onbar log repeatedly and the onsmsync has been running for nearly 12 hours already:
2021-01-29 08:50:31 33591 24208 dsm_obj.c:658 dsmMakeObjectCursorList: No more records from object table.
I have not seen this one before. Thoughts? Problem? Red herring? Stop onsmsync? Leave it run?
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
#Informix
Hi Art, Look in the logs for the storage manager. Increase BAR_DEBUG. Which storage manger, ? http://old.iiug.org/forums/ids/index.cgi/noframes/read/38787 - psm? and Is the filesystem readonly? Regards, David. ------------------------------ David Williams ------------------------------
Hi, few years ago i had issues with onsmsync, it took very long time to execute. I had to create indexes on some tables but don't remember which ones. execution time was modified from hours to minutes. Probably running an sqltrace will help to find which indexes could be interesting if it is one of your problems Don't know if it helps Regards ------------------------------ jean-francois BOUDRY ------------------------------
Jean-Francois: Thanks, found the solution. I had to drop and rebuild the sysutils database, manually clean the ixbar file, then rebuild the table contents using onsmsync -b. For anyone searching the forum, here's a link describing the procedure: https://www.ibm.com/support/pages/how-remove-sysutils-ixbar-entries-manually-if-onsmsync-does-not-interface-storage-manager Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.