net localgroup administrators Domain\UserName /add

net localgroup administrators Domain\UserName /delete

Insert into Activity values (NEWID(),”,’2005-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2006-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2007-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2008-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2009-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2010-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2011-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2012-01-01′,’user1′)
Insert into Activity values (NEWID(),”,’2013-01-01′,’user1′)

SELECT * FROM sys.partitions WHERE OBJECT_ID = OBJECT_ID(‘Activity’)

#!/bin/bash
#****************************************************************************/
#* Title/Release : ExpireTSMDB2Backup.sh */
#* Program Name : ExpireTSMDB2Backup */
#* Application : #* Programmer : Harry Zheng */
#* Date Written : 13 Dec 2007 */
#* Function : This program will expire DB2 backup from TSM */
#* Inputs : DB2INSTANCENAME */
#* DBNAME */
#* DBPARTITIONNUM */
#* BACKUP_KEEP_DAYS */
#* Outputs : log file */
#* Language : bash */
#* Dependencies : Runs under linux */
#* Called by : crontab */
#* Calls to : none */
#* Change History */
#* Date User Description */
#* ———– ——— ————————————————*/
#* 13 Dec 2007 hzheng Created */
#* */
#****************************************************************************/

if [[ $# -lt 4 ]]; then
echo “USAGE: ExpireTSMDB2Backup.sh DB2INSTANCENAME DBNAME DBPARTITIONNUM BACKUP_KEEP_DAYS”
echo ” ”
exit 2
fi

DB2INSTANCENAME=$1
DBNAME=$2
DBPARTITIONNUM=$3
BACKUP_KEEP_DAYS=$4

if [[ $BACKUP_KEEP_DAYS -lt 3 ]]; then
$BACKUP_KEEP_DAYS = 3
fi

. /db2home/$DB2INSTANCENAME/.profile

BACKUP_DIR=/db2home/”$DB2INSTANCENAME”/sqllib/db2dump/backup_logs
DATE=`/bin/date +%Y%m%d_%H%M%S`
LOG=$BACKUP_DIR/ExpireTSMDB2Backup_”$DB2INSTANCENAME”_”$DBNAME”_”$DBPARTITIONNUM”_$DATE.log

echo “**********************************************************************************************” >> $LOG
echo “Query Full backup before deletion.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl query full db $DBNAME dbpartitionnum $DBPARTITIONNUM " >> $LOG

echo “Delete Full backup.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl delete full older than $BACKUP_KEEP_DAYS days db $DBNAME dbpartitionnum $DBPARTITIONNUM without prompting " >> $LOG

echo “Query Full backup after deletion.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl query full db $DBNAME dbpartitionnum $DBPARTITIONNUM " >> $LOG
echo “Finished deleting Full backup.” >> $LOG

echo “**********************************************************************************************” >> $LOG
echo “Query Logs backup before deletion.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl query logs db $DBNAME dbpartitionnum $DBPARTITIONNUM " >> $LOG
OLDEST_LOG=$(db2_all “< <+$DBPARTITIONNUM< db2adutl query full NONINCREMENTAL db $DBNAME dbpartitionnum $DBPARTITIONNUM "|grep Oldest |tail -1|awk '{print $6}'|cut -c2-8)
#echo "OLDEST_LOG is $OLDEST_LOG" >> $LOG
OLDEST_LOG=`expr $OLDEST_LOG – 1`
OLDEST_LOG=$(printf “%07d” $OLDEST_LOG)
OLDEST_LOG=”S$OLDEST_LOG.LOG”

echo “Delete Logs backup.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl delete logs between S0000000 and $OLDEST_LOG db $DBNAME dbpartitionnum $DBPARTITIONNUM without prompting " >> $LOG

echo “Query Logs backup after deletion.” >> $LOG
db2_all “< <+$DBPARTITIONNUM< db2adutl query logs db $DBNAME dbpartitionnum $DBPARTITIONNUM" >> $LOG

echo “Finished deleting Logs backup.” >> $LOG

echo “**********************************************************************************************” >> $LOG
echo “Cleanup job completed.” >> $LOG
exit 0