| View previous topic :: View next topic |
| Author |
Message |
misi01
Advanced
Joined: 02 Dec 2002
Posts: 619
Topics: 172
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 |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12367
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 - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
misi01
Advanced
Joined: 02 Dec 2002
Posts: 619
Topics: 172
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 |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
