#!/bin/sh

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

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

echo "DB2_SCHEDULED = $DB2_SCHEDULED"
echo "DB2_USER_INITIATED = $DB2_USER_INITIATED"
echo "DB2_SERVER = $DB2_SERVER"
echo "DB2_POLICY = $DB2_POLICY"

RETURN_STATUS=0

CMD_LINE=""

#
# Will restore the latest backup
#
# Change nbdb2.lib below 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 32-bit	 = nbdb2.sl
#	AIX or HPUX 64-bit	 = nbdb2.sl64

CMD_LINE="db2 RESTORE DATABASE sample LOAD /usr/openv/netbackup/bin/nbdb2.lib "
CMD_LINE=$CMD_LINE"OPEN 1 SESSIONS BUFFER 1024 REPLACE EXISTING WITHOUT PROMPTING"

#
# The username on the "su" command needs to be replaced with the correct 
# user name.
# 

echo "Execute $CMD_LINE"
su - db2inst1 -c "$CMD_LINE"

RETURN_STATUS=$?
echo "Restore status = "$RETURN_STATUS

if [ $RETURN_STATUS -le 2 ]  
then

  RETURN_STATUS=0

fi


exit $RETURN_STATUS