×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
BMC AMI Log Master for Db2 12.1 ... Administering Reference of default Log Master reports

Log Bytes report

The Log Bytes report supplies information about the distribution of log records in the Db2 log. The Log Bytes report focuses on the type, size and distribution of log records, and not on the actual data contained in the log records.

Filters that you specify in the log scan are not used for selecting records that Log Master reports in a Log Bytes report.

Use the Log Bytes report for tuning purposes, to help you reduce unnecessary overhead in the log. The Log Bytes report displays the following information about log records:

  • Counts of log record types

  • Total number of bytes used by the log records

  • Percentage of space the log records use

To request a Log Bytes report

  1. From any task dialog (any option from 0 through 7 under the Actions category on the Main Menu), select the Define Report and File Outputs option.
  2. On the Output Options panel, select Log Bytes.

When you generate a Log Bytes report, Log Master cannot include any other forms of output in the same log scan, such as other reports or SQL. To generate other forms of output for the same work ID add an additional separate log scan step.

Example of a Log Bytes report

Date: 2013-01-17            LOG MASTER FOR DB2 -  V11.01.00        Page:       1
Time: 13.38.39         Copyright BMC Software, Inc. 1995-2013 
                       Log Bytes Report, By Correlation ID                      
--------------------------------------------------------------------------------
From: Date 2013-01-17 10.45.00.000000                                           
  To: Date 2013-01-17 11.00.00.000000                                           
  Total Bytes: 12459239                                                         
--------------------------------------------------------------------------------
Report Information:                                                             
Work ID    : RDAXQZ.LGB00RPT             Run Number:    1  Subsystem: DXF3      
Description: LOG BYTES REPORT                                                   
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
URID Records:                                                                   
Correlation ID: '#URM00I     '                                                  
                 Records        Bytes          Log Percent                      
                 -------------  -------------  -----------                      
   Urid                    711          68176      0.54719                      
   Savepoint                 0              0      0.00000                      
   DM Committed          15064        4559807     36.59780                      
   DM Rolledback            13           9691      0.07778                      
   Compensation             29           3767      0.03023                      
Correlation ID: '#URM00U1    '                                                  
                 Records        Bytes          Log Percent                      
                 -------------  -------------  -----------                      
   Urid                    132          12672      0.10171                      
   Savepoint                 0              0      0.00000                      
   DM Committed           3068         326294      2.61889                      
   DM Rolledback             0              0      0.00000                      
   Compensation              0              0      0.00000                      
Correlation ID: '020.STRTDB04'                                                  
                 Records        Bytes          Log Percent                      
                 -------------  -------------  -----------                      
   Urid                      6            576      0.00462                      
   Savepoint                 0              0      0.00000                      
   DM Committed              0              0      0.00000                      
   DM Rolledback             0              0      0.00000                      
   Compensation              0              0      0.00000                      
Correlation ID: '021.CLSLGR00'                                                  
                 Records        Bytes          Log Percent                      
                 -------------  -------------  -----------                      
   Urid                    267          25632      0.20573                      
   Savepoint                 0              0      0.00000                      
   DM Committed            270          31823      0.25542                      
   DM Rolledback             0              0      0.00000                      
   Compensation              0              0      0.00000                      
URID Totals:                                                                    
                 Records        Bytes          Log Percent                      
                 -------------  -------------  -----------                      
   Urid                   1830         175600      1.40940                      
   Savepoint                 0              0      0.00000                      
   DM Committed          30166       11599904     93.10283                      
   DM Rolledback            13           9691      0.07778                      
   Compensation             29           3767      0.03023                      
--------------------------------------------------------------------------------
Data Management Records:                                                        
Tablespace: DSNDB01.                                                            
DBID:PSID: 0001:001F                                                            
Record Type                            Count          Bytes          Log Percent
-------------------------------------  -------------  -------------  -----------

Inserts                                           88         354376      2.84428
Updates                                          178          13172      0.10572
Deletes                                           83         337848      2.71163
Space Map Records                                257          15677      0.12583
Pageset Open                                       1            170      0.00136
Tablespace: DSNDB01.                                                            
DBID:PSID: 0001:0044                                                            
Record Type                            Count          Bytes          Log Percent
-------------------------------------  -------------  -------------  -----------

Index Updates                                    385         132281      1.06171
Pageset Open                                       1            170      0.00136
Tablespace: DSNDB01.                                                            
DBID:PSID: 0001:00AF                                                            
Record Type                            Count          Bytes          Log Percent
-------------------------------------  -------------  -------------  -----------

Inserts                                           42          77198      0.61960
Updates                                          225         683610      5.48677
Deletes                                           37          94004      0.75449
Space Map Records                                 64           3904      0.03133
Pageset Open                                       1            170      0.00136
Tablespace: DSNDB01.                                                            
DBID:PSID: 0001:00CF                                                            
Record Type                            Count          Bytes          Log Percent
-------------------------------------  -------------  -------------  -----------

Inserts                                           89          10324      0.08286
Updates                                           37           4088      0.03281
Deletes                                            2            232      0.00186
Pageset Open                                       1            170      0.00136
Tablespace: DSNDB06.SYSDBASE                                                    
DBID:PSID: 0006:0009                                                            
Record Type                            Count          Bytes          Log Percent
-------------------------------------  -------------  -------------  -----------

Miscellaneous Records:                                                          
Type Subtype  Count          Bytes          Log Percent                         
---- ------   -------------  -------------  -----------                         
0002  0009               12           1224      0.00982                         
0102  0005               41           6970      0.05594                         
0108  0002                1            134      0.00108                         
0200  0009               98          10437      0.08377                         
0400  000A               27           1674      0.01344                         
0600  0011                5            385      0.00309                         
1400  001E              292          26864      0.21562                         
2100  001D              582          73381      0.58897                         
2400  0015               36          91152      0.73160                         
2400  001D              779          98933      0.79405                         
2600  0015               38          96216      0.77225                         
2600  001D              201          33768      0.27103                         
4200  0019                2           1800      0.01445                         
Miscellaneous Record Totals:                                                    
              Count          Bytes          Log Percent                         
              -------------  -------------  -----------                         
                       2114         442938      3.55510                         
--------------------------------------------------------------------------------
Page Overhead and Free Bytes:                                                   
Page Count     CI Overhead    Free Bytes     Log Percent                        
-------------  -------------  -------------  -----------                        
         3154          66234          89741      1.25188

Log Bytes report contents

The information presented in the Log Bytes report is grouped into the following sections:

  • URID records

  • data management records, reported by table space (DBID and PSID), and divided into the following record subtypes:

    • inserts, updates, and deletes (This section includes XML records.)

    • compensation

    • index

    • space map

    • page format

    • pointer update

    • page compaction

    • pageset (open, close, and write)

    • locking

    • LOB

    • database exception (DBE) table update

    • DBE table with piece data

  • checkpoint records

  • diagnostic records

  • SYSCOPY records

  • system event records

  • miscellaneous records

  • DB2 page overhead information, including totals for

    • number of pages

    • amount of CI bytes on those pages

    • amount of free space on the pages

Log Bytes report ordering

Log Master orders most sections of the Log Bytes report by DB2 record type and subtype. Log Master orders records in the diagnostic records section by member ID, and includes information about each member.

You can order this report by the following unit of recovery (URID) options:

  • Plan name

  • Authorization ID

  • Connection type

  • Connection ID

  • Correlation ID


Related topic

 Reference of default Log Master reports

Was this page helpful? Yes No Submitting... Thank you
Last modified by Anagha Evans on Sep 30, 2021
administration task

Comments

Log in or register to comment.

Image Copy report ordering
Object Activity Summary report
© Copyright 1996-2024 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.