Search found 53125 matches

by ray.wurlod
Thu Jan 12, 2006 4:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Job aborted Notification
Replies: 8
Views: 3758

Basically you are not making use of the functionality that is provided. You can use a Routine activity to log a warning in the controlling job sequence; the Routine activity being triggered by detection of a failure (that is, a conditional trigger in the Job activity). You can also use the Exception...
by ray.wurlod
Thu Jan 12, 2006 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find table name in group of jobs in Datastage
Replies: 2
Views: 2043

Search the forum - you will find a query against DS_JOBOBJECTS and references to at least two (free) third-party utilities. None of them work if your table names are job parameter references.
by ray.wurlod
Thu Jan 12, 2006 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error with succesfull Completion
Replies: 10
Views: 3381

One workaround would be to post-process the job log. Use DSGetNewestLogID to find the most recent Fatal event; this will return 0 if there is none.
by ray.wurlod
Thu Jan 12, 2006 4:41 pm
Forum:
Topic: Where does Metastage look for metadata in Datastage?
Replies: 3
Views: 1812

Welcome aboard! :D You can create your own table definitions but, in order for MetaStage to gather data for lineage analysis, you must be disciplined about it. Any table definitions must first be created in the Repository (whether manually or via an Import mechanism). Column definitions in job desig...
by ray.wurlod
Thu Jan 12, 2006 3:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warings msgs for Update Or insert type in ODBC Stage
Replies: 8
Views: 2018

When a database server generates any message (in this case "2 rows affected") DataStage logs it. This is the DataStage philosophy, on which I've posted at length before - search for "philosophy". The only possible way to suppress these messages is to cause the database (or ODBC driver) not to genera...
by ray.wurlod
Thu Jan 12, 2006 3:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Convert date to Julain date format in datastage
Replies: 1
Views: 2259

Julian means different things to different people. The conversion functions (Iconv() and OConv()) use "ordinal day within the year". If that's what you want use

Code: Select all

Oconv(Iconv(InLink.TheDate, "DMDY"), "D/JY")
(or use "D/YJ" to get year first.
by ray.wurlod
Thu Jan 12, 2006 3:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pivot Stage Performance
Replies: 3
Views: 1459

How about ----> IPC ---- ...TX ---+ +---> LC ---> IPC ---> TX ---> .... ----> IPC ---- Or, assuming that the results are going to a table ---> TX2A ---> .... ...T1X ---+ ---> TX2B ---> .... The two Transformer stages TX2A and TX2B perform identical processing (apart from the negative sign) and const...
by ray.wurlod
Wed Jan 11, 2006 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Aborts
Replies: 14
Views: 3792

I don't think there's a documented limit. What does Help say about the StartLoop activity properties?
by ray.wurlod
Wed Jan 11, 2006 11:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Default warnings limit in the Designer
Replies: 10
Views: 2321

The default default (ibid?) on version 7.0 is 50. Just checked. I'll have to wait till I get to a 7.5 system to verify your assertion. As to where it's set elsewhere, it wouldn't be a Registry hack if it were going to control dsjob - which can be, and usually is, executed on the server. Most of my s...
by ray.wurlod
Wed Jan 11, 2006 10:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Authentication Failure
Replies: 5
Views: 1503

Look at the error message again. It's tried to authenticate against a domain. I guess that's why they have beta. Report it.
by ray.wurlod
Wed Jan 11, 2006 10:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Aborts
Replies: 14
Views: 3792

Each "Done" message from DSD.RUN indicates a run of a server job. In your case everything appears to have worked (there are no warning messages). Your loop runs job Load_GGSN then runs job Load_SGSN. Does your job design trap exceptions (via an Exception Handler) or non-success triggers from the con...
by ray.wurlod
Wed Jan 11, 2006 8:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Authentication Failure
Replies: 5
Views: 1503

The message suggests that Windows authentication is trying to authenticate the user/password using a domain controller.

Are you executing in a domain or a workgroup?

Try logging in as machine\Administrator rather than using an unqualified user ID.
by ray.wurlod
Wed Jan 11, 2006 8:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Aborts
Replies: 14
Views: 3792

In Director, reset any job sequence that has aborted.

Tell us if any "from previous run..." message was logged.

And, by the way, a Sequencer is an activity that you can use in a Job Sequence. Please use correct terminology; exactitude aids precise communication.
by ray.wurlod
Wed Jan 11, 2006 8:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsintbuf_getrow() - row has N columns when N expected
Replies: 3
Views: 1760

Welcome aboard. :D Jim's answer is correct. There seems to be a bug in the metadata handling when buffering is enabled, whether explicitly or implicitly. An intermediate sequential file defeats the purpose of buffering by forcing data to be touched down to disk (at "disk speed" rather than at "memor...
by ray.wurlod
Wed Jan 11, 2006 6:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage 7.1 vs 7.5
Replies: 9
Views: 2981

Only because it has to be! :wink:

I think a better description in this case is a 32-bit application pretending to be a 64-bit application. Main hassle for this port was (is?) "word" alignment in shared memory segments.