Db2 - L

 View Only

Recover PBG with REORG_DROP_PBG_PARTS=ENABLE

  • 1.  Recover PBG with REORG_DROP_PBG_PARTS=ENABLE

    Posted 6 days ago
    Hi all, 
    I have a specific question 
    On a DB2 for z/OS v12R500 Test system we have REORG_DROP_PBG_PARTS=ENABLE

    I Have a PBG table that had 24 million rows and 3 data sets (partitions)
    GEBUDB.DSNDBD.DBTEST.EBPTSREC.I0001.A001
    GEBUDB.DSNDBD.DBTEST.EBPTSREC.I0001.A002
    GEBUDB.DSNDBD.DBTEST.EBPTSREC.I0001.A003

    and we made the following actions

    1. Copy table with DSNUPROC per part (3 data set backup)              GEBUCP.TAPESB30.FC1.TSU.EBPTSREC.P001.F0617
                    GEBUCP.TAPESB30.FC1.TSU.EBPTSREC.P002.F0617
                    GEBUCP.TAPESB30.FC1.TSU.EBPTSREC.P003.F0617    
    2. Quiesce Tablespace
    3. Delete 23 million rows
    4. Reorganise full table (part 0 - shrlevel reference) with inline copy. So the remaining physical data set was 1 GEBUDB.DSNDBD.DBTEST.EBPTSREC.J0001.A001

    We tried to Recover Table to LOGPOINT that we took the QUIESCE (Step 2) and we had the following Abend
    DSNUCASA - RECOVER CANNOT PROCEED FOR TABLESPACE DBTEST.EBPTSREC DSNUM 2
    BECAUSE A SYSIBM.SYSCOPY RECORD HAS BEEN ENCOUNTERED WHICH HAS
    DBNAME=DBTEST TSNAME=EBPTSREC DSNUM=0 ICTYPE=A STYPE=X
    STARTRBA=X'0000000027484DF3A774' LOWDSNUM=2 HIGHDSNUM=3

    After that we ran ALTER TABLE ADD PARTITION to the table and added 2 partitions

    We reran the recover (only this time tofullcopy) and the following message appeared

    DSNUGUTC - RECOVER TABLESPACE DBTEST.EBPTSREC DSNUM 2 TOCOPY 'GEBUCP.TAPESB30.FC1.TSU.EBPTSREC.P002.F0617'
    DSNU519I * 173 13:16:53.03 DSNUCATO - TOCOPY DATASET NOT FOUND 

    So we realized that SYSIBM.SYSCOPY had the following rows for the Tablespace

    ---------+---------+---------+---------+---------+---------+---------+---------+
    DBNAME TSNAME DSNUM ICTYPE ICDATE START_RBA FILESEQNO   DEVTYP
    ---------+---------+---------+---------+---------+---------+---------+---------+
    DBTEST  EBPTSREC         0           F  220622   .....È(0èj                      1    3590-1
    DBTEST EBPTSREC           1            F 220621    .....ÁÐ.VÏ                      1    3590-1

    So SYSCOPY has the Backup after Reorg (Step 4) and backup for PART 1 only (Step 1)

    Is there any way to recover table to Step 2 (LOGPOINT) ? (we have the backup files on disk)

    Thanks in advance. 






    ------------------------------
    PetrosFountoulakisEUROBANK
    ------------------------------