Database Backup



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Database Backup

Postby danielmartyn » Tue Feb 20, 2018 5:30 pm

Hi all. I am new to this and have been given the task of:

Take a backup of the database
Copy the data out of the Near Archive dataset
Delete and re-define the dataset
Copy the data back in

Any help would be really appreciated.

I have been looking at REPRO. Am I going down the right avenue or am I completely off track?
danielmartyn
 
Posts: 3
Joined: Tue Feb 20, 2018 5:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Database Backup

 

Re: Database Backup

Postby enrico-sorichetti » Tue Feb 20, 2018 11:49 pm

Take a backup of the database

in IT jargon database has a very specific meaning... please clarify
Copy the data out of the Near Archive dataset

Your organisation jargon... please clarify

until You learn to post better structured question the chances of getting helpful replies will be pretty slim

and ...

copy something
delete redefine the something
copy back the thing

all over the world is called REORGANISATION not DATABASE BACKUP as per topic title
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2775
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 147 times

Re: Database Backup

Postby expat » Wed Feb 21, 2018 1:02 pm

The process that is required to REORGANISE the database / file structure depends entirely on the database / file structure being REORGANISED

DB2 differs from DL1 differs from SAS differs from ADABAS differs from ................... ad infinitum
Your shop may well have these procedures already in place, so pass one is to ask the relevant DBA / responsible about this
expat
 
Posts: 418
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 4 times

Re: Database Backup

Postby danielmartyn » Wed Feb 21, 2018 1:11 pm

Sorry for the vague post.

We have near archive datasets held in VSAM's that over time have grown but will have empty space in them.

The near archive is meaning that it is has been taken from the main storage and placed onto 'tape'.

I have been tasked with writing JCL to do as I previously posted.

Is this enough information for you?
danielmartyn
 
Posts: 3
Joined: Tue Feb 20, 2018 5:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Database Backup

Postby expat » Wed Feb 21, 2018 1:17 pm

VSAM datasets can hold DB2, DL1 and a variety of of other database structures

The most important thing that you can do is to find out the database structure before you even consider touching anything.
One wrong step and you could ruin a whole lot of stuff.

I had to recover umpteen DL1 databases because someone thought that an IDCAMS REPRO would work fine.
It did from a VSAM point of view, but the DL1 database was well and truly stuffed afterwards

These users thanked the author expat for the post:
danielmartyn (Wed Feb 21, 2018 1:18 pm)
expat
 
Posts: 418
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 4 times

Re: Database Backup

Postby danielmartyn » Wed Feb 21, 2018 1:38 pm

I have been informed that IDCAMS REPRO is fine to use.
danielmartyn
 
Posts: 3
Joined: Tue Feb 20, 2018 5:27 pm
Has thanked: 1 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post