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
 

 

How to make the FLASHCOPY result operational?

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

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Tue Sep 18, 2012 7:40 pm    Post subject: How to make the FLASHCOPY result operational?
Reply with quote

now I have a FLASHCOPY result of table TA, how can I operate on the result dataset/volumns if I want to access the data?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8055
Location: East Dubuque, Illinois, USA

PostPosted: Tue Sep 18, 2012 7:48 pm    Post subject:
Reply with quote

Terminology is critical in IT, where similar terms may mean very different things. When you say "result dataset..." do you mean the source or target volumes (to use IBM terms from the Flashcopy documentation)?

If you mean "target" when you said "result dataset...", you need to go to this web site IBM Redbooks and spend some time reading up on what Flashcopy is and how it works since you have no clue about Flashcopy.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Sep 21, 2012 1:41 pm    Post subject:
Reply with quote

hi, Robert,
when I said "result dataset...", I mean "target" of FlashCopy.

When I use the FlashCopy COPY command to backup the original database A to target volumes, in order to make the target datasets on the target volumes operational , I want to do below steps:
1. I create a seperate database , let's say, B, whose tables have exactly the same names and definitions as the original database A.
2. I STOP database B before Flashcopy is executed, and delete all the LDS VSAM datasets that belong to database B.
3. when I execute FlashCopy, I choose the volumes where database B resides as the target.
4. after Flashcopy Completes, I START database B.

I wonder if database B will have exactly the same data with database A and can be accessed via SQL statement immediately after FlashCopy completes.

As there is no FlashCopy available in my test environment , I cannot get the answer through my own test.

Many thanks for your advice!
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1787
Location: UK

PostPosted: Fri Sep 21, 2012 4:05 pm    Post subject:
Reply with quote

If you have no FlashCopy in test then what is the problem as you should not have it in production as you do not put stuff into production without testing on the test system first.
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
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 4 Sun Mar 12, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
This topic is locked: you cannot edit posts or make replies. How to run and see the result of DFH$... lind sh CICS 2 Wed Jul 27, 2016 7:04 pm


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