This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
deploy:ibm_ilmt_upgrade [2024/06/18 17:48] manu [Install ILMT] |
deploy:ibm_ilmt_upgrade [2025/08/23 23:18] (current) |
||
---|---|---|---|
Line 126: | Line 126: | ||
</cli> | </cli> | ||
- | <fc #ff0000>To satisfy db2precheck, I've created a new LV for /tmp, and just overmount (no entry into /etc/fstab)</fc> | + | **To satisfy db2precheck, I've created a new LV for /tmp, and just overmount (no entry into /etc/fstab)** |
==== Downloading the BigFix installer for Linux ==== | ==== Downloading the BigFix installer for Linux ==== | ||
Line 837: | Line 837: | ||
Check Database version | Check Database version | ||
- | <cli prompt='#'> | + | <cli prompt='$'> |
[db2inst1@BIGFIX01 ~]$ db2 list database directory | [db2inst1@BIGFIX01 ~]$ db2 list database directory | ||
Line 897: | Line 897: | ||
1 record(s) selected. | 1 record(s) selected. | ||
</cli> | </cli> | ||
+ | |||
+ | ===== Script to backup DB2 ===== | ||
+ | |||
+ | As root | ||
+ | <cli prompt='#'> | ||
+ | [root@BIGFIX01 scripts]# cat bigfix_backup.sh | ||
+ | </cli> | ||
+ | <code> | ||
+ | #!/usr/bin/ksh | ||
+ | #================================================================================== | ||
+ | # | ||
+ | # FILE: bigfix_backup.ksh | ||
+ | # | ||
+ | # PURPOSE: Backup BigFix + ILMT Server | ||
+ | # | ||
+ | # AUTHOR: | ||
+ | # | ||
+ | # PARAMETERS: | ||
+ | # | ||
+ | # SAMPLES: | ||
+ | # | ||
+ | #================================================================================== | ||
+ | # To check DB consistency | ||
+ | # [db2inst1@BIGFIX01 ~]$ /opt/ibm/db2/V11.5/bin/db2ckbkp -h /backup/TEMADB.0.db2inst1.DBPART000.20240618172214.001 | ||
+ | # Image Verification Complete - successful. | ||
+ | |||
+ | |||
+ | |||
+ | echo "**********************************" | ||
+ | echo "***** Stopping BigFix Server *****" | ||
+ | echo "**********************************" | ||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | /etc/init.d/LMTserver stop | ||
+ | for svc in besclient.service beswebreports.service besgatherdb.service besfilldb.service besserver.service | ||
+ | do | ||
+ | systemctl stop $svc | ||
+ | done | ||
+ | |||
+ | echo "**********************************" | ||
+ | echo "***** Removing old backups *****" | ||
+ | echo "**********************************" | ||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | rm -f /backup/BFENT* | ||
+ | rm -f /backup/BESREPOR* | ||
+ | rm -f /backup/TEMADB* | ||
+ | echo "**********************************" | ||
+ | echo "***** Backup DB2 to disk *****" | ||
+ | echo "**********************************" | ||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | echo "backup DB BFENT" | ||
+ | /usr/sbin/runuser -l db2inst1 -c "db2 backup db BFENT to /backup" | ||
+ | echo "backup DB BESREPOR" | ||
+ | /usr/sbin/runuser -l db2inst1 -c "db2 backup db BESREPOR to /backup" | ||
+ | echo "backup DB TEMADB" | ||
+ | /usr/sbin/runuser -l db2inst1 -c "db2 backup db TEMADB to /backup" | ||
+ | |||
+ | ### If error | ||
+ | #[root@BIGFIX01 backup]# /usr/sbin/runuser -l db2inst1 -c "db2 backup db TEMADB to /backup" | ||
+ | #SQL1035N The operation failed because the specified database cannot be | ||
+ | #connected to in the mode requested. SQLSTATE=57019 | ||
+ | #db2 connect to DBXX | ||
+ | #db2 quiesce database immediate force connections | ||
+ | #db2 connect reset | ||
+ | #db2 terminate | ||
+ | #db2 deactivate database DBXX | ||
+ | #db2 terminate | ||
+ | #db2 "backup database DBXX to /backup | ||
+ | |||
+ | echo "**********************************" | ||
+ | echo "***** Backup to TSM *****" | ||
+ | echo "**********************************" | ||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | # Here you can add backup to external source | ||
+ | echo "**********************************" | ||
+ | echo "***** Startting BigFix Server ****" | ||
+ | echo "**********************************" | ||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | for svc in besfilldb.service besgatherdb.service besserver.service beswebreports.service besclient.service | ||
+ | do | ||
+ | systemctl start $svc | ||
+ | done | ||
+ | /etc/init.d/LMTserver start | ||
+ | |||
+ | date '+%Y-%m-%d %H:%M:%S' | ||
+ | </code> | ||
+ |