SAP/MaxDB backup of transaction logs - status code 6 resolution

@REM
@REM $Header: sap_maxdb_backup.cmd,v 1.3 2005/05/26 11:13:03 $
@REM
@echo off
@REM bcpyrght
@REM **************************************************************************
@REM * $VRTScprght: Copyright 1993 - 2012 Symantec Corporation, All Rights Reserved $ 
@REM **************************************************************************
REM ecpyrght

REM This environment variable are created by Netbackup (bphdb)

echo SAP_SCHEDULED = %SAP_SCHEDULED%
echo SAP_USER_INITIATED = %SAP_USER_INITIATED%
echo SAP_SERVER = %SAP_SERVER%
echo SAP_POLICY = %SAP_POLICY%
echo SAP_FULL = %SAP_FULL%
echo SAP_CINC = %SAP_CINC%

set BSI_ENV="C:\Program Files\VERITAS\NetBackup\DbExt\SAP\bsi.env"

set DBMCLI=P:\sapdb\clients\DatabaseStudio\pgm\dbmcli.exe
set DB=DB1

@set TMPFILE="C:\temp\bphdb.temp.%RANDOM%"
@set NOLOGSDETECTED_STRING="-123, No more log to save" 

REM Run backup

@if "%SAP_FULL%" EQU "1" @set CMD_LINE=%DBMCLI% -d %DB% -u control,pass -uUTL control,pass backup_start BACKData
@if "%SAP_CINC%" EQU "1" @set CMD_LINE=%DBMCLI% -d %DB% -u control,pass -uUTL control,pass backup_start BACKPage
@if "%SAP_SNC_SCHED%" EQU "transactions" @set CMD_LINE=%DBMCLI% -d %DB% -u control,pass -uUTL control,pass backup_start BACKLog
%CMD_LINE% > %TMPFILE%

REM ---------------------------------------------------------------------------
REM To communicate with NetBackup's job monitor for an automatic schedule
REM a "STATUS_FILE" variable is created by NetBackup (bphdb) that contains
REM a path to a file.  This file is check by Netbackup to determine if the
REM automatic schedule was successful.  It is up to the script to write
REM a 0 (passed) or 1 (failure) to the status file to communicate to NetBackup
REM the status of the execution of the script.  The following code echo a 0
REM to %STATUS_FILE% if succcessful and echo a 1 to %STATUS_FILE% for a
REM failure.
REM ---------------------------------------------------------------------------

if errorlevel 1 goto errormsg
echo DBMCLI successful
if "%STATUS_FILE%" == "" goto end
if exist "%STATUS_FILE%" echo 0 > "%STATUS_FILE%"
goto end

:errormsg
echo Execution of DBMCLI command failed - exiting
if "%STATUS_FILE%" == "" goto end
echo Checking if failure was not due to no logs to backup (added by Radovan Turan)
type %TMPFILE% | find %NOLOGSDETECTED_STRING% >nul
if errorlevel 0 goto nologsdetected
if exist "%STATUS_FILE%" echo 1 > "%STATUS_FILE%"
goto end

:nologsdetected
echo By dbmcli output seems that no logs are available to backup (added by Radovan Turan)
if exist "%STATUS_FILE%" echo 0 > "%STATUS_FILE%"

:end
REM Print the content of "dbmcli" to be included in bphdb log file as in standard Symantec script
echo.
echo Output of dbmcli:
echo.
type %TMPFILE%
del /Q %TMPFILE%