View previous topic :: View next topic
|
Author |
Message |
mox512
New User
Joined: 04 Feb 2024 Posts: 21 Location: united arab emirates
|
|
|
|
Hi every one
I Get a full copy of a table from my development environment and I need to use it in another subsystem where the same table and table space exist. I've looked into the Dsn1copy utilities but I'm unsure how to use them. Can anyone assist me?
Thank you |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3076 Location: NYC,USA
|
|
|
|
You mean to load the data into another schema and then use it ? |
|
Back to top |
|
|
mox512
New User
Joined: 04 Feb 2024 Posts: 21 Location: united arab emirates
|
|
|
|
No I think you made a mistake
I want use copy in another subsystem. for example I have 2 subsystem A & B.
and I have same table in subsystem A and B. now I get copy from sub A and I want use this copy at sub B. one solution is use dsn1copy utility. I read this utility and I don't know how can I use it. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2126 Location: USA
|
|
|
|
How do you understand the term “table” in this context?
What exactly (physically) needs to be moved from one system to another one?
How do you understand the term “utility”? Do you know this is a sort of a program? Do you know how a program can be used on mainframe? Did you find any example of its usage in the manual? Have you tried to run any of available samples on utility use?
Etc, etc, etc… |
|
Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2589 Location: Silicon Valley
|
|
|
|
My suggestion is to use the DB2 UNLOAD and LOAD utilities.
1. On subsystem A, use the UNLOAD utility. It will put comma delimited data into the SYSREC data set. Specify PUNCHDDN so that the SYSPUNCH file will have the LOAD statement that you need to use in step 3.
2. If you need to, move the SYSREC data set to the system where it is needed.
3. On subsystem B, use the LOAD utility. Use the same SYSREC data set that was created by the UNLOAD. Use the SYSPUNCH created by UNLOAD as the SYSIN for the LOAD utility.
fyi. If you have access to the DB2 Admin Tool, it will help you greatly to create the jobs required. |
|
Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2589 Location: Silicon Valley
|
|
|
|
re: I Get a full copy of a table from my development environment
I think much depends on how that copy was created. Please explain. |
|
Back to top |
|
|
mox512
New User
Joined: 04 Feb 2024 Posts: 21 Location: united arab emirates
|
|
|
|
I am compiling and researching how to backup. I want to make a backup of my system with a copy Utility that occupies less space. I want to know if I upgrade the DB 2 version, (for example upgrade v.11 to v.12), if this Full Copy can be reused or not, and I want to know if I have another environment exactly similar to this one, can I restore my copy on those tables without Unload utility? if possible How do I do this? |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3076 Location: NYC,USA
|
|
|
|
Use batch SPUFI with cursor option to select from subsystem A and load to SUBSYSTEM B. |
|
Back to top |
|
|
|