Search found 53125 matches

by ray.wurlod
Thu Jun 17, 2010 11:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to connect to DB2
Replies: 6
Views: 4965

I have seen this before, but can't recall if there's a fix or workaround. Check the PATH environment variable for the executing user: (a) after executing dsenv at the command prompt (b) in the environment variables reported in the job log I think you may find that DS has destroyed the PATH that was ...
by ray.wurlod
Thu Jun 17, 2010 10:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML error:Caught unknown exception from runLocally()
Replies: 23
Views: 13166

Wrap your "ASCII art" in Code tags so that spacing is preserved. Then we may have some possibility of understanding what's connected to what.
by ray.wurlod
Thu Jun 17, 2010 5:54 pm
Forum:
Topic: How to access reports from DataStage Generate Report?
Replies: 7
Views: 5346

Yes, you get that but, after you generate the report there's another message box. It probably contains something like /reportingSendFile/sentFile/tempfolder1276818579455%2Fjobname.htm as well as a link to the Reporting Console. Clicking on the first link opens the report directly. If you open the re...
by ray.wurlod
Thu Jun 17, 2010 5:46 pm
Forum: General
Topic: New licensing policy / new LicenseServiceAdmin tool
Replies: 1
Views: 3914

Yes, it is there, and -list_features behaves as advertised. I still think the "upload license file" utility in Web Console is easier to use, and does not expose a password on the command line.
by ray.wurlod
Thu Jun 17, 2010 5:18 pm
Forum:
Topic: How to access reports from DataStage Generate Report?
Replies: 7
Views: 5346

When you generate the report there's a link to view the report that pops up in a message box. This is actually the key to the relevant table in the metadata repository. Follow this link and you'll find yourself in the correct place within the reporting console.
by ray.wurlod
Thu Jun 17, 2010 5:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: convert function to strip out comma character
Replies: 4
Views: 1476

Capture the value of var1 and svDomain, perhaps using an in-link Peek stage - what's in them for the rows where a comma still gets through?
by ray.wurlod
Thu Jun 17, 2010 5:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset occupying a lot more space compared to a text file.
Replies: 11
Views: 6508

No, I meant cat /path/fileset.fs (these are easier, since there's no binary data - but you can do something similar with ".ds" files).
by ray.wurlod
Thu Jun 17, 2010 5:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to install NLS for Chinese characters
Replies: 6
Views: 1610

Re: Need to install NLS for Chinese characters

I Need to install NLS for Chinese characters Go ahead. Do it. Make sure you get the right map (simplified or traditional) for the character set in your data. (1 Chinese character is equal to 2 bytes). This is not necessarily the case, particularly for traditional Chinese, which may have 1, 2, 3 or ...
by ray.wurlod
Thu Jun 17, 2010 5:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fast Track - how to define target sequential files
Replies: 4
Views: 1911

Nothing. FastTrack ALWAYS uses connectors. It will assume that the ODBC driver for text files is intended.
by ray.wurlod
Thu Jun 17, 2010 5:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unable to access Infosphere server through any of clients
Replies: 10
Views: 8492

ulimit -d should probably be larger, ideally unlimited.
by ray.wurlod
Thu Jun 17, 2010 5:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Application stalled DSDesign.exe
Replies: 7
Views: 3397

Would not be surprised if this is something in XP SP3. I've not seen it, but I've studiously avoided upgrading beyond SP2.
by ray.wurlod
Thu Jun 17, 2010 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 8.1 server license
Replies: 1
Views: 926

IBM will resist it, but it IS possible to buy just server edition in version 8.1.

Just remember: "the customer is always right".

You will miss out on many new features in Information Server, but will get some useful new server features.
by ray.wurlod
Thu Jun 17, 2010 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup table with multiple values as output!!
Replies: 3
Views: 1385

Looks like there's a "<> 'C'" condition somewhere in the logic too. Do provide us with your specification of business logic.
by ray.wurlod
Thu Jun 17, 2010 4:47 pm
Forum: General
Topic: New licensing policy / new LicenseServiceAdmin tool
Replies: 1
Views: 3914

Interesting. A month ago I installed 8.1, FP1 and Foundation Tools (8.1.2) using a customer-specific licensing XML file. Will need to go back to see whether the LicensingServiceAdmin tool is present.
by ray.wurlod
Thu Jun 17, 2010 4:44 pm
Forum:
Topic: How to access reports from DataStage Generate Report?
Replies: 7
Views: 5346

The directory you specify is for the intermediate XML files, not for the report itself. The report goes into the common metadata repository. To view the report, open the Web Console for Information Server on the Reporting tab, choose Reports from the navigation menu, find your DataStage report, and ...