Search found 459 matches

by T42
Wed May 11, 2005 12:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Environment variable run time
Replies: 11
Views: 8463

Create an external routine/script and use that routine to call DataStage jobs, passing values to that particular job variable.
by T42
Wed May 11, 2005 12:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: [Help] Fatal error
Replies: 22
Views: 8755

Go to the UNIX prompt, and verify that the file exists on that directory.
by T42
Wed May 11, 2005 12:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error
Replies: 22
Views: 6618

ulimit -a. Verify that you (and dsadm) have the ability to create files that large.
by T42
Wed May 11, 2005 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Designer eats 100% CPU and is very slow
Replies: 9
Views: 4747

It really sounds like you got yourself in a really nasty feedback loop somewhere. Hitting on my sources, there appears to be a lack of mention about this problem.

Hit up Ascential Support, even though I doubt they would be able to duplicate your problem. But then, you may get lucky.
by T42
Wed May 11, 2005 12:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to develop datastage job
Replies: 4
Views: 1638

Read up the Parallel Development Guide on 'Copy Stage' and 'Funnel Stage'. For Table 4 - Copy - 21 links -> Funnel -> output For Table 5 - Copy - 18 links -> Funnel -> output As for Table 2 and 3, the same thing above can be done, with a remove duplicate stage, or maybe a transformer, or other optio...
by T42
Wed May 11, 2005 12:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: checking for null values
Replies: 7
Views: 3874

What does your source file use to say, 'This field is a null?'
by T42
Wed May 11, 2005 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Solaris 5.10
Replies: 10
Views: 4585

1. Did you read the Install and Upgrade Guide document?

2. Are you installing using the root account?

Edit: Solaris 5.10? There is no such thing. The only supported version of Solaris for DataStage is 2.8 and 2.9 (8 and 9).
by T42
Wed May 11, 2005 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to increase memory usage on HPUX
Replies: 15
Views: 9058

You also need to remember, not only ONE process is used for sorting, especially with multiple nodes. It is not a cumulative value, but an individual value you are setting there.
by T42
Wed May 11, 2005 11:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using GNU c++ compiler with PX
Replies: 11
Views: 8400

More information here:

http://gcc.gnu.org/

You can also do a google search for "GCC".
by T42
Tue May 10, 2005 10:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: [Still a problem] Unable to initialize plug-in:
Replies: 9
Views: 2788

64 bit clients are NOT supported for use with DataStage at this time. There may be several client-specific releases that tentatively support that, but as far as I know, you must use 32 bit clients.

Sorry.
by T42
Tue May 10, 2005 10:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: checking for null values
Replies: 7
Views: 3874

Are you using APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL? Or are you using a specific field information to define NULL values from input sequential file?

How do you identify whether the input data on a file is a null?
by T42
Tue May 10, 2005 10:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to develop datastage job
Replies: 4
Views: 1638

Could use Pivot Stage. Better off using Copy Stage -> Funnel.
by T42
Tue May 10, 2005 10:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Update Environment variable run time
Replies: 11
Views: 8463

And when you migrate your job with that environment variable to other platforms or projects that have different values, your job still have the default value preserved -- over-riding what the project/system/universe/everything/42 values are. This is why I advise all of my clients to not rely on proj...
by T42
Tue May 10, 2005 10:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using GNU c++ compiler with PX
Replies: 11
Views: 8400

Unfortunately, C++ is an ever-changing language, and not stabilized by any means. One version of a compiler on one platform can be entirely different than the same version on another platform. So the advice is to ONLY USE THE SUPPORTED COMPILER NOTED ON YOUR INSTALL GUIDE. In other words, you're not...
by T42
Tue May 10, 2005 10:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problems inserting a row in a table with identity column
Replies: 10
Views: 13452

Please paste your SQL statement. I have a sneaking suspicion about something.