Search found 42189 matches

by chulett
Fri Apr 04, 2008 9:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding the error "Variable previously undefined"
Replies: 3
Views: 946

Search the forums, this has been discussed a number of times before and should be easily found. However, specific to your message... From the Project directory where this job lives, find the "BP" directory associated with this Job Number - 298. So, cd into RT_BP298 and then view the "JOB.xxx" file n...
by chulett
Fri Apr 04, 2008 9:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job run stats
Replies: 8
Views: 2469

I think the question is whether ETLStats can gather data from parallel jobs, and the answer to that question is "yes". Of course, and which I answered. They will run just fine as Server jobs and yes, even work to gather stats from PX jobs And then Kim clarified re: individual partition counts. Curi...
by chulett
Fri Apr 04, 2008 4:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job run stats
Replies: 8
Views: 2469

There's absolutely no reason to transform these into Parallel jobs. They will run just fine as Server jobs and yes, even work to gather stats from PX jobs - stats is stats. And the simplest solution to your ODBC issue is to create an ODBC connection for Oracle using either the thick or thin drivers ...
by chulett
Fri Apr 04, 2008 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: problem in scheduling jobs
Replies: 6
Views: 1235

First off, please communicate in formal English here, not everyone has it as their native language and it helps tremendously if people don't abbreviate the crap out of their messages. Now... Director works the same way as the command line does by default. It will only show you schedules for jobs tha...
by chulett
Fri Apr 04, 2008 2:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: problem in scheduling jobs
Replies: 6
Views: 1235

Single runs use 'at' while multiple occurances use 'cron'. Are you checking from the command line using the same user that scheduled the jobs?
by chulett
Fri Apr 04, 2008 1:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import SQL Server Stored Procedure
Replies: 4
Views: 1121

Not really a 'work around', per se, as your importing user does need execute permissions on the proc to be able to 'see' it.
by chulett
Fri Apr 04, 2008 11:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unlocking Jobs through scripts.
Replies: 3
Views: 761

I think Uncle Kim does this in his backup scripts as well.
by chulett
Fri Apr 04, 2008 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 5036

So you run it "on Vista" by installing XP Pro in a virtual environment under Vista. Sorry, but that made me chuckle. :D

I wonder if *that* combination is supported?
by chulett
Fri Apr 04, 2008 9:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage problem
Replies: 8
Views: 1897

Well, you can use a folder as a target but it's not something I've played with yet. Allegedly it will create multiple files in the designated folder based on something akin to an XML 'trigger column' I believe. However, the problem as stated is that records are not even getting "into the transformer...
by chulett
Fri Apr 04, 2008 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem while compiling DS Sequence
Replies: 2
Views: 932

Permissions? Filesystem full? Any other messages?
by chulett
Fri Apr 04, 2008 7:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: delimiter for dates of the format 12/01/2008
Replies: 6
Views: 1159

Either ask whomever created the file or open the "csv" with an editor that will allow you to discern the delimiter. Word, for example, can show you tabs versus spaces with the proper option enabled.
by chulett
Fri Apr 04, 2008 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Memory leaks on Linux
Replies: 4
Views: 1388

The memory does NOT return if we bring down the engine. Also, they told me that when they start the machine without starting the DS engine the memory still 'disappears' after a short time. Ah... in that case, even if IBM has this as a known issue, the issue is with either Linux itself or some other...
by chulett
Fri Apr 04, 2008 7:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage problem
Replies: 8
Views: 1897

Well, if it ain't going to the transformer, explain how you've configured the source Folder stage. What are you using for the Wildcard property, for example?
by chulett
Fri Apr 04, 2008 7:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence getting aborted due to Heap allocation failed.
Replies: 4
Views: 1730

Yah, it's not like we've never talked about that error before.
by chulett
Fri Apr 04, 2008 7:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting Data from Lotus Notes
Replies: 2
Views: 1416

Right - the alternate is something like 'Notes Pump' - a product that will push Notes data elsewhere, like a database staging table where you can then process it from there.