Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see PACLOG for DB2 13.1.

Sample output for ALMBHST


(SPE2010)

This sections shows ALMBHST output samples.

The following is an example of ALMHISTR DD shows the job output reports about the content and formatted control record of history file for attached and specified SSID: 

********************************* TOP OF DATA *************************************************
                                                                                              
** PACLOG - V12.01.00 - BMC SOFTWARE, INC. ***** 03/02/2021 17:59:26 **                                           
                                                                                                                                                                        
----------------------------------SUBSYSTEM DEH5------------------------------------           
                                                                                              
LAST REFERENCE=03/02/2021 04:43:31                                                                    
DSN=MVSIBA.BMCALM.DEH5.HISTV4                                                                  
LRECL=216                                                                                      
BSDS=DEH5CAT.BSDS01                                                                            
Log entries=1721                                                                               
Most recent RBA=0000000000410EC96FFF DSN=DEH5CAT.ARCHLOG1.XT.D20342.T0320325.A0001746          
Oldest RBA=00000000000000000000                                                                
Restart RBA=00000000002C1DEB4FFF                                                               
                                                                                              
                                                                                              
PR=processed by ARMBARC or PACLOG                                                              
IX=index names filtered                                                                        
RT=record types filtered                                                                       
TS=tablespace names filtered                                                                   
                                                                                              
BMC80660I  1721 ARC  PR IX RT TS     RBA 0000000000410EB09000 - 0000000000410EC96FFF           
                 1    Y  N  N  N     DEH5CAT.ARCHLOG1.XT.D20342.T0320325.A0001746              
                 2    Y  N  N  N     DEH5CAT.ARCHLOG2.XT.D20342.T0320325.A0001746              
                 3    Y  N  N  N     MVSIBA.ARCHIVE3.D20342.T0320325.A0001746                  
                 4    Y  N  N  N     MVSIBA.ARCHIVE4.D20342.T0320325.A0001746                  
                                                                                              
BMC80660I  1720 ARC  PR IX RT TS     RBA 0000000000410E5BF000 - 0000000000410EB08FFF           
                 1    Y  N  N  N     DEH5CAT.ARCHLOG1.XT.D20342.T0320295.A0001745              
                 2    Y  N  N  N     DEH5CAT.ARCHLOG2.XT.D20342.T0320295.A0001745              
                 3    Y  N  N  N     MVSIBA.ARCHIVE3.D20342.T0320295.A0001745                  
                 4    Y  N  N  N     MVSIBA.ARCHIVE4.D20342.T0320295.A0001745                  
                                                                                              
BMC80660I  1719 ARC  PR IX RT TS     RBA 0000000000410E431000 - 0000000000410E5BEFFF           
                 1    N  N  N  N     DEH5CAT.ARCHLOG1.XT.D20328.T0045594.A0001744              
                 2    N  N  N  N     DEH5CAT.ARCHLOG2.XT.D20328.T0045594.A0001744   
...
...
...

                                                                                   
BMC80660I     3 ARC  PR IX RT TS     RBA 00000000000000566000 - 0000000000000056AFFF
                 1    N  N  N  N     DEH5CAT.ARCHLOG1.D14293.T1153473.A0000003      
                                                                                   
BMC80660I     2 ARC  PR IX RT TS     RBA 00000000000000561000 - 00000000000000565FFF
                 1    N  N  N  N     DEH5CAT.ARCHLOG1.D14293.T1151460.A0000002      
                                                                                   
BMC80660I     1 ARC  PR IX RT TS     RBA 00000000000000000000 - 00000000000000560FFF
                 1    N  N  N  N     DEH5CAT.ARCHLOG1.D14293.T1149184.A0000001   

DSNDB01 DBD01                                                   
NO BACKUPS FOUND                                                
                                                               
DSNDB06 SYSTSCPY BACKUPS                                        
RMD.DEH5.DSNDB06.SYSTSCPY.LP00.D23.T153521   06/23/2020 15:35:21
RMD.DEH5.DSNDB06.SYSTSCPY.RP00.D23.T153521   06/23/2020 15:35:21
RMD.DEH5.DSNDB06.SYSTSCPY.LP00.D04.T132939   08/04/2020 13:29:39
RMD.DEH5.DSNDB06.SYSTSCPY.RP00.D04.T132939   08/04/2020 13:29:39

                                                               
DSNDB01 SYSUTILX BACKUPS                                        
RMD.DEH5.DSNDB01.SYSUTILX.LP00.D23.T153425   06/23/2020 15:34:27
RMD.DEH5.DSNDB01.SYSUTILX.RP00.D23.T153425   06/23/2020 15:34:27
RMD.DEH5.DSNDB01.SYSUTILX.LP00.D04.T132826   08/04/2020 13:28:28
RMD.DEH5.DSNDB01.SYSUTILX.RP00.D04.T132826   08/04/2020 13:28:28

DSNDB01 SYSDBDXA BACKUPS                                        
RMD.DEH5.DSNDB01.SYSDBDXA.LP00.D23.T153434   06/23/2020 15:34:34
RMD.DEH5.DSNDB01.SYSDBDXA.RP00.D23.T153434   06/23/2020 15:34:34
RMD.DEH5.DSNDB01.SYSDBDXA.LP00.D04.T132836   08/04/2020 13:28:37
RMD.DEH5.DSNDB01.SYSDBDXA.RP00.D04.T132836   08/04/2020 13:28:37

----------------------------------SUBSYSTEM DEJM------------------------------------
                                                                                   
LAST REFERENCE=12/06/2020 10:24:24                                                         
DSN=BMCALM.DEJM.HISTV3                                                              
LRECL=216                                                                           
BSDS=DEJMCAT.BSDS01                                                                 
Log entries=10006                                                                   
Most recent RBA=000000001519CD072FFF DSN=DEJMCAT.ARCHLOG1.A0060702                  
Oldest RBA=000000001173E159A000                                                     
Restart RBA=000000001519E532AFFF                                                    
                                                                                   
                                                                                   
PR=processed by ARMBARC or PACLOG                                                   
IX=index names filtered                                                             
RT=record types filtered                                                            
TS=tablespace names filtered                                                        
                                                                                   
BMC80660I 10006 ARC  PR IX RT TS     RBA 000000001519B4DBB000 - 000000001519CD072FFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0060702                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0060702                      
                 3    Y  N  Y  N     ALM.DREXT.DEJML3.A0060702                      
                 4    Y  N  Y  N     ALM.DREXT.DEJML4.A0060702                      
                                                                                   
BMC80660I 10005 ARC  PR IX RT TS     RBA 0000000015199CB03000 - 000000001519B4DBAFFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0060701                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0060701                      
                 3    Y  N  Y  N     ALM.DREXT.DEJML3.A0060701                      
                 4    Y  N  Y  N     ALM.DREXT.DEJML4.A0060701                      
                                                                                   
BMC80660I 10004 ARC  PR IX RT TS     RBA 0000000015198484B000 - 0000000015199CB02FFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0060700                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0060700   
...
...
...

BMC80660I     3 ARC  PR IX RT TS     RBA 00000000117411B0A000 - 00000000117429DC1FFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0050699                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0050699                      
                                                                                   
BMC80660I     2 ARC  PR IX RT TS     RBA 000000001173F9852000 - 00000000117411B09FFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0050698                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0050698                      
                                                                                   
BMC80660I     1 ARC  PR IX RT TS     RBA 000000001173E159A000 - 000000001173F9851FFF
                 1    N  N  N  N     DEJMCAT.ARCHLOG1.A0050697                      
                 2    N  N  N  N     DEJMCAT.ARCHLOG2.A0050697                                         

DSNDB01 DBD01 BACKUPS                                           
RMD.DSNDB01.DBD01.LP190813.T145141           08/13/2019 14:51:42
RMD.DEJM.DSNDB01.DBD01.LP00.D13.T172233      08/13/2019 17:22:33
RMD.DEJM.DSNDB01.DBD01.RP00.D13.T172233      08/13/2019 17:22:33
ALP.MR.VR360.DSNDB01.DBD01.LP200306          03/06/2020 17:13:06
RMD.DSNDB01.DBD01.LP201014.T155337           10/14/2020 15:53:38
RMD.DSNDB01.DBD01.LP201125.T104341           11/25/2020 10:43:41

DSNDB06 SYSTSCPY BACKUPS                                        
RMD.DSNDB06.SYSTSCPY.LP190813.T145601        08/13/2019 14:56:03
RMD.DEJM.DSNDB06.SYSTSCPY.LP00.D13.T172707   08/13/2019 17:27:08
RMD.DEJM.DSNDB06.SYSTSCPY.RP00.D13.T172707   08/13/2019 17:27:08
ALP.QA.DEJM.DSNDB06.SYSTSCPY.G0001V00        10/29/2019 14:45:35
RMD.DSNDB06.SYSTSCPY.LP201014.T155734        10/14/2020 15:57:36
RMD.DSNDB06.SYSTSCPY.LP201125.T104748        11/25/2020 10:47:51

DSNDB01 SYSUTILX BACKUPS                                        
RMD.DSNDB01.SYSUTILX.LP190813.T145139        08/13/2019 14:51:41
RMD.DEJM.DSNDB01.SYSUTILX.LP00.D13.T172228   08/13/2019 17:22:33
RMD.DEJM.DSNDB01.SYSUTILX.RP00.D13.T172228   08/13/2019 17:22:33
RMD.DSNDB01.SYSUTILX.LP201014.T155336        10/14/2020 15:53:37
RMD.DSNDB01.SYSUTILX.LP201125.T104339        11/25/2020 10:43:40
                                                               
DSNDB01 SYSDBDXA BACKUPS                                        
RMD.DSNDB01.SYSDBDXA.LP190813.T145211        08/13/2019 14:52:20
RMD.DEJM.DSNDB01.SYSDBDXA.LP00.D13.T172309   08/13/2019 17:23:19
RMD.DEJM.DSNDB01.SYSDBDXA.RP00.D13.T172309   08/13/2019 17:23:19
ACM.QA.DEJM.DSNDB01.SYSDBDXA.LP19266.T215351 09/23/2019 21:54:00
RMD.DSNDB01.SYSDBDXA.LP201014.T155428        10/14/2020 15:54:36
RMD.DSNDB01.SYSDBDXA.LP201125.T104439        11/25/2020 10:44:48
******************************** BOTTOM OF DATA ***************************

The following example of ALMBHST Report in ALMHISTH DD: (BMC.DB2.SPE2110)

********************************* TOP OF DATA **********************************
                                                                                
**   PACLOG  - V12.01.00 *****  BMC SOFTWARE, INC. *****  08/03/2021 01:56:14 **
** BMC80220I Recovery Management for Db2 V12.01.00                             
** BMC80220I BMC AMI Recovery for Db2 V12.01.00                                
                                                                                
                                                                                
---------------------------------SUBSYSTEM DEHE---------------------------------
                                                                                
DEHE IS STANDALONE DB2 SUBSYSTEM                                               
                                                                                
DEHE.HIST=BMCALM.DEHE.HIST
                                                                                
LAST IMAGE COPIES                                                              
DSNDB01 DBD01       NO BACKUPS FOUND                                           
DSNDB06 SYSTSCPY    NO BACKUPS FOUND                                           
DSNDB01 SYSUTILX    NO BACKUPS FOUND                                           
DSNDB01 SYSDBDXA    NO BACKUPS FOUND                                           

NOT PROCESSED ARCHIVE3
DEHECAT.ARCLOG1.A0000129
DEHECAT.ARCLOG1.A0000128
DEHECAT.ARCLOG1.A0000127
DEHECAT.ARCLOG1.A0000126
DEHECAT.ARCLOG1.A0000125
DEHECAT.ARCLOG1.A0000124
DEHECAT.ARCLOG1.A0000123
DEHECAT.ARCLOG1.A0000122
DEHECAT.ARCLOG1.A0000121
DEHECAT.ARCLOG1.A0000120
                                                                
ALLOCATION INFORMATION FOR BMCALM.HIST.DEHE                                                                            
DATE: 2021.215  TIME: 01.02.21                                                                                         
                CONTENTS OF VTOC ON VOL DEVSIF  <THIS IS AN SMS MANAGED VOLUME>                                        
---------------DATA SET NAME----------------  SER NO  SEQNO  DATE.CRE  DATE.EXP  DATE.REF  EXT DSORG RECFM OPTCD BLKSIZE
BMCALM.HIST.DEHE                             DEVSIF      1  2021.117    00.000  2021.215    1  PS   FB     00     8820
SMS.IND   LRECL  KEYLEN  INITIAL ALLOC  2ND ALLOC    EXTEND       LAST BLK(T-R-L)  DIR.REM  F2 OR F3(C-H-R)  DSCB(C-H-R)
S           196            CYLS               1                         0   3 37672                            0   5  28
EATTR                                                                                                                  
NS                                                                                                                     
            EXTENTS  NO  LOW(C-H)   HIGH(C-H)                                                                          
                       0   353  0      353 14                                                                          
                                ----ON THE ABOVE DATA SET,THERE ARE     0 EMPTY CYLINDER(S) PLUS 14 EMPTY TRACK(S). 

Important

  • ALLOCATION INFORMATION report is displayed either on ALMHISTR DD & ALMHISTH DD if HISTORY_FILE REPORT & HISTORY_FILE HEALTH_CHECK are requested.
  • ALMPRINT DD could display any of the following space related messages depending on the allocation conditions present in the history file:
    BMC93799W HISTORY FILE HAS NO SECONDARY EXTENTS           
    BMC93799W HISTORY FILE HIST.FILE.NAME IS EMPTY           
    BMC93799E HISTORY FILE ON LAST EXTENT                         
    BMC93799W HEALTH CHECK ALLOCATION REPORT FAILED FOR HISTORY FILE  HIST.FILE.NAME
    BMC93799W HISTORY FILE EXTENTS GREATER THAN 14                  

The following is sample output for UNRECOVER_RC in ALMPRINT DD: (BMC.DB2.SPE2110)

------------------------------------PROCESSING SUBSYSTEM DEJM-----

BMC80799W VERIFY LAST CATALOG/DIRECTORY COPIES MADE ON SAME DAY   
BMC80799W SETTING RETURN CODE TO UNRECOVER_RC 5               

BMC80799W NOT ALL ARCHIVE3 ARE PROCESSED - SEE DETAIL REPORT      
BMC80799W SETTING RETURN CODE TO UNRECOVER_RC 5                   

BMC80799W MISSING ARCHIVE3 WITHIN LAST 7 DAYS - SEE DETAIL REPORT
BMC80799W SETTING RETURN CODE TO UNRECOVER_RC 5                   


------------------------------------PROCESSING SUBSYSTEM DEHJ-----

BMC80799W NOT ALL CATALOG/DIRECTORY COPIES EXIST                  
BMC80799W SETTING RETURN CODE TO UNRECOVER_RC 5                   

BMC80799W NOT ALL ARCHIVE3 ARE PROCESSED - SEE DETAIL REPORT      
BMC80799W SETTING RETURN CODE TO UNRECOVER_RC 5                   

BMC80571I PROGRAM COMPLETE RC = 5     

The following figure shows the ALMPRINT DD job output for recovering a damaged history file for attached SSID:

BMC80799I USING PRODUCT OPTION SET ALM$OPTS FROM DATA SET ALM.WIBA1217.CNTL              
                                                                                          
  HISTORY_FILE                                                                           
    RECOVER MVSALM.DEHE5L4.D20224.T0939323.H0001717                                      
  ;                                                                                      
                                                                                          
BMC80799I SUCCESSFULLY RECOVERED HISTORY FILE FROM MVSALM.DEHE5L4.D20224.T0939323.H0001717
                                                                                          
BMC80571I PROGRAM COMPLETE RC = 0                                                     
******************************** BOTTOM OF DATA ************************************

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*