Informix

nested-group-icon.png

DB2

Expand all | Collapse all

onsmsync issue question

  • 1.  onsmsync issue question

    Posted Fri January 29, 2021 11:07 AM
    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
    ------------------------------


  • 2.  RE: onsmsync issue question

    Posted Sat January 30, 2021 04:42 AM


    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
    ------------------------------



  • 3.  RE: onsmsync issue question

    Posted 7 days ago

    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
    ------------------------------



  • 4.  RE: onsmsync issue question

    Posted 7 days ago
    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:


    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    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.