Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Utility for Copying Data from one region to another

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
saurabh39
Warnings : 1

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Mon Jan 03, 2011 3:57 pm    Post subject: DB2 Utility for Copying Data from one region to another
Reply with quote

Hi,

I have a requirement of copying data from one region of db2 to another region.

I cannot use the normal unload and load method, as the data involved is very huge. Also, I need to do this for atleast 25-30 tables.

I need to know, whether we have any Db2 utility for accomplishing this task.

DB2 version is 7.2 and OS is Z/OS.
Back to top
View user's profile Send private message

Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Mon Jan 03, 2011 7:22 pm    Post subject:
Reply with quote

The internal DBA section in my organisation always recommend unload/load method when we have to move large amounts of data from one table to another in batch operations.

Are you thinking of a real-time "mirroring" of data instead?

As psychic week was last year, no one here can tell if you have a utility that can do what you want, you will have to ask your own support organisation (DBA). Even if someone here could come up with suggestions on tools to use, being IBM-supplied or by some 3rd party vendor, you still have to confirm internally if it can be used for regular production tasks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jan 03, 2011 9:36 pm    Post subject:
Reply with quote

Hello,

Quote:
I cannot use the normal unload and load method, as the data involved is very huge.
Well, this is rather contradictory. . .

Unload/Load is the typical method to copy large amounts of data from one database environment to another. . .

Why do you believe this is not the way for you to proceed?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Jan 04, 2011 2:54 pm    Post subject:
Reply with quote

DSN1COPY ?
LOAD from Imagecopy ?
Back to top
View user's profile Send private message
saurabh39
Warnings : 1

Active User


Joined: 11 Apr 2008
Posts: 144
Location: Jamshedpur

PostPosted: Tue Jan 04, 2011 3:17 pm    Post subject: Reply to: DB2 Utility for Copying Data from one region to an
Reply with quote

@Dick -
Quote:
Well, this is rather contradictory. . .

We have a internal unload/load method(IKJEFT01) created for development team, but its quite time consuming.And i was refering to this method.

My requirement is - I want to test my production data with the changed code. For that I need to move one day's data to test(the total transaction which has happened on one particular day).

IKJEFT01 Loading/Unloading will be very time consuming. So i was looking for alternative.

As for going to DBA, actually i wanted to have a concrete idea before asking for help.Thats the reason I knocked this forum.

@GuyC - Thanks for input, I will look into DSN1COPY and Load from imagecopy.
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Jan 04, 2011 3:54 pm    Post subject: Re: Reply to: DB2 Utility for Copying Data from one region t
Reply with quote

saurabh39 wrote:

IKJEFT01 Loading/Unloading will be very time consuming. So i was looking for alternative.

IKJEFT01 is not a particular DB2 utility. It is just a utility to create a batch TSO environment in which you can run TSO routines in the background.
The unload/load utilities are then executed in the TSO environment which induces additional overhead.

I would suggest that you should execute the unload/load utility programs directly from JCL.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue Jan 04, 2011 6:26 pm    Post subject: Re: Reply to: DB2 Utility for Copying Data from one region t
Reply with quote

Kjeld wrote:
saurabh39 wrote:

IKJEFT01 Loading/Unloading will be very time consuming. So i was looking for alternative.

IKJEFT01 is not a particular DB2 utility. It is just a utility to create a batch TSO environment in which you can run TSO routines in the background.

I beg to differ; IKJEFT01 is not a utility, it is TSO. If you're looking to create a TSO environment without actually running TSO, use IKJTSOEV.

I also recommend against invoking background TSO using the IKJEFT01 entry point; the IKJEFT1B entry point gives error handling more appropriate, IMNSHO, to batch processing.
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Jan 04, 2011 6:34 pm    Post subject:
Reply with quote

I agree on that, sorry for having used wrong terminology.

But my point was: Loose the TSO overhead alltogether, DB2 utilities are perfectly capable of being executed as independent batch programs.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue Jan 04, 2011 6:38 pm    Post subject:
Reply with quote

Kjeld wrote:
I agree on that, sorry for having used wrong terminology.

But my point was: Loose the TSO overhead alltogether, DB2 utilities are perfectly capable of being executed as independent batch programs.

And I agree on that icon_smile.gif
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Jan 04, 2011 6:52 pm    Post subject: Re: Reply to: DB2 Utility for Copying Data from one region t
Reply with quote

saurabh39 wrote:
My requirement is - I want to test my production data with the changed code. For that I need to move one day's data to test(the total transaction which has happened on one particular day).


How are you going to identify one day's data?
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Tue Jan 04, 2011 7:22 pm    Post subject:
Reply with quote

Is that relevant for this topic? I recon the OT requested advice on load/unload methods, not setting up selection criteriae.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Unwrap the data based on delimiter X'25' bhavana yalavarthi DFSORT/ICETOOL 30 Fri Dec 09, 2016 10:25 am
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us