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> | ||
| + | |||