Zero Downtime Backup of MaxDB database with HP Data Protector

To create 0the split mirror or snapshot, proceed as follows:
dbmcli -d <database_name> -u <dbm_user>,<password>
util_connect <dbm_user>,<password>
util_execute suspend logwriter
==> Create the split mirror or snapshot
util_execute resume logwriter
util_release
exit
To create the snapshot, you can call a command for the operating system
or a script with the exclamation mark:
dbmcli -d <database_name> -u <dbm_user>,<password>
...
!/..../.../create_snapshot.sh
...
Important: With Version 7.3, you must not exit the utility session
between suspend logwriter and resume logwriter. With version 7.4, this is
permitted.
The database manager CLI command "util_execute suspend logwriter" returns
the following:
OK
LOGPOS = <number>
<number> corresponds to the log page of the current character position.
You can compare this log page with the page numbers of the log backups in
the log history.
While the log writer is suspended, transactions that change data and
therefore want to write data log entries are suspended. Therefore, the
period of time between suspend logwriter and resume logwriter should be
as short as possible in a production system. The procedure is not
suitable for creating data backups in such a way that the data volumes
are physically copied while the log is suspended (copy, cp, dd, ...).
You can use a select to check the status of the suspension at a specific
time.
Versions as of 7.3.00.36, 7.4.02.21, 7.4.03.23, 7.5.00.39:
select * from show_stat_state
where description = 'Logwriter suspended'
As of Version 7.6:
select LOGWRITERSUSPENDED from loginformation
55