Examples of interval processing
Sample of SMF File data used for the examples.
The following examples assume:
- The DB2 instrumentation facility is started for Accounting to
SMF at DB2 startup by the following DB2 command:
-START TRACE (ACCTG) DEST(SMF) CLASS(1) - The system programmer wants to analyze performance for Thursday,
14 March 1999, so the SMF file for that day is obtained. The following figure represents sample data from the SMF file. Actual trace data can have a different distribution of DB2 records and timestamps. For the purpose of this example, assume that the Statistics trace was previously active.
Figure 1. Example SMF File data DB2 Sequence Timestamp Destination # FCID Record Descriptions 7/14/13 8:30:00 0001 0001 System statistics 7/14/13 8:30:01 0002 0002 Database statistics 7/14/13 8:31:05 0003 0003 Accounting 7/14/13 8:45:13 0004 0003 Accounting 7/14/13 8:57:27 0005 0003 Accounting 7/14/13 8:59:59 0006 0001 System statistics 7/14/13 9:00:00 0007 0002 Database statistics 7/14/13 9:12:11 0008 0003 Accounting 7/14/13 9:15:00 0009 0003 Accounting 7/14/13 9:29:59 0010 0001 System statistics 7/14/13 9:30:00 0011 0002 Database statistics 7/14/13 9:30:01 0012 0003 Accounting 7/14/13 9:32:00 0013 0003 Accounting 7/14/13 9:43:00 0014 0003 Accounting 7/14/13 9:55:59 0015 0003 Accounting 7/14/13 10:00:00 0016 0001 System statistics 7/14/13 10:00:00 0017 0002 Database statistics 7/14/13 10:30:00 0018 0001 System statistics 7/14/13 10:30:01 0019 0002 Database statistics 7/14/13 11:00:00 0020 0001 System statistics 7/14/13 11:00:01 0021 0002 Database statistics 7/14/13 11:29:59 0022 0001 System statistics 7/14/13 11:30:00 0023 0002 Database statistics 7/14/13 12:00:01 0024 0001 System statistics 7/14/13 12:00:01 0025 0002 Database statistics7/14/13 12:15:00 0026 0003 Accounting 7/14/13 12:17:54 0027 0003 Accounting 7/14/13 12:30:00 0028 0001 System statistics 7/14/13 12:30:00 0029 0002 Database statistics 7/14/13 13:00:00 0030 0001 System statistics 7/14/13 13:00:01 0031 0002 Database statistics 7/14/13 13:10:31 0032 0003 Accounting 7/14/13 13:15:00 0033 0003 Accounting 7/14/13 13:17:54 0034 0003 Accounting 7/14/13 13:23:34 0035 0003 Accounting 7/14/13 13:27:00 0036 0003 Accounting 7/14/13 13:30:00 0037 0001 System statistics 7/14/13 13:30:00 0038 0002 Database statistics 7/14/13 13:37:30 0039 0003 Accounting 7/14/13 15:20:00 0040 0001 System statistics 7/14/13 15:20:00 0041 0002 Database statistics 7/14/13 15:37:30 0042 0003 Accounting 7/14/13 15:50:00 0043 0001 System statistics 7/14/13 15:50:01 0044 0002 Database statistics 7/14/13 16:15:00 0045 0001 System statistics 7/14/13 16:15:00 0046 0002 Database statistics 7/14/13 16:28:02 0047 0003 Accounting 7/14/13 16:30:31 0048 0003 Accounting 7/14/13 16:44:00 0049 0003 Accounting 7/14/13 16:44:59 0050 0003 Accounting 7/14/13 16:45:00 0051 0001 System statistics 7/14/13 16:45:01 0052 0002 Database statistics 7/14/13 16:51:06 0053 0003 Accounting 7/14/13 16:54:17 0054 0003 Accounting 7/14/13 16:55:37 0055 0003 Accounting 7/14/13 16:57:59 0056 0003 Accounting - OMEGAMON for Db2 Performance Expert is run to get Accounting reports.