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
 

 

To load DB2 table from Image copy

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

Active User


Joined: 18 Jun 2007
Posts: 208
Location: Cochin/Kerala/India

PostPosted: Thu Jun 21, 2012 8:52 pm    Post subject: To load DB2 table from Image copy
Reply with quote

Hi All,

Is any way to load a tables from the image copy dataset.Also wanted to know that whether we can convert image copy dataset to loadfile format

Regards,
Bipin Peter.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Jun 21, 2012 8:55 pm    Post subject:
Reply with quote

The manuals for the load and unload utilities that your shop uses -- whether IBM, BMC, or other -- will explain the process; read them.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 21, 2012 9:34 pm    Post subject:
Reply with quote

Hello,

Kinda pedestrian, but works:

Reload from the image copy (into a testing area). Unload the data into the format you want.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Fri Jun 22, 2012 12:27 am    Post subject:
Reply with quote

The UNLOAD utility (not to be confused with DSNTIAUL, which is not a utility), can process an image copy data set in lieu of a real table space. See the DB2 Utilities manual for details.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 22, 2012 1:49 am    Post subject: Reply to: To load DB2 table from Image copy
Reply with quote

Hi Don,

I have no idea Why, but several places i've been are reluctant to work with the Image Copy data. . .

Thoughts? Might this just be an unwillingness to learn a "newtrick" icon_confused.gif

Thanks,

d
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 685
Location: Earth

PostPosted: Fri Jun 22, 2012 2:16 am    Post subject:
Reply with quote

Dick, I find the analogy between IDCAMS EXPORT and DB2 IMAGECOPY to be the reason..

Everyone loves REPRO and EXPORT is seldom used. Similarly,
Everyone loves UNLOAD and IMAGECOPY is not that common.. icon_smile.gif
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Fri Jun 22, 2012 6:26 am    Post subject: Re: Reply to: To load DB2 table from Image copy
Reply with quote

dick scherrer wrote:
Hi Don,

I have no idea Why, but several places i've been are reluctant to work with the Image Copy data. . .

Thoughts? Might this just be an unwillingness to learn a "newtrick" icon_confused.gif

Thanks,

d
That may be true, but another possibility is that image copy unloads have some restrictions. For one, the unload has to be executed on the same DB2 subsystem that created the image copy. You also must have Select authority on the table in order to perform the unload, and the table has to exist in the catalog. So, unfortunately you cannot just grab an IC data set from Production and unload it in your test system.

Personally, I like using image copies in test environments. IC Backup and recovery is much faster than unload and load. And it opens up the possibility of using the Quiesce utility to manage recovery points.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 22, 2012 7:15 am    Post subject: Reply to: To load DB2 table from Image copy
Reply with quote

Thanks guys i appreciate it icon_smile.gif

d
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 5 Fri Dec 02, 2016 9:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am


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