Column Update Frequency report
This report shows the update frequency of table columns, enabling you to determine whether placing an index on a column would have a negative impact.
This report summarizes activity (see Summary report) and adds column detail if the table was updated. Log Master maintains counts for each changed column and provides the total number of changed columns. You can request either narrow or wide format for the report.
Sample Column Update Frequency reports
The following figures illustrate the two formats for this report.
Date: 2020-08-02 BMC AMI Log Master for Db2 V12.01.00 Page: 1
Time: 14.32.24 Copyright BMC Software, Inc. 1995-2020
Column Update Frequency Report, By Table Name, Column Number
---------------------------------------------------------------------------------------------------------------------
From: Date 2020-08-02 00.00.00.000000
To: Current x'00CE964654731CE16A00'
---------------------------------------------------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0006 Run Number: 1 Subsystem: DXW2
Description: DB2DBA GENERATE MONTHLY REPORTS
---------------------------------------------------------------------------------------------------------------------
Table Name: DB2DBADB.DB2DBAB1 DBID.OBID: (363.3)
Tablespace Name: DB2DBADB.DB2DBAT1 DBID.PSID: (363.2)
Column Name: ITEM_NO Number: 2 Type: CHAR Length: 6 IdxCol: Y Frequency: 2
Column Name: ITEM Number: 5 Type: VARCHAR Length: 24 IdxCol: N Frequency: 4
Column Name: NOTES Number: 12 Type: VARCHAR Length: 762 IdxCol: N Frequency: 4
Totals For:Table Name: DB2DBADB.DB2DBAB1 OBID: 3
Total Column Updates: 10
Inserts : 0 Deletes : 0 Updates : 4
Deletes/RI: 0 Updates/RI: 0 Total : 4
Report Totals:
Total Column Updates: 10
Inserts : 0 Deletes : 0 Updates : 4
The following is a narrow column update frequency report:
Date: 2020-08-02 BMC AMI Log Master for Db2 V12.01.00 Page: 1
Time: 14.33.31 Copyright BMC Software, Inc. 1995-2020
Column Update Frequency Report, By Table Name, Column Number
------------------------------------------------------------------------------
From: Date 2020-08-02 00.00.00.000000
To: Current x'00CE964698C0CE412600'
------------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0006 Run Number: 1 Subsystem: DXW2
Description: DB2DBA GENERATE MONTHLY REPORTS
------------------------------------------------------------------------------
Table Name: DB2DBADB.DB2DBAB1 DBID.OBID: (363.3)
Tablespace Name: DB2DBADB.DB2DBAT1 DBID.PSID: (363.2)
Col Name: ITEM_NO Num: 2 Type: CHAR Len: 6
IdxCol: Y Freq: 2
Col Name: ITEM Num: 5 Type: VARCHAR Len: 24
IdxCol: N Freq: 4
Col Name: NOTES Num: 12 Type: VARCHAR Len: 762
IdxCol: N Freq: 4
Totals For:Table Name: DB2DBADB.DB2DBAB1 OBID: 3
Tot Col Upd: 10
Ins : 0 Del : 0 Upd : 4
Tot : 4 Del/RI: 0 Upd/RI: 0
Report Totals:
Tot Col Upd: 10
Ins : 0 Del : 0 Upd : 4
Tot : 4 Del/RI: 0 Upd/RI: 0
This section contains the following topics:
Related topic
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.