Search found 42189 matches

by chulett
Fri Dec 04, 2009 8:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer
Replies: 14
Views: 3927

Can anybody plz send me the designer,manager,administrator and director guide on my mail id i.e. datastageforum@yahoo.com As noted, if your company owns the software then you have access to the documentation. It is not freely available out there for the masses, at least not in any legal fashion. An...
by chulett
Fri Dec 04, 2009 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Update SQL Explain Plan
Replies: 16
Views: 5824

I have absolutely no idea - let us know what you find out when you ask IBM. :wink:
by chulett
Fri Dec 04, 2009 8:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Xml formatting: "&amp;lt" problem with single
Replies: 5
Views: 3016

I don't have anything to add other than -

:idea: Don't quote yourself to fix problems in a post, go back and edit the problematic post. You can do that at any time, unlike a delete which can only be performed if there are no replies to the post.
by chulett
Fri Dec 04, 2009 8:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: after job subroutine to reset a failed independent job
Replies: 10
Views: 5221

What task? A job cannot reset itself, period, before or after. And if it's Aborted, how do you run it to get to the 'before' part without manually resetting it first?

Can you clearly state exactly what the requirements are you're trying to implement? :?
by chulett
Fri Dec 04, 2009 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Error
Replies: 3
Views: 1423

What database is this? :?
by chulett
Thu Dec 03, 2009 7:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Table definitions import in Datastage Server Edition
Replies: 7
Views: 10361

What are you using to perform the metadata import, specifically what 'Table Definition' option did you choose? And what stage do you use in your jobs to connect to DB2? Is the answer to both questions ODBC?
by chulett
Thu Dec 03, 2009 6:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job hangs and not able to see the log too
Replies: 6
Views: 2290

Rather than attempt the log purge / clear from the Director, you'd be much better off connecting to that project via the Administrator and issuing a CLEAR.FILE RT_LOG438 command. Make sure you re-establish your Auto Purge settings as they will be removed by that command as well.
by chulett
Thu Dec 03, 2009 3:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job compile location issue
Replies: 3
Views: 1408

Sorry, but I'm going to state the obvious - you really shouldn't be using a client version that doesn't match your server version, no matter how minor that difference seems to be. Strange things happen.
by chulett
Thu Dec 03, 2009 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Count the rows in a file
Replies: 9
Views: 3390

Still seems to me that all depends on exactly why they feel the need to split their files in two. :?
by chulett
Thu Dec 03, 2009 2:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IS services starting after server reboot
Replies: 5
Views: 2402

True, there can be various "levels" of directories but they will be in an "rc" (or "runcom") directory.

http://en.wikipedia.org/wiki/Configuration_file
by chulett
Thu Dec 03, 2009 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: after job subroutine to reset a failed independent job
Replies: 10
Views: 5221

A job can't reset itself "after job" as it's still running at that point. Better to reset before the next run rather than immediately after the abort.
by chulett
Thu Dec 03, 2009 11:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Update SQL Explain Plan
Replies: 16
Views: 5824

You would send them the query, the explain plan and the table ddl and the Server query and explain plan as well I would imagine. Let them take it from there.

No, there's no configuration step or Oracle options you're missing here.
by chulett
Thu Dec 03, 2009 11:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to view data in input stage
Replies: 8
Views: 3596

What 'input stage'? One in particular? Depends on the data?

Cut down your Display sizes to avoid the warning noted.
by chulett
Thu Dec 03, 2009 11:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Update SQL Explain Plan
Replies: 16
Views: 5824

Still not following. You're wondering if Server is faster because you are 'misusing' the OCI stage there? :?

Me, I'd be asking IBM why the OE stage is not using the 'right' explain plan.
by chulett
Thu Dec 03, 2009 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge next value from database table to a file
Replies: 5
Views: 1269

There are sparse lookups in the 7.x release, so "yes" all around to your questions. Well, except for the "I thought we needed to upgrade" one. :wink: