View previous topic :: View next topic |
Author |
Message |
misi01 Advanced
Joined: 02 Dec 2002 Posts: 624 Topics: 175 Location: Stockholm, Sweden
|
Posted: Mon Sep 27, 2021 7:47 am Post subject: DB2 logging |
|
|
Some background. I'm working at a bank here in Sweden. We're looking at introducing logging for all transactions coming in (via API's, SOAP services, whatever).
The number of rows will probably be 2-5M per day. We have a log at the moment (just to give an idea of where we're coming from) which is defined as: -
Code: |
COLTYPE LENGTH
CHAR 50
VARCHAR 32000
CHAR 8
SMALLINT 2
DECIMAL 10
CHAR 7
CHAR 36
INTEGER 4
INTEGER 4
SMALLINT 2
CHAR 1
SMALLINT 2
TIMESTMP 10
|
We're running under CICS and have various thoughts including: -
write each log record to a file and then load the table at night
specify multiple partitions and write to them based on (?) last digit in current timestamp
specify no indexes for the table
is there a method to write "append" so a table to any new row is added at the back-end
others ...
This can't (isn't) anything new, but other peoples' experience/ideas would be gratefully received _________________ Michael |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Mon Sep 27, 2021 8:15 pm Post subject: |
|
|
misi01,
A few suggestions to mimic Logging.
1. Modify the table to have the timestamp field to 26 bytes, so that you get more granular. Currently you only have 10 byte field which I assume is just a date field.
2. Add another new column as SOURCE of Varchar of 1000 bytes so that you can store as much data as possible about incoming transaction ( terminal id , geo location...)
Alternatively you can have all the transactions loaded into a TDQ and offload it a to a daily GDG which then gets rolled into MONTHLY/YEARLY GDG.
You will always have an option of rolling back the transactions at any time.
Apart from that you can turn on logging and I suggest that you read this excellent article about Db2 for z/OS Log Overview _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
misi01 Advanced
Joined: 02 Dec 2002 Posts: 624 Topics: 175 Location: Stockholm, Sweden
|
Posted: Tue Sep 28, 2021 2:01 am Post subject: |
|
|
Thanks for the link. Time to start reading .... _________________ Michael |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|