Controlling dates and times of DB2 transactions - syncsort_capacity_management - 12 - 12.40

Syncsort Capacity Management Installation Guide

Product type
Software
Portfolio
Integrate
Product family
Syncsort
Product
Syncsort Capacity Management
Version
12.40
Language
English
Product name
Syncsort Capacity Management
Title
Syncsort Capacity Management Installation Guide
Topic type
How Do I
Copyright
2023
First publish date
1985

The DB2ROUND= parameter lets you control which RMF interval a record falls into. DB2 usually fires off its interval-based SMF records (the type 100s) with a time that is slightly after a minute starts. With very short RMF interval lengths (e.g., 1 minute), this can make data arrive in the “wrong” interval.

DBROUND=0 is the default and will subtract 5 seconds from a time to ensure it appears in the correct RMF interval. For example, a record with a time of 18:15:02.36 will be altered to 18:14:57.36.

DB2ROUND=1 means times will be “floored” down to the minute in which they were written. For example, a record with a time of 09:17:02.36 will be altered to 09:17:00.00.

DB2ROUND=2 will round a time down unless the time is 59 seconds or more into a minute when it will round up. For example, a time of 09:17:59.16 will round up to 09:18:00.00.

DBROUND=3 will not touch the time and pass it on exactly as-is.

The DB2TIME= parameter can be used to select the timestamp for a DB2 trans­action. You can associate a transaction with:

  • The time it started (S), or

  • The time it ended (E), or

  • The time that the SMF record was written by DB2 (D) - this is the default