#!/bin/ksh

 #*************************************************************************
 # Licensed Materials - Property of IBM                                   *
 # 5724-E49                                                               *
 # 5765-F35                                                               *
 # 5765-F41                                                               *
 # 5724-N76                                                               *
 # 5724-B55
 # (c) Copyright IBM Corporation 2000,2006.                               *
 # All rights reserved.                                                   *
 #                                                                        *
 # US Government Users Restricted Rights - Use, duplication or            *
 # disclosure restricted by GSA ADP Schedule Contract with                *
 # IBM Corporation.                                                       *
 #*************************************************************************
 #  Permission Notice                                                     *
 #                                                                        *
 #  Permission is granted to copy, use, modify, and merge this sample     *
 #  software into your applications and to permit others to do any of the *
 #  foregoing. You may further distribute this software for               *
 #  commercial purposes only as part of your application that adds        *
 #  significant value and function beyond that provided by these          *
 #  samples.                                                              *
 #  You must include this permission statement and retain the copyright   *
 #  notice in all copies and modified versions of this software.          *
 #                                                                        *
 #*************************************************************************
 #                                                                        *
 #  DISCLAIMER OF WARRANTIES                                              *
 #                                                                        *
 #  The sample software is provided to you by IBM to assist you in        *
 #  developing your applications. THIS SOFTWARE IS PROVIDED AS-IS,        *
 #  WITHOUT WARRANTY OF ANY KIND. IBM SHALL NOT BE LIABLE FOR ANY         *
 #  DAMAGES ARISING OUT OF YOUR USE OR THE USE BY ANY THIRD PARTY         *
 #  OF THE SAMPLE SOFTWARE EVEN IF IT HAS BEEN ADVISED OF THE POSSIBILITY *
 #  OF SUCH DAMAGES. IN ADDITION, IBM SHALL NOT BE LIABLE FOR ANY THIRD   *
 #  PARTY CLAIMS AGAINST YOU.                                             *
 #                                                                        *
 #*************************************************************************
 # Product Name:      DB2 Net Search Extender
 #
 # Source File Name:  nsesample_cleanup
 #
 # Description:       This script drops all sample tables, indexes
 #                    disables the database, and disables the text
 #                    columns.
 # *******************************************************************

 # *******************************************************************
 # S Y N T A X :
 #        nsesample_cleanup <databasename> -all
 #
 #        If -all is given database <databasename> will be drop as well.
 #
 #
 # ********************************************************************
 #
 # 0. The following steps have been done in advance:
 #    - DB2 Net Search Extender has been installed.
 #    - DB2 default instance has been created.
 #
 # ********************************************************************
 #
 # Environment: Unix
 #
 # ********************************************************************

 # ********************************************************************
 # Get syntax help
 # ********************************************************************

help1()
{
echo "------------------------------------------------------------------------"
echo "Usage : nsesample_cleanup database_name [ -all ]" 
echo "------------------------------------------------------------------------"
exit
}

 # Remove nsesample_cleanup log file if exists ********************************
rm $HOME/nsesample_cleanup.log 2> /dev/null

 # ********************************************************************
 # Get database name and http server root directory
 # ********************************************************************


if [[ -z $1 ]] 
  then help1
fi

if [ $1 = -h ] 
  then help1 
fi

if [ $1 = --help ] 
  then help1 
fi


DROP_DB=0

if [[ -n $2 ]]
 then
   if [ $2 = -all ]
    then 
     DROP_DB=1
    else
     help1
   fi
fi

echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "Start nsesample_cleanup ...                                       ">> $HOME/nsesample_cleanup.log


echo "Cleanup the database $1 ..."
 # ********************************************************************
 # Start DB2
 # ********************************************************************
echo "********************************************************* ">> $HOME/nsesample_cleanup.log
echo "Start the database manager:                               ">> $HOME/nsesample_cleanup.log
echo "db2start                                                  ">> $HOME/nsesample_cleanup.log
db2start                                                         >> $HOME/nsesample_cleanup.log

 # ********************************************************************
 # Connect to database
 # ********************************************************************
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "Connect to database $1                                    ">> $HOME/nsesample_cleanup.log
db2 connect to $1                                              >> $HOME/nsesample_cleanup.log


 # *********************************************************************
 # Set the environment variable DB2DBDFT
 # *********************************************************************
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "export DB2DBDFT=$1                                           ">> $HOME/nsesample_cleanup.log
export DB2DBDFT=$1
 # *********************************************************************

 # *********************************************************************
 # Start the Update and Locking services
 # *********************************************************************
echo "********************************************************* ">> $HOME/nsesample_cleanup.log
echo "Start the Update and Locking services:                    ">> $HOME/nsesample_cleanup.log
echo "db2text start                                             ">> $HOME/nsesample_cleanup.log
db2text start                                                  >> $HOME/nsesample_cleanup.log
 # *********************************************************************


 # *********************************************************************
 # Deactivate Cache for index
 # *********************************************************************
echo "********************************************************* ">> $HOME/nsesample_cleanup.log
echo "Deactivate Cache for index                                ">> $HOME/nsesample_cleanup.log
echo db2text "deactivate cache for index DB2EXT.COMMENT for text">> $HOME/nsesample_cleanup.log
db2text deactivate cache for index DB2EXT.COMMENT for text       >> $HOME/nsesample_cleanup.log


 # *********************************************************************
 # Drop index
 # *********************************************************************

echo "Drop the text indexes ... " 
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo " Drop indexes:                                            ">> $HOME/nsesample_cleanup.log
echo db2text "drop index DB2EXT.COMMENT for text                ">> $HOME/nsesample_cleanup.log
db2text "drop index DB2EXT.COMMENT for text" >> $HOME/nsesample_cleanup.log

echo "db2text drop index DB2EXT.HTMLIDX for text"                >> $HOME/nsesample_cleanup.log
db2text "drop index DB2EXT.HTMLIDX for text"                     >> $HOME/nsesample_cleanup.log


 # *********************************************************************
 # Disable the database
 # *********************************************************************
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "Disable the database $1:                                  ">> $HOME/nsesample_cleanup.log
echo "db2text disable database for text                         ">> $HOME/nsesample_cleanup.log
db2text disable database for text                                >> $HOME/nsesample_cleanup.log
 # *********************************************************************


 # ********************************************************************
 # Drop sample table
 # ********************************************************************
echo "********************************************************* ">> $HOME/nsesample_cleanup.log
echo "Drop sample table db2ext.texttab in database $1:          ">> $HOME/nsesample_cleanup.log
echo "db2 drop table db2ext.texttab                             ">> $HOME/nsesample_cleanup.log
db2 "drop table db2ext.texttab"                                  >> $HOME/nsesample_cleanup.log

echo "Drop sample table db2ext.htmltab in database $1:">> $HOME/nsesample_cleanup.log
echo "db2 drop table db2ext.htmltab">> $HOME/nsesample_cleanup.log
db2 "drop table db2ext.htmltab" >> $HOME/nsesample_cleanup.log
 # ********************************************************************


echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "connect reset                    *************************">> $HOME/nsesample_cleanup.log
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo db2 connect reset >> $HOME/nsesample_cleanup.log
db2 connect reset >> $HOME/nsesample_cleanup.log

echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "deactivate database $1           *************************">> $HOME/nsesample_cleanup.log
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo db2 deactivate database $1 >> $HOME/nsesample_cleanup.log
db2 deactivate database $1 >> $HOME/nsesample_cleanup.log

if [ $DROP_DB = 1 ]
then
 echo "**********************************************************">> $HOME/nsesample_cleanup.log
 echo "drop database $1           *************************">> $HOME/nsesample_cleanup.log
 echo "**********************************************************">> $HOME/nsesample_cleanup.log
 echo db2 drop database $1 >> $HOME/nsesample_cleanup.log
 db2 drop database $1 >> $HOME/nsesample_cleanup.log
fi


 # *********************************************************************
 # Inform user
 # *********************************************************************
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "Finished nsesample_cleanup.script ***                             ">> $HOME/nsesample_cleanup.log
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "**********************************************************">> $HOME/nsesample_cleanup.log
echo "Check $HOME/nsesample_cleanup.log for execution information."

 #**********************************************************************
 #*** End of DB2 Net Search Extender sample 'nsesample_cleanup'
 #**********************************************************************
