DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
tbtcust



Group memberships:
Premium Members

Joined: 04 Mar 2008
Posts: 225

Points: 1839

Post Posted: Mon May 18, 2020 5:45 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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.
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Tue May 26, 2020 11:22 pm Reply with quote    Back to top    

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 tra ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Tue May 26, 2020 11:22 pm Reply with quote    Back to top    

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 tra ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
tbtcust



Group memberships:
Premium Members

Joined: 04 Mar 2008
Posts: 225

Points: 1839

Post Posted: Thu Jun 25, 2020 4:47 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Sat Jun 27, 2020 7:59 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours