#------------------------------------------------------------------------------- 
# Function to recycle the DB2 instance.                                          
# Arguments: $1 dbalias, $2 Korn shell set debug switch (+x = off, -x = on). 
#------------------------------------------------------------------------------- 

RECYCLE_DB2()                                                               
{                                                                                
 set "$2"                                                             
 print "\n_________________________"                                                             
 print "Stopping and starting DB2."                                      
 EXISTENCE_TEST "db2stop" "$2"                                        
 EXISTENCE_TEST "db2start" "$2"                                       
 db2 -v "DEACTIVATE DB ${1}"                                                
 db2 -v "db2stop FORCE"                                                          
 wait                                                                            
 db2 -v "db2start"                                                               
 print "_________________________\n"                                                             
}                                                                                
