#!/bin/sh

#bcpyrght
#***************************************************************************
# $Copyright: Copyright (c) 2022 Veritas Technologies LLC. All rights reserved $
#***************************************************************************
#ecpyrght

#
# These environment variables are initialized by NetBackup (bphdb)
#

echo "DB2_CLIENT = $DB2_CLIENT"
echo "DB2_SERVER = $DB2_SERVER"
echo "DB2_POLICY = $DB2_POLICY"
echo "DB2_SCHED = $DB2_SCHED"
echo "DB2_FULL = $DB2_FULL"	# Is 1 if Full backup scheduled
echo "DB2_CINC = $DB2_CINC"	# Is 1 if Cumulative incremental scheduled
echo "DB2_INCR = $DB2_INCR"	# Is 1 if Differential incremental scheduled

#
# Change MY_LIB to the correct NetBackup library name for your host:
#	Solaris or Linux 32-bit	 = nbdb2.so
#	Solaris 64-bit		 = nbdb2.so64
#	HPUX (ia64)		 = nbdb2.so
#	AIX or HPUX		 = nbdb2.sl
#	AIX or HPUX		 = nbdb2.sl64
#

MY_LIB=/usr/openv/netbackup/bin/nbdb2.lib

#
# Change MY_DB2 to the correct DB2 instance name for your database.
#

MY_DB2=sample

#
# Use the NetBackup schedule type to set DB2 full or incremental options.
#

if [ "$DB2_FULL" = "1" ] ; then
	MY_SCHED=""
elif [ "$DB2_CINC" = "1" ] ; then
	MY_SCHED="INCREMENTAL"
elif [ "$DB2_INCR" = "1" ] ; then
	MY_SCHED="INCREMENTAL DELTA"
else
	MY_SCHED=""
fi

#
# Initialize the backup command line.
# Customize the number of sessions and buffer options for your environment.
#

CMD_LINE="db2 BACKUP DATABASE $MY_DB2 $MY_SCHED LOAD $MY_LIB OPEN 4 SESSIONS BUFFER 1024"

#
# Change MY_USER to the proper DB2 user for performing backups
#

MY_USER=db2inst1

echo "Executing: $CMD_LINE"
su - $MY_USER -c "$CMD_LINE"

RETURN_STATUS=$?

# Return 0 for success, non-zero for errors

exit $RETURN_STATUS