Example 19C: Recovery after the space extend problem has been fixed

( BMC.DB2.SPE2110 )

The following third example recovery step illustrates the recovery of the space after the space extend problem has been resolved. The same step is illustrated in Example 19B, but with RESTART option. Before running this step, the space problem has been fixed by issuing the ALTER command to alter PRIQTY and SECQTY values.

//AFREX19C EXEC PGM=AFRMAIN,                                  
//         PARM='&SSID,&SYSUID..AFREX19,RESTART,MSGLEVEL(2)', 
//         REGION=0M                                          
//STEPLIB  DD DISP=SHR,DSN=&BMCLINK                           
//         DD DISP=SHR,DSN=&DB2EXIT                           
//         DD DISP=SHR,DSN=&DB2LOAD                           
//SYSPRINT DD SYSOUT=*                                        
//SYSOUT   DD SYSOUT=*                                        
//SYSERR   DD SYSOUT=*                                        
//SYSUDUMP DD SYSOUT=*                                        
//AFRDBG   DD DUMMY                                           
//SYSIN    DD *                                               
     OPTIONS ON ERROR CONTINUE 2                              
     RECOVER TABLESPACE BMCDBSMP.BMCTS001                     
     REBUILD INDEX(ALL) TABLESPACE BMCDBSMP.BMCTS001          
     RECOVER TABLESPACE BMCDBSMP.BMCTS002                     
     REBUILD INDEX(ALL) TABLESPACE BMCDBSMP.BMCTS002          
     RECOVER TABLESPACE BMCDBSMP.BMCTS003                     
     REBUILD INDEX(ALL) TABLESPACE BMCDBSMP.BMCTS003          
/*                                                                 

The following examples show the output produced by running this step:

• AFRERR
• AFRSUMRY

Example—AFRERR output after the space extend problem has been fixed

The following AFTER output shows that after the space extend problem has been fixed, the objects have been recovered with no error:

BMC40018I BMC AMI Recover for Db2 V12.1.00    (AFREX19C AFRERR)                                                              
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2021                                                                              
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 
7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070                                                            
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM                                                  
                                                                                                                             
BMC40970W COPY REQUIRED FOR OBJECT                                                                                           
BMC40345W    SPACE = BMCDBSMP.BMCIX001                                                                                       
BMC40305W       DSNUM = 1                                                                                               

Example—AFRSUMRY output after the space extend problem has been fixed

Messages BMC40476I and BMC40477 in the following AFRSUMRY output show that previously failed objects have been recovered successfully using the RESTART option. 

BMC40018I BMC AMI Recover for Db2 V12.1.00    (AFREX19C AFRSUMRY)                                                            
BMC40473I COPYRIGHT BMC SOFTWARE INC. 1991-2021                                                                              
BMC96173I BMC AMI Recover TECHNOLOGY IS PROTECTED BY U.S. PATENTS 7,133,884 7,769,718 
7,933,927 8,161,001 8,671,076 8,818,949
          8,843,449 9,152,659 9,753,811 10,366,074 AND 10,565,070                                                            
BMC40474I CONTACT BMC SUPPORT AT 1-800-537-1813 OR EMAIL TO SUPPORT@BMC.COM                                                  
                                                                                                                             
BMC40001I UTILITY EXECUTION STARTING 02/03/2021 03:15:25                                                                     
                                                                                                                             
                                                                                                                                                                                                     
BMC40002I UTILITY ID = AFREX19. DB2 SUBSYSTEM ID = DEJM.                                                                     
BMC40094I ATTEMPTING TO CONNECT TO DB2 SUBSYSTEM DEJM, USING PLAN AFR1211T                                                   
BMC40024I SUCCESSFUL CONNECT TO DEJM (RELEASE 1210 OF DB2) USING PLAN AFR1211T                                               
                                                                                                                             
BMC40475I INPUT STATEMENTS PRINTED IN AFRSTMT                                                                                
                                                                                                                             
BMC40336I ANALYZE FINISHED.                                                                                                  
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00                                                      
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00                                                      
BMC96414I      ZIIP TIME    = 00:00:00, UTILITY ZIIP TIME    = 00:00:00                                                      
BMC96415I      ZIIP ON CP   = 00:00:00, UTILITY ZIIP ON CP   = 00:00:00                                                      
BMC40336I PLANNING FINISHED. 
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:00  
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00  
BMC96414I      ZIIP TIME    = 00:00:00, UTILITY ZIIP TIME    = 00:00:00  
BMC96415I      ZIIP ON CP   = 00:00:00, UTILITY ZIIP ON CP   = 00:00:00  
BMC40336I PLAN EXECUTION FINISHED.                                       
BMC40287I      ELAPSED TIME = 00:00:00, UTILITY ELAPSED TIME = 00:00:01  
BMC40288I      CPU TIME     = 00:00:00, UTILITY CPU TIME     = 00:00:00  
BMC96414I      ZIIP TIME    = 00:00:00, UTILITY ZIIP TIME    = 00:00:00  
BMC96415I      ZIIP ON CP   = 00:00:00, UTILITY ZIIP ON CP   = 00:00:00  
                                                                         
BMC40476I EXECUTION SUMMARY                                              
BMC40477I      TABLE SPACES (PARTITIONS) RECOVERED   :  1 (1)            
BMC40480I      INDEXES (PARTITIONS) REBUILT          :  1 (1)            
                                                                         
BMC40005I UTILITY EXECUTION COMPLETE 02/03/2021 03:15:26, RETURN CODE = 4