company logo

ODABAClient :: StartPause - Pause Server

When pausing the server no more transactions can be committed until pausing the server is stopped (StopPause()). The server can pause only after finishing all running transaction commits. If any commit is still running after five minutes or a given number seconds (wait_sec) the server will not pause (error 323). When the server cannot pause the function stops without pausing the server.

Pause functions can be used for keeping the database in a consistent state while backing up the database without closing the server. Pause commands should not be used when running long transactions as large imports or database reorganization.

Transactions will not be committed anymore after pausing the server. The timeout interval for committing transactions is 10 minutes. When not being able to start committing the transaction within the timeout interval the transaction is canceled.

Any application may access the database in the pause state as long as not writing to the database, i.e. as long as not storing transactions to the database.

For allowing storing data to the database again use the StopPause() function.

Return value:  Success ( logical  )

Implementation details

logical ODABAClient  :: StartPause ( int32 wait_sec=300 )
  • wait_sec - Number of seconds to wait

    The system waits the given number of seconds before executing the request.

    Default: 300