Search found 53125 matches

by ray.wurlod
Thu Nov 12, 2009 1:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to initialize plug-in
Replies: 33
Views: 22793

You can use uvsh or dssh instead of uv to gain interactive access.
by ray.wurlod
Thu Nov 12, 2009 1:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: CLI0102E Invalid Conversion SQLSTATE=07006
Replies: 6
Views: 4958

Maybe Murali is being paid by the hour?
:wink:
by ray.wurlod
Thu Nov 12, 2009 1:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Status in Server transformer
Replies: 11
Views: 3936

Best practice is to include a call to DSDetachJob() once you've finished with the job.
by ray.wurlod
Thu Nov 12, 2009 1:07 pm
Forum: General
Topic: SURROGATE KEY IN DATASTAGE
Replies: 3
Views: 3251

Consider the possibilty that your "always running" symptom is not caused by the keys being generated but by the fact that you have designed an infinite loop into your job.
by ray.wurlod
Thu Nov 12, 2009 1:05 pm
Forum: General
Topic: VC++ 2005 Express -- How to acquire now?
Replies: 6
Views: 2385

Welcome aboard. One of my customers tracked it down as recently as last week (and, yes, it was not easy to find). Stay tuned - I'll ask where he found it.
by ray.wurlod
Thu Nov 12, 2009 1:02 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Installing Information Analyzer
Replies: 3
Views: 2107

You do need to create IADB (and its owner) before installing Information Analyzer. This is because you must provide that information to the installer. You will also need to create ODBC DSNs to IADB from both the engine tier and the client tier. The "steps" are basically to run the installe...
by ray.wurlod
Thu Nov 12, 2009 3:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin command execution
Replies: 7
Views: 3546

No spaces around the "=" characters when setting variables.

You probably also need to export the variables.
by ray.wurlod
Thu Nov 12, 2009 3:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key State File Update problem
Replies: 1
Views: 1708

In theory what you are describing is not possible. You can not get a key value of 157 out of a newly-created state file that has been initialized to 300001. Therefore what you are experiencing may be a bug. Report it to your official support provider and ask whether it's a known issue and, if so, wh...
by ray.wurlod
Thu Nov 12, 2009 3:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IS installation error
Replies: 4
Views: 2506

If they could, they would (when they're awake in their time zone).

Error code 2 usually means "file not found or inaccessible". Are you performing this installation as root with a umask of 022 ?
by ray.wurlod
Thu Nov 12, 2009 3:43 am
Forum: General
Topic: OCI FETCHED ERROR
Replies: 2
Views: 1259

It means exactly what it says.

This may result, for example, from your metadata (your table definition used in the Columns grid in your OCI stage) specifying a field size too small for the actual column in the Oracle table.
by ray.wurlod
Wed Nov 11, 2009 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: surrogate key
Replies: 4
Views: 1919

The difference is in persistence of the lock on the sequence. Review the source code of each routine to ascertain the difference.
by ray.wurlod
Wed Nov 11, 2009 8:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate list of projects in an environment
Replies: 1
Views: 1260

You can install dsjob anywhere (though you may need to obtain a Windows version (dsjob.exe) and associated DLLs from your support provider).
by ray.wurlod
Wed Nov 11, 2009 8:30 pm
Forum: General
Topic: DSJOB Help
Replies: 4
Views: 2041

Welcome aboard.

Was any other diagnostic information emitted? Do some research to learn what error code 3 means (for example error code 2 means "file not found or inaccessible").
by ray.wurlod
Wed Nov 11, 2009 5:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling an Oracle Materlized View
Replies: 6
Views: 2147

If you're going to refresh it every time you're about to select from it, why bother? Why not just select from an equivalent regular view, or even from the view definition?