| View previous topic :: View next topic |
| Author |
Message |
adutta24
Beginner
Joined: 02 Dec 2009
Posts: 3
Topics: 1
|
 Posted: Thu Dec 03, 2009 10:22 am Post subject: IMS database merge |
 |
|
Hi,
We have a requirement wherein we have to merge data belonging to IMS database present in two places into one one IMS database.
Do we have utilities to do this wherin we can run unload from both the places, then another utility to merge and then upload into the new database.
Please note that the structure of both the databases is similar.
Please help
Regards,
Abhishek |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12370
Topics: 75
Location: San Jose
|
| Posted: Thu Dec 03, 2009 11:28 am Post subject: |
|
|
adutta24,
1. Unload both databases
2. Use SORT to merge the unload files on the key
3. Reload it back
Kolusu |
|
| Back to top |
|
|
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Thu Dec 03, 2009 2:17 pm Post subject: Re: IMS database merge |
|
|
| adutta24 wrote: | | Please note that the structure of both the databases is similar. |
Similar or same? Remember -- you're talking about hierarchical database. And IMS is positional, it'll bite if the structure is not just same.
_________________
Regards,
Anuj |
|
| Back to top |
|
|
Terry_Heinze
Supermod
Joined: 31 May 2004
Posts: 391
Topics: 4
Location: Richfield, MN, USA
|
| Posted: Thu Dec 03, 2009 9:33 pm Post subject: |
|
|
I think Abhishek is saying that the input and output data bases are both IMS.
_________________
....Terry |
|
| Back to top |
|
|
Anuj Dhawan
Intermediate
Joined: 19 Jul 2007
Posts: 298
Topics: 7
Location: Mumbai,India
|
| Posted: Fri Dec 04, 2009 3:09 am Post subject: |
|
|
| Terry_Heinze wrote: | | I think Abhishek is saying that the input and output data bases are both IMS |
If so, then the usage of word "one" is misleading | Quote: | | We have a requirement wherein we have to merge data belonging to IMS database present in two places into one one IMS database. |
What I get is: There are 3 databases involved here, let's say they are old1, old2 and new1. old1 and old2 are of same (similar?) structure and he wants to combine these two into new1.
Well, enough about guessing today...
_________________
Regards,
Anuj |
|
| Back to top |
|
|
adutta24
Beginner
Joined: 02 Dec 2009
Posts: 3
Topics: 1
|
| Posted: Fri Dec 04, 2009 4:39 am Post subject: |
|
|
| I have IMS databases T1 and T2, and I need to get one database T1 after merging T1 and T2 |
|
| Back to top |
|
|
adutta24
Beginner
Joined: 02 Dec 2009
Posts: 3
Topics: 1
|
| Posted: Fri Dec 04, 2009 5:01 am Post subject: |
|
|
| Quote: |
1. Unload both databases
2. Use SORT to merge the unload files on the key
3. Reload it back
|
For Unload I am using DFSURGU0.
Now I am not able to read and understand the format of the unloaded file
[code:1:274d5be57b]. |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
