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
 

 

About ImageCopy

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

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Sun May 16, 2010 8:18 am    Post subject: About ImageCopy
Reply with quote

Dear Experts,

One of the production job loaded the data into the Production DB2 Table and immediately taken the Imagecopy in the subsequent step.

Requirement:
I want to load the Imagecopy into the TEST DB2 Table. How to write the jcl, please help me.

But,
1) I don't have the READ access on the Production table. (It's a big process to get the READ access, as table belongs to other application)

2) The input that loads into the table gets deleted.

3) I have only left with the IMAGECOPY file. Which is in NON-READABALE format.

4) I want to load the Imagecopy into the respective TEST DB2 Table. Please give me a sample JCL.
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: Sun May 16, 2010 8:55 am    Post subject:
Reply with quote

Hello,

Work with the dba (or someone who has read access to those table(s)) to create a loadable sequential copy of the data that you have permission to read.

You will also need to have the dba set up your id so that you can load into the test database table(s) if you do not already have this. Many places restrict the use of the database utilities.
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Sun May 16, 2010 11:54 am    Post subject:
Reply with quote

Dear Dick,

You are absolutely correct.
I have already initiated the process to get the temporary READ access on those Production tables to continue my testing.

By this, at the worse case, I will get the READ Authorizations by Tuesday. Of Course the problem gets resolved.

But First time, I came across Image copies and it's a learning opportunity for me to explore about the Image copies.

I opinoned that, On Mainframe projects, a developer gets a Challenging tasks occassionally. this is of the same type as far as I'm concerned.

Please help me how to explore about Imagecopies.


Thanks in advance.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Sun May 16, 2010 5:20 pm    Post subject:
Reply with quote

Quote:
Please help me how to explore about Imagecopies.


RTFM
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: Sun May 16, 2010 9:07 pm    Post subject:
Reply with quote

Hello,

Quote:
Please help me how to explore about Imagecopies.
In this day of many silly things done in the name of "security", your "opportunity to explore" may be limited (depends on your organization). At one of my clients, i am not able to access Production tables or backup data.

You may have to settle (for now) using the manuals or lookkng for previous topics in the forum.

Depending on your projected "things to do" it may be a good time to have your management assign you additional permissions.
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 IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts DB2 Unload from imagecopy files using... mathi.vanan DB2 21 Thu Jan 19, 2012 1:44 pm
No new posts DB2 Imagecopy unload dharani.nagarajan DB2 15 Wed Sep 14, 2011 1:04 pm
No new posts Select or unload from old imagecopy? GuyC DB2 2 Fri Jan 28, 2011 9:24 pm
No new posts Unload from imagecopy dharani.nagarajan DB2 9 Tue Jan 25, 2011 4:12 pm


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