Backup WP DB2 databases

curDate=`date +%d%m%y_DBs_WP615`
cd /opt/Backups/databases/temp

echo “Backing-up fdbkdb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db fdbkdb”
echo “Backing-up lmdb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db lmdb”
echo “Backing-up cusdb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db cusdb”
echo “Backing-up comdb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db comdb”
echo “Backing-up reldb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db reldb”
echo “Backing-up jcrdb into /opt/Backups/databases/temp directory…”
su – db2inst1 -c “db2 backup db jcrdb”

echo -e “nArchiving all the databases in /opt/Backups/databases/”$curDate
tar -cvf /opt/Backups/databases/$curDate.tar *

echo -e “nDeleting all the databases from /opt/Backups/databases/temp directory…n”
rm -f /opt/Backups/databases/temp/*.*

Advertisements

About Ishtiaque

I am IBM Certified Infrastructure Systems Architect, Linux Foundation Certified System Administrator, Oracle Certified Programmer in Java and Web Component Developer, and TOGAF 9 certified with over 10 years of support and development experience in IBM middleware software and Java. Additionally, have a sound grip in databases and OpenStack administration. I hold the following certifications: IBM Certified Infrastructure Systems Architect Linux Foundation Certified System Administrator (LFCS) TOGAF 9 Certified Oracle Certified Expert, Java EE6 Web Component Developer Oracle Certified Professional – Java 6 Programmer ITIL v3 Foundation Certified IBM Certified Solution Architect – Cloud Computing Infrastructure V1 IBM Certified System Administrator – WebSphere Portal V8, V7, V6.1, V6 IBM Certified System Administrator – WebSphere Application Server V7, V6.1 IBM Certified System Administrator – AIX V7 IBM Certified System Administrator – WebSphere MQ V7 IBM Certified Deployment Professional – Business Process Manager Advanced V7.5 IBM Certified Solution Advisor – Cloud Computing Architecture V3 IBM Certified Solution Developer – WebSphere Portal V5.1
This entry was posted in DB2, Linux, Scripts, WebSphere Portal. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s