i dropped a table, then i tried to recover with TOLASTFULLCOPY option,
then i got rebuildpending, so i ran REBUILD INDEXSPACE TABLESPACE tablespace-name, which ran with MAXCC=0, but even after that data was not recovered.....suggest me a way to recover my table.
also suggest how to the the RBA required to recover using TORBA option.
when i ran my recover utility by using TORBA option, it gave MAXCC=0, but still data could not be recovered.the i again ran the utility with RECOVER and REBUILD INDEX(ALL) option, i got following message:
DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = UEDBS02.UEDBS02A
DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
DSNU050I DSNUGUTC - RECOVER TABLESPACE DEDBS01.EMPREC TOLASTFULLCOPY
DSNU1502I -DB2A DSNUCASA - RECOVER OF TABLESPACE DEDBS01.EMPREC WILL PROCEED T
DSNU515I DSNUCBAL - THE IMAGE COPY DATA SET UEDBS02.EMPLOC2 WITH DATE=2008071
IS PARTICIPATING IN RECOVERY OF TABLESPACE DEDBS01.EMPREC
DSNU504I DSNUCBMD - MERGE STATISTICS FOR TABLESPACE DEDBS01.EMPREC -
NUMBER OF COPIES=1
NUMBER OF PAGES MERGED=3
DSNU500I DSNUCBDR - RECOVERY COMPLETE, ELAPSED TIME=00:00:01
DSNU050I DSNUGUTC - REBUILD INDEX(ALL) TABLESPACE DEDBS01.EMPREC
DSNU718I -DB2A DSNUCINT - NO INDEXES FOUND FOR TABLESPACE 'DEDBS01.EMPREC'
DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
when i created table, i also created index, but after dropping and the recovery, its sayinf no indexes found.....what may be the reason, and what are the steps to be taken to recover my table