If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Urgent request: Db2 on Z/OS - How can a recovered tocopy tablespace be empty?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-07-07, 22:29
pagwu pagwu is offline
Registered User
 
Join Date: Mar 2007
Posts: 70
Urgent request: Db2 on Z/OS - How can a recovered tocopy tablespace be empty?

Hi all, I am running a recover tocopy procedure and twice with different image copy I found this informational message AND no data recovered:

DSNUCBAL - THE IMAGE COPY DATA SET DPDD.IMAG.ANG00001.TS00011S.G0118
IS PARTICIPATING IN RECOVERY OF TABLESPACE ANG00001.TS00011S
DSNUCBMD - MERGE STATISTICS FOR TABLESPACE ANG00001.TS00011S -
NUMBER OF COPIES=1
NUMBER OF PAGES MERGED=154543
ELAPSED TIME=00:02:57
DSNUCARS - INDEX IS ANG00001.TS00011S IN REBUILD PENDING
DSNUCARS - ALL INDEXES OF ANG00001.XPK00011 ARE IN REBUILD PENDING
DSNUCATM - DB2 OBJECT RECOVERED TO AN INDETERMINATE POINT
DSNUCBDR - RECOVERY COMPLETE, ELAPSED TIME=00:02:58
DSNUGUTC - REBUILD INDEX(ALL) TABLESPACE
DSNUCRUL - INDEX NAME= ANG00001.XPK00011 IS EMPTY
DSNUCRUL - TABLESPACE ANG00001.TS00011S IS EMPTY

I have never come across this before. Could someone tell me what is going on here? Empty backup copies? Is that possible? How can I tell if I have data on a backup copy?

Thanks
Reply With Quote
  #2 (permalink)  
Old 10-08-07, 09:37
jsharon1248 jsharon1248 is offline
Registered User
 
Join Date: Apr 2007
Location: Chicago
Posts: 57
To see what's on the Image Copy, you can run an Unload utility or the DSN1PRNT stand alone utility. Each accepts an Image Copy as input.

HTML Code:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugj14/2.30?DT=20061211173328
HTML Code:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugj14/3.10?DT=20061211173328
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On