dsexport / dscmdexport never seem to finish..

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Cowmix
Charter Member
Charter Member
Posts: 26
Joined: Sat Apr 01, 2006 2:11 am

dsexport / dscmdexport never seem to finish..

Post by Cowmix »

When I run dsexport or dscmdexport my DSX file gets up to 600+MB and the export still not done after 11+ hrs. It seems like when it gets to exporting binaries things REALLY show down.

Is there anyway to exclude binaries during these export functions? Or is there another problem I don't know about?

thanks!
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

How many jobs are you backing up?
Last edited by kduke on Thu May 04, 2006 9:39 am, edited 1 time in total.
Mamu Kim
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

:shock: 600+ MB :shock:


You really should be exporting by category and use multiple concurrent exports on your machine to expedite the process.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Cowmix
Charter Member
Charter Member
Posts: 26
Joined: Sat Apr 01, 2006 2:11 am

Post by Cowmix »

820 jobs
10 shared containers
20 data elements
110 stage types
152 table defs
110 transformations



kduke wrote:How mayn jobs are you backing up?
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

That is not that much. PX binaries must be a lot larger than server jobs.

I agree with Ken. Do a category at a time.
Mamu Kim
Cowmix
Charter Member
Charter Member
Posts: 26
Joined: Sat Apr 01, 2006 2:11 am

Post by Cowmix »

I take it there isn't a way to exclude binaries in an export then?
kduke wrote:That is not that much. PX binaries must be a lot larger than server jobs.

I agree with Ken. Do a category at a time.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you export from Director there is (a checkbox). This does not seem to have been brought into either of the tools you use. Perhaps you could lodge an enhancement request?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply