View previous topic :: View next topic
|
Author |
Message |
saurabh39 Warnings : 1 Active User
Joined: 11 Apr 2008 Posts: 144 Location: Jamshedpur
|
|
|
|
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 |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
DSN1COPY ?
LOAD from Imagecopy ? |
|
Back to top |
|
|
saurabh39 Warnings : 1 Active User
Joined: 11 Apr 2008 Posts: 144 Location: Jamshedpur
|
|
|
|
@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 |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
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 |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
Is that relevant for this topic? I recon the OT requested advice on load/unload methods, not setting up selection criteriae. |
|
Back to top |
|
|
|