Orcadmin utility

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
raju4u
Participant
Posts: 56
Joined: Thu Dec 13, 2007 12:30 am

Orcadmin utility

Post by raju4u »

Hi All,

With out using funnel ,merge we have to combine two datasets ,by using orc admin utility..
Can anybody tell me solution and in the future we should not get any data issues.
N R REDDY
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The solution is to resist stupid requirements.

This is not what the orchadmin utility (note spelling) is intended to do.

Yes, of course, it can be done, but it is going to cost double the volume of data in disk space compared to the volume of data to be merged (a total of three times the volume at one point depending on when you delete the source Data Sets).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

From an admin perspective, I would have a strong desire to slap anyone who took that approach. Taking an orchadmin command to merge two datasets. blah If the end result is another dataset, you'd be MUCH better off using the appropriate tools.

I agree with Ray W. Just because it "can" be done, does not mean it "should" be done.

If you are executing on a GRID environment, those orchadmin commands execute on your conductor node. That's not on the grid. The conductor CPU time is a limited resource as compared to your GRID CPU time. Farm of the dataset merge onto your GRID and leave your poor Conductor alone.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sauron: the original orc admin
:lol:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

[rimshot]
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply