Hello Everyone.
Does anyone have experience with calculating data volumes in MB?
I have the task of capturing the data volume sent to files, DB, MQ, etc. I have tried using the DSODB. Volume status are not there.
Thanks in advance for any help.
Calculating Data Volumes passing through a DataStage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you can abstract the metadata (for example to a schema file) you can readily calculate the size of each column and the number of columns. From those numbers you get the size of each row (minus transmission overheads but, if you're only interested in data volume, that's not a problem). Multiply by number of rows and you'll get pretty close.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you can abstract the metadata (for example to a schema file) you can readily calculate the size of each column and the number of columns. From those numbers you get the size of each row (minus transmission overheads but, if you're only interested in data volume, that's not a problem). Multiply by number of rows and you'll get pretty close.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hello.
Please help. I'm trying to read reply's to my question
I'm to renew my membership at the link for "Yes, make me a Premium Member at the regular yearly rate of US$99". I keep getting the following "404 (Page Not Found) Error"
I have tried the contact emails for this site but they keep coming back undelivered.
Please help. I'm trying to read reply's to my question
I'm to renew my membership at the link for "Yes, make me a Premium Member at the regular yearly rate of US$99". I keep getting the following "404 (Page Not Found) Error"
I have tried the contact emails for this site but they keep coming back undelivered.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try emailing editor@dsxchange.com
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.