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

DB2 Table - Image copy unload


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

New User


Joined: 09 May 2023
Posts: 17
Location: Norway

PostPosted: Tue May 09, 2023 5:44 pm
Reply with quote

Hi,

Table X was dropped by user and I found it after couple of days due to job abend. At that point in order to fix the job abend, I defined the table and load them with some relevant old unload file
But later I found out the respective image copy for the table. Now then, I am trying to unload data from the image copy it says the below error message.



DSNU253I 129 12:03:51.02 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLE
DSNU252I 129 12:03:51.02 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE A.B
DSNU1408I 129 12:03:51.02 DSNUUNLD - SOURCE DATA SET (Imagecopy Dataset) DOES NOT MATCH TABLESPACE A.B


DSNU1408I - www.ibm.com/support/pages/apar/PK56556

Please suggest some ideas how to tackle this situation.


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

Senior Member


Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania

PostPosted: Tue May 09, 2023 9:45 pm
Reply with quote

Get this user fired, and inform the auditors that your system is just as "secure" as MS DOS in the 1980'ies.
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 582
Location: London

PostPosted: Thu May 11, 2023 11:41 am
Reply with quote

Not sure what you're asking for here. You say you redefined the deleted table and loaded it from an image copy, so did that load indicate it had restored any data or not? And was that image copy the same one you now says has no records in it?
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 -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top