IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Use Copy Utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mox512

New User


Joined: 04 Feb 2024
Posts: 21
Location: united arab emirates

PostPosted: Thu Jul 18, 2024 6:30 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Fri Jul 19, 2024 1:18 pm
Reply with quote

You mean to load the data into another schema and then use it ?
Back to top
View user's profile Send private message
mox512

New User


Joined: 04 Feb 2024
Posts: 21
Location: united arab emirates

PostPosted: Sat Jul 20, 2024 10:19 pm
Reply with quote

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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2126
Location: USA

PostPosted: Sun Jul 21, 2024 12:15 am
Reply with quote

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
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2589
Location: Silicon Valley

PostPosted: Sun Jul 21, 2024 1:54 am
Reply with quote

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
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2589
Location: Silicon Valley

PostPosted: Sun Jul 21, 2024 1:58 am
Reply with quote

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
View user's profile Send private message
mox512

New User


Joined: 04 Feb 2024
Posts: 21
Location: united arab emirates

PostPosted: Sun Jul 21, 2024 2:08 am
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Sun Jul 21, 2024 2:11 am
Reply with quote

Use batch SPUFI with cursor option to select from subsystem A and load to SUBSYSTEM B.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts REASON 00D70014 in load utility DB2 6
No new posts Need COBOL COPY Help in MVS Environment COBOL Programming 4
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
No new posts DB2 Table - Image copy unload IBM Tools 2
Search our Forums:

Back to Top