Zero Downtime Backup of MaxDB database with HP Data Protector

lgwr.cmd

3. On the MaxDB application server create a file called lgwr.cmd and copy and save the

following into it. Make sure you adapt the file to suit MaxDB instance login requirements:

@ ECHO OFF

C:\Lab\sdb\programs\pgm\dbmcli.exe -uUTL -d MAXDB -u DBADMIN,maxy -uSQL DBADMIN,maxy -i

"C:\Program Files\OmniBack\bin\lgwr.txt" > tasks.txt

qgrep Logwr tasks.txt

suspend.txt

4. On the MaxDB application server create a file called suspend.txt and copy and save the

following into it:

show state

sql_execute suspend logwriter

resume.txt

5. On the MaxDB application server create a file called resume.txt and copy and save the

following into it:

sql_execute resume logwriter

show state

lgwr.txt

6. On the MaxDB application server create a file called lgwr.txt and copy and save the

following into it:

show tasks

How does the script-assisted backup work?

Overview

MaxDB ZDB backup is based on scripts. This is realized by pre- and post-exec scripts executed at the

application level facilitated by the ZDB Agent. All scripts must deploy and execute only on the

application server.