Search found 42189 matches

by chulett
Wed Jul 08, 2009 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQLServer_Enterprise UNIX
Replies: 5
Views: 1686

True but they've supplied ODBC wire drivers for SQL Server for some time now. They are there on both my 7.5.2 and 8.1 servers and are how you'd connect from a UNIX server.
by chulett
Wed Jul 08, 2009 12:50 pm
Forum: General
Topic: Problem with permission
Replies: 11
Views: 4274

OK. Try doing an Exact search for your error message(s) as this has been discussed here before. For example, a search for "check that 'dbx' and 'sed' are installed and on your PATH" has 18 matches to other posts, see if any of them help.
by chulett
Wed Jul 08, 2009 12:48 pm
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 3554

Did not work in what sense? What exact problem are you trying to solve again? Your RT_LOG issue sounds more like a corruption issue with the log hashed files themselves. I would suggest exporting and reimporting any job that does that to fix things of that nature.
by chulett
Wed Jul 08, 2009 12:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSSetUserStatus Test Error
Replies: 1
Views: 1325

This is one you cannot 'Test' like that, it must be executed from within a job. So create test Sequence and Server Jobs for this.
by chulett
Wed Jul 08, 2009 10:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of Jobs across Projects
Replies: 13
Views: 5520

Not quite, you can use a parameter to control what "account" a.k.a. Project your hashed file source can point to.
by chulett
Wed Jul 08, 2009 9:30 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 3554

That's normal so nothing wrong at all. Immediate Purge is the default when doing this manually.
by chulett
Wed Jul 08, 2009 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UtilityRunJob error with DataStage 8.1
Replies: 9
Views: 7922

Exactly... check into the USERSTATUS functionality to pass informaiton between jobs without 'landing' it.
by chulett
Wed Jul 08, 2009 8:53 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 3554

Because of the associated bug related to that in 8.x, I assume?
by chulett
Wed Jul 08, 2009 8:52 am
Forum: General
Topic: The number of logs for a mult-instantiated parallel job
Replies: 16
Views: 3554

Multi-instance jobs all share the same log and each individual invocation id run has (in essence) a view into the main log which filters out just their entries. So you need to take that into account when setting auto-purge for them.
by chulett
Wed Jul 08, 2009 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data conversion problem
Replies: 1
Views: 1444

No 'conversion' required, simply substring off just the date portion:

DSLink5.JOB_EFFECTIVE_DATE[1,10]
by chulett
Wed Jul 08, 2009 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UtilityRunJob error with DataStage 8.1
Replies: 9
Views: 7922

I'm curious why you are not using a Sequence job for this? :?
by chulett
Wed Jul 08, 2009 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2API plugin GUI changed
Replies: 3
Views: 1238

Ray's advice would be applicable if a stage started to look like the 'generic' plug-in icon: an wall plug with an electrical cord. That typically happens when you run out of memory and freeing some up will 'fix' it.
by chulett
Wed Jul 08, 2009 6:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Rejects from Oracle enterprise stage
Replies: 6
Views: 2545

Completely agree with Vincent. You need to create simple target tables and test the scenarios you want to capture and see what happens. It's quite odd what it will and won't even report, let alone capture via a reject link. Glad to hear it is 'mostly' fixed in coming connector.
by chulett
Wed Jul 08, 2009 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic Notification_Activity
Replies: 16
Views: 6033

You tried with with a single address and... did it work that way? Trying to understand if you can't get it to work at all or if the issue is only with multiple email addresses. :?
by chulett
Wed Jul 08, 2009 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Automatic restart of a scheduled job
Replies: 2
Views: 706

Short answer is no, at least not by itself. The actual scheduled job must be either manually reset or monitored and reset by another process. Which could be scheduled to check 10 minutes after the other runs.