Search found 53125 matches

by ray.wurlod
Fri Nov 06, 2009 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project deelete
Replies: 6
Views: 1783

Please provide exact error message. The project is recorded both in system tables on the Engine tier (DataStage) and the Repository tier (XMETA).
by ray.wurlod
Fri Nov 06, 2009 2:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: usage analysis
Replies: 1
Views: 720

It is well described in the manuals, and in the on-line help. I provided a reasonably detailed answer to a similar question (albeit for version 8) on DSXchange as recently as this week. Did you Search?
by ray.wurlod
Fri Nov 06, 2009 2:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: stringtoTimestamp Conversion
Replies: 3
Views: 4467

You have to do it without the expression editor open. To put it another way, right click on the red expression, not on the opened expression.
by ray.wurlod
Fri Nov 06, 2009 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to execute orchadmin commands
Replies: 10
Views: 20813

There are no spaces either side of the "=" when setting environment variable values. You also need to export the variable if you are using a Bourne shell or similar. Find examples in your dsenv script.
by ray.wurlod
Fri Nov 06, 2009 1:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashfile query
Replies: 4
Views: 1437

A good example exists in the DS_AUDIT hashed file. There are three columns that record the date/time modified, by whom modified and reason for modificiation. In the DS_AUDIT table there is one record for each repository object. Any one repository object may have been modified 0, 1 or more times. The...
by ray.wurlod
Fri Nov 06, 2009 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling two different jobs
Replies: 2
Views: 1490

For example the precursor job could simply write the count into its user status area, which the triggers from the precursor job's Job activity can interrogate directly to determine what happens next.

Code: Select all

  precursor  ----->  Job2
     |
     +----->  Job1  ----->  Job2
by ray.wurlod
Fri Nov 06, 2009 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborts, then won't compile
Replies: 8
Views: 2649

Re-booting the server clears shared memory, including the lock tables, the T30FILE structure, and any public shared caches for hashed files.
by ray.wurlod
Fri Nov 06, 2009 1:45 pm
Forum: General
Topic: How does upsert or Update exisiting or insert new recs work
Replies: 3
Views: 1372

No documented information is available on this quesion. I used to believe that your second option was the way it works, but have no way to be certain.
by ray.wurlod
Thu Nov 05, 2009 7:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Diff Between Lookup, Join And Merge
Replies: 1
Views: 1471

Lookup stage is for small reference data sets where exact or range lookup capability is required. Duplicates of the lookup key are permitted in the stream input - each will be looked up separately. Lookup stage is also indicated if you need to access huge data sets directly from the database tables ...
by ray.wurlod
Thu Nov 05, 2009 4:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Set Error
Replies: 4
Views: 2871

It's definitely that, and it's the field called SMPL_RQSTD_IND that is your problem. Do you have a Modify stage upstream or downstream of this Data Set stage?
by ray.wurlod
Thu Nov 05, 2009 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to delete job from project
Replies: 1
Views: 978

This really is a vague message. The issue may be in the local project repository, in which case you can verify whether entries for the job exist in DS_JOBS and in DS_JOBOBJECTS. Once you have the job number, you can also verify the existence or otherwise of all the RT_*nnn tables for that particular...
by ray.wurlod
Thu Nov 05, 2009 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Director status showing job as running.
Replies: 5
Views: 1706

This behaviour usually occurs because the job is still receiving and logging warnings from, for example, a connected database server.
by ray.wurlod
Thu Nov 05, 2009 4:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Some Configuration file error.
Replies: 6
Views: 2080

Did anyone change APT_CONDUCTOR_HOSTNAME environment variable?
by ray.wurlod
Thu Nov 05, 2009 4:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Some error No conductor nodes found in export node pool.
Replies: 1
Views: 2053

It means what it says. The configuration file you are using today does not have any conductor nodes mentioned in the export node pool. This may be because you have specified APT_CONDUCTOR_HOSTNAME to be somewhere not mentioned in the configuration file. To be of much more help we would need to see t...
by ray.wurlod
Thu Nov 05, 2009 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter versus transformer
Replies: 6
Views: 2698

The Filter stage is in all 8.x versions.

Current advice from IBM is that the Transformer stage is to be preferred to the Filter or Switch stages, because the Transformer stage (nowadays) is compiled, while the other two are interpreted.