Support #10899
[SCP ID :##5394##] : Cronjob for Housekeeping DB
Status: | Work Completed-End life cycle | Start date: | June 19, 2020 | ||
---|---|---|---|---|---|
Priority: | Normal | Due date: | |||
Assignee: | Zahir Abd Latif | % Done: | 90% | ||
Category: | - | Spent time: | - | ||
Target version: | - |
Description
Hi,
Kindly attend below request:
Request to create cronjob to delete previous day backup daily after 12PM in SACDA935.
Change to delete weekly at 12pm.
History
#1 Updated by Nurul Athira Abdul Rahim over 4 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2 Updated by Najmi Pasarudin about 4 years ago
- Description updated (diff)
#3 Updated by Najmi Pasarudin about 4 years ago
- Description updated (diff)
#4 Updated by Najmi Pasarudin about 4 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#5 Updated by Najmi Pasarudin about 4 years ago
- % Done changed from 0 to 90
#6 Updated by Najmi Pasarudin about 4 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
Issue:
In DB2 server, BSN requested to created cronjob to delete old backup file.
Finding:
In DB2 server, there is no cronjob to delete old backup file.
- Create DeleteDatabaseBackup java program
- In SIT db server, for user db2inst1, allow cronjob
- Copy DeleteDatabaseBackup java program to /home/db2inst1/cronjob
- Add cronjob
0 0 * * * /home/db2inst1/solo -port=2001 /home/db2inst1/cronjob/DeleteDatabaseBackup.sh
Note: Program will delete file in /home/db2inst1/backup that is 7 days old or older
#7 Updated by Nurul Athira Abdul Rahim about 4 years ago
- Status changed from Internal Testing to System Integration Test
#8 Updated by Nurul Athira Abdul Rahim about 4 years ago
- Status changed from System Integration Test to User Acceptance Test
#9 Updated by Najmi Pasarudin about 4 years ago
- Status changed from User Acceptance Test to Pending Review
Deployed Production on 23/07/2020
#10 Updated by Nurul Athira Abdul Rahim almost 4 years ago
- Status changed from Pending Review to Work Completed-End life cycle
- Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif