Zero Downtime Backup of MaxDB database with HP Data Protector

The qgrep utility in the Windows Server 2003 Resource Kit is Windows equivalent of UNIX and Linux’s

grep utility. In UNIX, grep means search globally for lines matching the expression and print the lines.

You can download Windows Server 2003 Resource Kit Tools from

http://www.microsoft.com/downloads/details.aspx?F

milyID=9D467A69-57FF-4AE7-96EE-

B18C4790CFFD&displaylang=en

suspend_db.cmd

1. On the MaxDB application server create a file called suspend_db.cmd, and copy and save the

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

@ ECHO OFF

echo *--------------------------MaxDb's dbmcli Output---------------------------------*

echo .

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

"C:\Program Files\OmniBack\bin\suspend.txt"

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

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

echo Log Writer S t a t u s

echo .

echo ================*****==========**********========

qgrep Logwr "C:\Program Files\OmniBack\bin\tasks.txt"

=================================

del "C:\Program Files\OmniBack\bin\tasks.txt"

echo ================*****==========**********=========================================

echo .

echo *--------------------------MaxDb's dbmcli Output---------------------------------*

echo .