Re: Using dbexport

In article <5au2s9$kbo@cssun.mathcs.emory.edu>, If your site is not a 24hr, 7 days a week site, there can be a slot in time (daily or weekly), when, using cron, you can force a restart of ONLINE (thus knocking off all users!) and then running your dbexport. A restart of ONLINE can be achieved by running a script with the following commands. onmode -ky # Shutdown immediately oninit -s # Initialize shared memorysleep 10 # Quiescent may take some time to register onmode -m # go online. (note : make sure your environment is set in your script - INFORMIXSERVER, INFORMIXDIR, ONCONFIG & PATH) Following the restart, dbexport will run normally. Hope this helps. sromankiw@execrisk.com ("Stefan P. Romankiw") wrote: >I am using dbexport (On-Line v 7.13) to perform weekly unloads of our >databases. Because of the exclusive locks that dbexport puts on a database, >it does not work if there are connections to the database. > >I am curious to find out how you solved this issue in your environments. >How do you perform weekly unloads? How do you gracefully disconnect >attached users? Do you use tools other than dbexport? etc... > >Any ideas would be welcomed. > >Steve Romankiw >Executive Risk Inc. ---------------------- Rudy Fernandes GIC, Kuwait ----------------------