Menu Options View Utilities Compilers Help ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss DSLIST - Data Sets Matching DB2P.DBP3.ARCHLOG1.A0* Row 6876 of 6886 Command ===> Scroll ===> CSR Total Tracks: 36848565 non-x: 36848565 Data Sets: 6886 non-x: 6886 ------------------------------------------------------------------------------- Command - Enter "/" to select action Message Volume Tracks % XT Device Dsorg Recfm Lrecl Blksz Created Referred Catalog ------------------------------------------------------------------------------- DB2P.DBP3.ARCHLOG1.A0082170 BKP440+ 41505 99 28 3390 PS-E FB 4096 24576 2021/12/09 2021/12/09 SYS1.UCAT.DB0000 ------------------------------------------------------------------------------- DB2P.DBP3.ARCHLOG1.A0082171 BKP015+ 44100 99 28 3390 PS-E FB 4096 24576 2021/12/09 2021/12/09 SYS1.UCAT.DB0000 ------------------------------------------------------------------------------- DB2P.DBP3.ARCHLOG1.A0082172 BKP325+ 41805 99 29 3390 PS-E FB 4096 24576 2021/12/09 2021/12/09 SYS1.UCAT.DB0000 Data Set Information Command ===> Data Set Name . . . . : DB2P.DBP3.ARCHLOG1.A0082170 General Data Current Allocation Management class . . : **None** Allocated cylinders : 2,767 Storage class . . . : SCDASD Allocated extents . : 28 Volume serial . . . : BKP440 + Device type . . . . : 3390 Data class . . . . . : COMPRESS Organization . . . : PS Current Utilization Record format . . . : FB Used cylinders . . : 2,767 Record length . . . : 4096 Used extents . . . : 28 Block size . . . . : 24576 1st extent cylinders: 150 Secondary cylinders : 100 Dates Data set name type : EXTENDED Creation date . . . : 2021/12/09 Data set encryption : NO Referenced date . . : 2021/12/09 Expiration date . . : 2049/04/25 SMS Compressible . : YES Extended Attributes OPT To display multiple volumes press Enter or enter Cancel to Exit. Data Set Information Command ===> Data Set Name . . . . : DB2P.DBP3.ARCHLOG1.A0082171 General Data Current Allocation Management class . . : **None** Allocated cylinders : 2,940 Storage class . . . : SCDASD Allocated extents . : 28 Volume serial . . . : BKP015 + Device type . . . . : 3390 Data class . . . . . : COMPRESS Organization . . . : PS Current Utilization Record format . . . : FB Used cylinders . . : 2,932 Record length . . . : 4096 Used extents . . . : 28 Block size . . . . : 24576 1st extent cylinders: 168 Secondary cylinders : 100 Dates Data set name type : EXTENDED Creation date . . . : 2021/12/09 Data set encryption : NO Referenced date . . : 2021/12/09 Expiration date . . : 2049/04/25 SMS Compressible . : YES Extended Attributes OPT Create Jobname DBP3MSTR Create Stepname DBP3MSTR To display multiple volumes press Enter or enter Cancel to Exit. Data Set Information Command ===> Data Set Name . . . . : DB2P.DBP3.ARCHLOG1.A0082172 General Data Current Allocation Management class . . : **None** Allocated cylinders : 2,787 Storage class . . . : SCDASD Allocated extents . : 29 Volume serial . . . : BKP325 + Device type . . . . : 3390 Data class . . . . . : COMPRESS Organization . . . : PS Current Utilization Record format . . . : FB Used cylinders . . : 2,785 Record length . . . : 4096 Used extents . . . : 29 Block size . . . . : 24576 1st extent cylinders: 150 Secondary cylinders : 100 Dates Data set name type : EXTENDED Creation date . . . : 2021/12/09 Data set encryption : NO Referenced date . . : 2021/12/09 Expiration date . . : 2049/04/25 SMS Compressible . : YES Extended Attributes OPT Create Jobname DBP3MSTR Create Stepname DBP3MSTR To display multiple volumes press Enter or enter Cancel to Exit. BROWSE - SYSOUT LGVWRUN - Record 1 COMMAND ===> ********************************************************** Happy Holidays! ! Db2 + ' + Archive -- (*) -- Log >*< Viewer >0<@< >>>@<<* >@>*<0<<< >*>>@<<<@<< >@>>0<<<*<<@< >*>>0<<@<<<@<<< >@>>*<<@<>*<<0<*< >0>>*<<@<>0><<*<@<< >*>>@><0<<*>>@><*<0<< >@>>0<*<0>>@<<0<<<*<@<< >((*))_>0><*<0><@<<<0<*<< >*@*.*0*.*>>@<<*<<@>><0<*<< >*.*@*.*.*._''DD''_.*.*@*.*<< >*.*0.*.*0**! 'bb' !**@*.*0*.*< ^^^^^^^^^^^^! 22 !^^^^^^^^^^^ !__XX__! !XXXXXX! """""""" ------------------------------------------- Db2 Archive Log Viewer V1.0 started at 2021-12-09-13.16.56 Log physical records read : 1M Log logical records read : 13M Details Count Len Type 0002 Page Set Control Record Pageset open record : 1K 556K Dataset open record : 2K 386K Pageset close record : 1K 194K Dataset close record : 1K 136K CTL checkpoint : 17K 5M SETW record : 0 0 Write I/O record : 1008K 360M RSTW record : 0 0 SES dependency record : 2K 398K Unknown Subtype : 0 0 Type 0004 SYSCOPY utility DSNDB01.DBD01 : 0 0 DSNDB01.SYSDBDXA : 0 0 DSNDB01.SYSUTILX : 0 0 DSNDB06.SYSTSCPY : 0 0 Unknown PSID : 0 0 Type 0008 Non-UR related lock : 0 0 Type 0010 System Event Record Begin checkpoint record : 6 1K End checkpoint record : 6 912 Begin current status rebuild : 0 0 Begin historic status rebuild : 0 0 Begin active UR backout : 0 0 No log activity : 0 0 Retained lock purge by operator : 0 0 Command : 6 2K Unknown Subtype : 0 0 Type 0020 UR Control Record Begin UR record : 93K 20M Begin COMMIT phase 1 : 73K 10M End COMMIT phase 1 : 20K 2M Begin COMMIT phase 2 : 20K 2M Phase 1 to 2 transition : 73K 9M End COMMIT phase 2 : 93K 8M Begin abort record : 8 1K End abort record : 10 1K End UNDO record : 0 0 End TODO record : 0 0 End REDO record : 0 0 Unknown Subtype : 0 0 Type 0100 Checkpoint Record : 25K 7M Type 0200 UR-UNDO Record Update data page : 3M 683M Format page or update space map : 0 0 Update space map bits : 141K 17M Update to index space map : 0 0 Update to index page : 0 0 DBA table update : 0 0 Checkpoint DBA table : 0 0 Soft-log a CUB position : 0 0 DBD virtual memory copy : 27K 3M Excl. lock on pgset part or DBD : 0 0 Format file page set : 0 0 Format index page set : 0 0 Invalidate object. CTDB,PSCB,CUB : 0 0 Update by repair (first half 32k): 0 0 Update by repair (secnd half 32k): 0 0 Allocate/Deallocate a segm entry : 255K 37M Modified page/Formatted page : 1 156 Lock ptr if overflow updated : 3K 469K Savepoint : 425K 37M Other recs for RMID 14 : 1 2K Checkpoint record of mod. pgset : 0 0 Type 2 index update : 6M 1G Type 2 index undo/redo : 0 0 Type 2 index change notification : 0 0 Type 2 index space map update : 0 0 DBET : 0 0 DBET with LPL/GRECP : 0 0 LOB manager format smap : 0 0 LOB manager change high smap : 5K 750K LOB manager change low smap : 0 0 LOB manager alloc/dealloc smap : 14K 2M LOB manager change smap : 0 0 LOB manager change data page : 0 0 LOB manager change system page : 0 0 Reformat data page : 0 0 DBET diagnostic : 0 0 Batch format data pages : 0 0 Update smaps modify bit : 0 0 CLR diagnostic : 0 0 CDC diagnostic : 0 0 Diagnostic dsnismcp : 21K 2M Diagnostic pipe : 0 0 System page dummy compensation : 1 134 Index dummy compensation : 40K 5M Start database access(force) : 0 0 ALTER TABLE : 0 0 End of savepoint : 3K 373K Special begin trunc immediate : 0 0 Special commit trunc immediate : 0 0 Non-documented subtype x'87' : 0 0 Unknown Subtype : 0 0 Type 0400 UR-REDO Record Update data page : 3M 609M Format page or update space map : 38K 6M Update space map bits : 218K 27M Update to index space map : 28K 3M Update to index page : 0 0 DBA table update : 0 0 Checkpoint DBA table : 0 0 Soft-log a CUB position : 0 0 DBD virtual memory copy : 0 0 Excl. lock on pgset part or DBD : 0 0 Format file page set : 0 0 Format index page set : 0 0 Invalidate object. CTDB,PSCB,CUB : 0 0 Update by repair (first half 32k): 0 0 Update by repair (secnd half 32k): 0 0 Allocate/Deallocate a segm entry : 256K 37M Modified page/Formatted page : 1 156 Lock ptr if overflow updated : 3K 469K Savepoint : 0 0 Other recs for RMID 14 : 1 2K Checkpoint record of mod. pgset : 0 0 Type 2 index update : 6M 1G Type 2 index undo/redo : 0 0 Type 2 index change notification : 0 0 Type 2 index space map update : 0 0 DBET : 609 150K DBET with LPL/GRECP : 890 178K LOB manager format smap : 990 161K LOB manager change high smap : 5K 759K LOB manager change low smap : 0 0 LOB manager alloc/dealloc smap : 14K 2M LOB manager change smap : 9K 2M LOB manager change data page : 293K 579M LOB manager change system page : 0 0 Reformat data page : 0 0 DBET diagnostic : 0 0 Batch format data pages : 0 0 Update smaps modify bit : 0 0 CLR diagnostic : 0 0 CDC diagnostic : 0 0 Diagnostic dsnismcp : 21K 2M Diagnostic pipe : 0 0 System page dummy compensation : 0 0 Index dummy compensation : 0 0 Start database access(force) : 0 0 ALTER TABLE : 0 0 End of savepoint : 0 0 Special begin trunc immediate : 0 0 Special commit trunc immediate : 0 0 Non-documented subtype x'87' : 0 0 Unknown Subtype : 0 0 Type 0800 Archive quiesce Record : 0 0 Type 1000 Resource MGR assigned 1 : 3K 2M Type 2000 Resource MGR assigned 2 : 434K 39M Type 4000 Resource MGR assigned 3 : 71K 9M Type 8000 Resource MGR assigned 4 : 0 0 Unknown Record Type : 0 0 Db2 Archive Log Viewer ended at 2021-12-09-13.17.25 Db2 Archive Log Viewer with RC : 0 *********************************************************************** Bottom of Data