Database is currently open by another user

Hi, I have a script that runs on a crontab to do the dbexport of all databases. In that shell first a put informix in Quiecent mode with onmode -uy, then put in single user with onmode -jy, then run all the dbexports. But sometimes there is a database that fail and get the message that is opened by another user. What can I do ? Thanks in advance,

Can it be the scheduler? Try to capture some info when the error happens. informix will be able to connect... do you have scripts running in crontab for example? On Wed, Sep 7, 2016 at 6:00 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I have a script that runs on a crontab to do the dbexport of all databases. > > In that shell first a put informix in Quiecent mode with onmode -uy, then > put > in single user with onmode -jy, then run all the dbexports. > > But sometimes there is a database that fail and get the message that is > opened > by another user. > > What can I do ? > > Thanks in advance, > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --94eb2c05fb204ad13a053bed1aac

Not much you can do except onmode -z the session(s) that are still connected and hope you haven't interrupted a critical transaction. Count yourself lucky that you EVER have a time when there are no users connected to the server and you can successfully dbexport your databases. Never experienced that myself, not on a production system. Begs the question though: Why are you dbexporting all of your databases so frequently? Just curious. 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. On Wed, Sep 7, 2016 at 12:00 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: > Hi, > > I have a script that runs on a crontab to do the dbexport of all databases. > > In that shell first a put informix in Quiecent mode with onmode -uy, then > put > in single user with onmode -jy, then run all the dbexports. > > But sometimes there is a database that fail and get the message that is > opened > by another user. > > What can I do ? > > Thanks in advance, > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e010d8a223a94b5053bed903a

Thanks. I exported all the database as a secondary and a more flexible backup, my primary backup is with onbar. > El 07/09/2016, a las 9:39 a.m., Art Kagel <art.kagel@gmail.com> escribió: > > Not much you can do except onmode -z the session(s) that are still > connected and hope you haven't interrupted a critical transaction. > > Count yourself lucky that you EVER have a time when there are no users > connected to the server and you can successfully dbexport your databases. > Never experienced that myself, not on a production system. > > Begs the question though: Why are you dbexporting all of your databases so > frequently? Just curious. > > 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. > > On Wed, Sep 7, 2016 at 12:00 PM, Jorge Valenzuela <jorgervt@gmail.com> > wrote: > >> Hi, >> >> I have a script that runs on a crontab to do the dbexport of all databases. >> >> In that shell first a put informix in Quiecent mode with onmode -uy, then >> put >> in single user with onmode -jy, then run all the dbexports. >> >> But sometimes there is a database that fail and get the message that is >> opened >> by another user. >> >> What can I do ? >> >> Thanks in advance, >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e010d8a223a94b5053bed903a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I will check the scheduler, there are no other crontab running. Thanks > El 07/09/2016, a las 9:07 a.m., Fernando Nunes <domusonline@gmail.com> escribió: > > Can it be the scheduler? Try to capture some info when the error happens. > informix will be able to connect... do you have scripts running in crontab > for example? > >> On Wed, Sep 7, 2016 at 6:00 PM, Jorge Valenzuela <jorgervt@gmail.com> wrote: >> >> Hi, >> >> I have a script that runs on a crontab to do the dbexport of all databases. >> >> In that shell first a put informix in Quiecent mode with onmode -uy, then >> put >> in single user with onmode -jy, then run all the dbexports. >> >> But sometimes there is a database that fail and get the message that is >> opened >> by another user. >> >> What can I do ? >> >> Thanks in advance, >> >> >> ************************************************************ >> ******************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --94eb2c05fb204ad13a053bed1aac > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >