#-------------------------------------------------------------------------------  
# Function to activate database.                                                  
# Deactivate the deadlock monitor which autostarts on database activation.        
# Arguments; $1 dbalias; $2 debug switch (ksh set: +x=off, -x=on). 
#-------------------------------------------------------------------------------  
                                                                                  
ACTIVATE_DATABASE()                                                               
{                                                                                 
 DBNAME=$1
 set "$2"                                                              
 print "\n_______________________"                                                              
 print "Activating DB2 database"                                                  
 db2 -v "ACTIVATE DB ${DBNAME}"                                                   
 CONNECT "$DBNAME" "$DEBUG_SWITCH"  # Call function to connect to database.       
 db2 -v "SET EVENT MONITOR db2detaildeadlock STATE = 0"                           
 db2 -v "COMMIT"                                                                  
 print "_______________________\n"                                                              
}                                                                                 
