Search found 53125 matches

by ray.wurlod
Wed Oct 15, 2008 3:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple UserID's
Replies: 3
Views: 889

Access is governed through operating system groups. Create a group that will be associated with this project, giving that group all privileges. Make the new user the only member of that group, and associate that group only with the DataStage Developer role for that project.
by ray.wurlod
Wed Oct 15, 2008 3:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No output from Hashed file into transformer
Replies: 7
Views: 1566

... or a Hashed File stage, which is faster than a UV stage for lookups. Can you please sketch out your job design showing the stage types used?
by ray.wurlod
Wed Oct 15, 2008 2:55 pm
Forum: General
Topic: Back up scheduling details of scheduled tasks
Replies: 4
Views: 1631

Is that still true in version 8, or does an Information Server scheduling service get involved? (I don't currently have access to version 8 to check.)
by ray.wurlod
Wed Oct 15, 2008 2:52 pm
Forum: IBM QualityStage
Topic: Using Quality stage
Replies: 1
Views: 1407

1) Yes, but only one client (Designer).

2) Yes.

3) Yes. Though the story here changes once you move to version 8.0.

4) Yes.

5) QualityStage can and should be used in production, for standardization, matching and survivorship.
by ray.wurlod
Wed Oct 15, 2008 1:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fileset Error
Replies: 3
Views: 1192

Premium membership is not expensive, at less than 30c (Rs12) per day.
by ray.wurlod
Tue Oct 14, 2008 6:39 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Can SFTP be used within FTP plug in Stage
Replies: 3
Views: 2433

There's no such thing as an FTP plug in stage in ProfileStage. Please post in the correct forum.
by ray.wurlod
Tue Oct 14, 2008 3:11 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: profiling time and space ?
Replies: 7
Views: 4289

Use DB2 Control Center to see which tablespaces are used in IADB and ANALYZERPROJECT and the amount of space allocated to and used by each. Table space management is usually set to "automatic".
by ray.wurlod
Tue Oct 14, 2008 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fileset Error
Replies: 3
Views: 1192

You have created a Data Set using a Data Set stage; now you are trying to access it with a File Set stage. Data Sets and File Sets are both different and incompatible. You must use one or the other consistently.
by ray.wurlod
Tue Oct 14, 2008 2:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Applying UTF-8 to all jobs of project
Replies: 6
Views: 1316

You can change the default for a project using the Administrator client.
by ray.wurlod
Tue Oct 14, 2008 2:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 174 Phantom 4400
Replies: 2
Views: 1584

You have a corrupted hashed file. It may be one that the job is using, or it may be one that is part of the repository database. Is there another warning message, perhaps when you reset the job, that might indicate the name of that hashed file? That's the one that you need to RESIZE.
by ray.wurlod
Mon Oct 13, 2008 3:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: importing a file with record delimited by HEX 0A
Replies: 4
Views: 2024

Observe that 0A (hex) is 10 (decimal). This is a regular UNIX newline (or linefeed if you prefer that terminology).
by ray.wurlod
Mon Oct 13, 2008 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Spliting data using transformer vs filter stage
Replies: 6
Views: 1922

Would you like to repeat the tests with slightly more complex conditions, maybe an OR conjunction or a leading-wildcard LIKE condition?
by ray.wurlod
Mon Oct 13, 2008 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Eliminate NLS warning msg ??
Replies: 4
Views: 2872

Lose the "ING". The command is DS.REINDEX ALL and must only be done when you have exclusive use of the project.
by ray.wurlod
Mon Oct 13, 2008 3:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to achieve not(notfound()) results in parallel
Replies: 3
Views: 1371

The Lookup stage has a "lookup failed" rule - you program it as you require. If you want to continue processing the stream input row where lookup failed, you set the rule to "Continue" and test a lookup key column for being null. The change detection stage types allow you to set a code value for the...
by ray.wurlod
Mon Oct 13, 2008 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while allocating an enviromental handle for DB2
Replies: 1
Views: 738

What has changed between "some time ago" and now? "Nothing" is not the correct answer.