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
 

 

DB2 Imagecopy & Unload

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

New User


Joined: 29 Apr 2005
Posts: 21
Location: Gurgaon, India

PostPosted: Wed Jan 28, 2009 3:07 pm    Post subject: DB2 Imagecopy & Unload
Reply with quote

Hi,

I have a requirement to migrate data from prod table to dev table using a backup imagecopy. I tried 2 approached but both of them failed:

1. I tried Recover in dev table from imagecopy, but I got the error 'the recovery does not permit DSNUM(ALL) recovery'. This table is a non-partitioned table. What option should I use?

2. I also tried doing a Unload from imagecopy (giving PARM in the job for Dev DB2 system), but it returns error that 'content of imagecopy dataset are inconsistent with Dev tablespace'.

Any help with either of these method would be appreciated.

Thanks,
Rohin
Back to top
View user's profile Send private message

Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Jan 28, 2009 4:06 pm    Post subject:
Reply with quote

As it is nonpartioned, try to recover by removing DSNUM parameter.
Back to top
View user's profile Send private message
rohin

New User


Joined: 29 Apr 2005
Posts: 21
Location: Gurgaon, India

PostPosted: Wed Jan 28, 2009 4:19 pm    Post subject:
Reply with quote

I forgot to add, I did not have DSNUM parameter in my sysin card. I think it picked DSNUM(ALL) by default.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jan 28, 2009 7:51 pm    Post subject:
Reply with quote

Hi Rohin,

Quote:
I also tried doing a Unload from imagecopy (giving PARM in the job for Dev DB2 system), but it returns error that 'content of imagecopy dataset are inconsistent with Dev tablespace'.


Do you have access to production, if you do. You can unload from the prod backup image copy. You are unloading from production image copy give production sub-system ID in the JOB not development.
Unload it as a sequential file and Load it in the development and give the Development sub-system id.

Sushanth
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Wed Jan 28, 2009 11:54 pm    Post subject:
Reply with quote

Hi,

My experience differs a little here - I could not load the data from my "normal load jobs" I had to get in touch with my DBA who provided me with other JCL which did the trick - might be getting in contact with them cn help..
Back to top
View user's profile Send private message
jontyjun

New User


Joined: 12 Sep 2006
Posts: 12
Location: India

PostPosted: Mon Mar 02, 2009 12:17 am    Post subject:
Reply with quote

Hi DB2 Guy,

Saw ur post on the Copying Prod table to Dev Environment. You had told that your DBA gave a different JCl/card which solved your case. Can you let me know what changes did the DBA do to the card? Did they change the Object ID? What other changes?

Regards,
jonty
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 Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm
No new posts How to suppress retun code of partil ... mkk157 DB2 9 Fri May 27, 2016 6:59 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm


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