Search found 53125 matches

by ray.wurlod
Tue Feb 28, 2006 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ETL errors while running batch schedule
Replies: 13
Views: 8681

Looks like your system can't handle the total load, as indicated by the "unable to start PHANTOM process" message. "PHANTOM" is just DataStage terminology for a background process. Involve your UNIX administrator to check the size of the process table and the size of the per-process number of backgr...
by ray.wurlod
Tue Feb 28, 2006 8:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fundamentals of Basics Routines
Replies: 21
Views: 5659

There are, indeed, other ways to write routines, including in text files outside of DataStage. But let's not muddy the waters!
by ray.wurlod
Tue Feb 28, 2006 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error when writing records to hash file
Replies: 13
Views: 3155

Chances are that you have corrupted the hashed file, so you will need to delete it and re-create it. Or just clear it of contents, which may be easier. To resize a hashed file to 64-bit, you need RESIZE, for which you will need a VOC pointer. Search the forum for SETFILE. The Hashed File stage does ...
by ray.wurlod
Tue Feb 28, 2006 8:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parallel jobs defined
Replies: 1
Views: 866

Maximum page file size should be at least three times physical memory size.
by ray.wurlod
Tue Feb 28, 2006 8:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting this weired CANNOT OPEN FILE DS_JOBOBJECTS
Replies: 5
Views: 1928

Incorrect indexes will not generate a "cannot open file" message.
by ray.wurlod
Mon Feb 27, 2006 7:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: getting this weired CANNOT OPEN FILE DS_JOBOBJECTS
Replies: 5
Views: 1928

Either your project is not properly installed or the DS_JOBOBJECTS hashed file has become corrupted. Either is potentially catastrophic. Have you ever been able to create jobs in that project? If not, delete the project and create it afresh.
by ray.wurlod
Mon Feb 27, 2006 2:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern Matching in Filter Stage
Replies: 9
Views: 3411

How about "abc*" which is a UNIX regular expression?
by ray.wurlod
Mon Feb 27, 2006 2:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation problem - unable to see the full palette
Replies: 16
Views: 5173

Don't worry about the warning - it's a leftover from the first release after they decided to change the licensing strategy from per-project to per-CPU. You do have parallel extender installed in that project. Does this symptom occur on all clients connected to server2, or just one? If just one I gue...
by ray.wurlod
Mon Feb 27, 2006 12:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern Matching in Filter Stage
Replies: 9
Views: 3411

Put on your cynical hat and read the manual again. It says "supports standard SQL expressions, except when comparing strings".
Later, when talking about like, it says "like 'abc' (the second operand must be a regular expression)".
So maybe try using a regular expression as the argument for like.
by ray.wurlod
Mon Feb 27, 2006 12:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation problem - unable to see the full palette
Replies: 16
Views: 5173

Use the Administrator client to verify that parallel job capability (Enterprise Edition) is correctly licensed on the server. Issue the CONFIG command from the Command window; if parallel job capability is licensed you will see a message to the effect that "-DSPX package is installed".
by ray.wurlod
Mon Feb 27, 2006 10:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Control General Question
Replies: 30
Views: 9255

I believe IBM will introduce something BAD, if only because it's a three letter acronym! :lol:
by ray.wurlod
Mon Feb 27, 2006 10:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection Problem
Replies: 2
Views: 936

Are you running on Windows XP? It may be that the machine needs to have its network card active - that is, the machine must be participating in a network.
by ray.wurlod
Mon Feb 27, 2006 10:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DsJobReport failed to open directory
Replies: 3
Views: 3441

It looks, from the error message, like you've mis-spelled the function name as DoJobReport. Please check.
by ray.wurlod
Mon Feb 27, 2006 10:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fundamentals of Basics Routines
Replies: 21
Views: 5659

Custom UniVerse functions were originally intended for DataStage customers who already had their business rules functions written in the UniVerse database, which was the original engine for DataStage. This is no longer the case, so it's a requirement that is likely to atrophy in DataStage. As a begi...
by ray.wurlod
Mon Feb 27, 2006 10:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installation problem - unable to see the full palette
Replies: 16
Views: 5173

Can you see all stage types when you choose Customize Palette ? If so your quick fix is to customize the palette and load all parallel stage types.