IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Data Backup suggestions


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
germanyrajesh

New User


Joined: 09 May 2023
Posts: 17
Location: Norway

PostPosted: Sun May 21, 2023 11:01 am
Reply with quote

Hi all,

I am working on building a new application in the Mainframe Environment.

1. How to decide frequency of the backup (DB2) ? What type of data backup required and its retention period ?

2. How to develop procedures for handling all planned and unplanned outages affecting the database environment ?

Thanks
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 420
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Sun May 21, 2023 6:15 pm
Reply with quote

Is this your first time doing such a task?

Can you model your efforts on an existing, well documented application that does it properly?
Back to top
View user's profile Send private message
germanyrajesh

New User


Joined: 09 May 2023
Posts: 17
Location: Norway

PostPosted: Sun May 21, 2023 6:44 pm
Reply with quote

dneufarth wrote:
Is this your first time doing such a task?

Can you model your efforts on an existing, well documented application that does it properly?



*****************

Yes, this is the first time.

Oh yeah, I am trying to get reference from existing applications. However, trying to find source (standard documents or url) to understand the basics.
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 420
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Mon May 22, 2023 6:48 am
Reply with quote

Generally tech support should have a DB2 backup established. Disaster recovery backup/restore needs should be considered as well.

Specific needs for daily/weekly/monthly et al are based upon the online/batch activities and must be considered as to how do you recover/rerun when system/program/job failures occur.

Very general suggestions.

Ask your cohorts or other developers/teams at your site.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Wed May 24, 2023 8:12 am
Reply with quote

You need to check the job scheduling and identify the processes that updates the db2 tables and then have a before and after back up as per the criticality’s of the updates.

You need a full back up for at least have 30 GDGs.
Back to top
View user's profile Send private message
germanyrajesh

New User


Joined: 09 May 2023
Posts: 17
Location: Norway

PostPosted: Wed May 24, 2023 1:54 pm
Reply with quote

Thank you all for your valuable suggestions
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts db2 vs static data COBOL Programming 1
No new posts External data queue (changes?) CLIST & REXX 0
No new posts Pull data using date difference betwe... DB2 6
No new posts fast data scrambling PL/I & Assembler 10
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
Search our Forums:

Back to Top