Support #10899

[SCP ID :##5394##] : Cronjob for Housekeeping DB

Added by Zahir Abd Latif over 4 years ago. Updated almost 4 years ago.

Status:Work Completed-End life cycleStart date:June 19, 2020
Priority:NormalDue 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.

Solution:
  1. Create DeleteDatabaseBackup java program
  2. In SIT db server, for user db2inst1, allow cronjob
  3. Copy DeleteDatabaseBackup java program to /home/db2inst1/cronjob
  4. 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

Also available in: Atom PDF