Page 1 of 1
Calculating Data Volumes passing through a DataStage job
Posted: Mon May 18, 2020 5:45 am
by tbtcust
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.
Posted: Tue May 26, 2020 11:22 pm
by ray.wurlod
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.
Posted: Tue May 26, 2020 11:22 pm
by ray.wurlod
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.
Posted: Thu Jun 25, 2020 4:47 pm
by tbtcust
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.
Posted: Sat Jun 27, 2020 7:59 pm
by ray.wurlod