Search found 42189 matches

by chulett
Fri Jan 28, 2011 7:42 am
Forum: General
Topic: code=-14 [Timed out while waiting for an event]
Replies: 9
Views: 5733

Try it and let us know. Typically the answer is to slow down the start-up of simultaneous jobs, start fewer at the same time. Was this a one time error or does it only happen infrequently?
by chulett
Thu Jan 27, 2011 6:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Header & Footer
Replies: 39
Views: 13632

karthi_gana wrote:Actually i am creating parallel job for first time. so i am having lot of doubts and questions.
Fair enough, but again... anyone there that can help you with the basics?
by chulett
Thu Jan 27, 2011 6:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record check after extract
Replies: 6
Views: 2589

Typically, a job processing zero records will 'exit gracefully' all on its own. Are you sure you really need some kind of pre-check?
by chulett
Thu Jan 27, 2011 6:41 pm
Forum: General
Topic: Ignore the stages on the designer palette
Replies: 7
Views: 2889

Re: Ignore the stages on the designer palette

I have need where we need to ignore GUI code on what is on the Job designer. Perhaps if you explained the "why" of this more fully, what exactly it is you are trying to accomplish rather than how you think it should be done, people here could help or at least come up with a viable alterna...
by chulett
Thu Jan 27, 2011 6:30 pm
Forum: General
Topic: Query on DataStage Repository
Replies: 12
Views: 5723

can please give me any idea about scripting. What kind of "idea" are you looking for? If you don't have any shell scripting experience, it's not something someone can teach in a post or two. Do you have anyone you work with you could enlist to help you? You help them with the DataStage sy...
by chulett
Thu Jan 27, 2011 6:27 pm
Forum: General
Topic: A new version of my List all files and tables tool...
Replies: 1
Views: 1496

Thanks Chuck. :wink:
by chulett
Thu Jan 27, 2011 6:26 pm
Forum: General
Topic: Regarding VB script in datasage
Replies: 3
Views: 1583

Exactly what I meant - if you need to encapsulate VBScript into something else to 'run it' from a CMD prompt then you'll need to do that for use in that stage.
by chulett
Thu Jan 27, 2011 10:43 am
Forum: General
Topic: Query on DataStage Repository
Replies: 12
Views: 5723

You could easily do all this with a looping script that leverages dsjob to first get all projects then all jobs in each project.
by chulett
Thu Jan 27, 2011 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row count
Replies: 21
Views: 7225

For a generic solution, you are way better off building a stand-alone routine that takes 3 arguments. Call it 3x in a Sequence job and pass that as parameters to a job that just loads the audit table.
by chulett
Thu Jan 27, 2011 9:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row count
Replies: 21
Views: 7225

Last one into USERSTATUS wins, so no. Suggest you go back to the aggregator approach, for counts you won't need three to get three counts back out.
by chulett
Thu Jan 27, 2011 9:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Header & Footer
Replies: 39
Views: 13632

That's pretty fundamental PX stuff and should be something you just know. So, you have no idea what number of nodes are defined in your default config? Or how to override that if you need to? Is there someone there that can enlighten you? :?
by chulett
Thu Jan 27, 2011 8:58 am
Forum: General
Topic: Query on DataStage Repository
Replies: 12
Views: 5723

I did... sorry, meant you can do that in the Director client.
by chulett
Thu Jan 27, 2011 8:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: row count
Replies: 21
Views: 7225

There is no output as you haven't coded any in. What exactly do you want to do with this count? Perhaps USERSTATUS would work for you?
by chulett
Thu Jan 27, 2011 6:45 am
Forum: General
Topic: Query on DataStage Repository
Replies: 12
Views: 5723

Turn off the Category and Refresh options then print to file. Import into Excel and sort away.