Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    72

    Unanswered: 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

  2. #2
    Join Date
    Apr 2007
    Location
    Chicago
    Posts
    68
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •